Need help for getting output

  • Thread starter Thread starter balurrpr
  • Start date Start date
B

balurrpr

have information from different people and want to consolidate it in one
single sheet using pivot tabel (without using macro)

sample-

Data - 1

Name Date Org Status Tiff #
Anita 14-Apr-10 it processed 123
Anita 14-Apr-10 it pending 126
Anita 15-Apr-10 datex pending 128

Data 2

Name Date Org Status Tiff
Rahul 14-Apr-10 it processed 131
Rahul 15-Apr-10 datex pending 134
Rahul 15-Apr-10 datex processed 135



it is a continues process day by day

both data are from different excel sheet want it in one sheet
 
Hi
Without using a macro you can only do a manual copy and paste

Set up a New sheet.
Mark all rows for Sheet 1 Copy>Got to A1 of Sheet3>Paste
Mark rows form row 2 on sheet2 to end>Copy>got to first empty row of
Sheet3>Paste

Base your Pivot Table on Sheet3
On sheet3, create a Dynamic Range.
Insert>Name>Define
Name myData
Refers to =INDEX($1:$65536,COUNTA($A:$A),COUNTA($1:$1))

Make the source for your Pivot Table =myData
 
Back
Top