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 CopyGot to A1 of Sheet3Paste
Mark rows form row 2 on sheet2 to endCopygot to first empty row of
Sheet3Paste

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

Make the source for your Pivot Table =myData
--
Regards
Roger Govier

balurrpr wrote:
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,

Not getting the things

any other option ?





"Roger Govier" wrote:

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 CopyGot to A1 of Sheet3Paste
Mark rows form row 2 on sheet2 to endCopygot to first empty row of
Sheet3Paste

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

Make the source for your Pivot Table =myData
--
Regards
Roger Govier

balurrpr wrote:
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
.