Need help for getting output

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
 
R

Roger Govier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top