Prev: Keeping Workbook Name Out of Sheet When Copying to Different Book
Next: name tags
From: balurrpr on 14 Apr 2010 03:33
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
From: Roger Govier on 14 Apr 2010 04:14
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
--
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
From: balurrpr on 15 Apr 2010 05:12
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 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
> --
> 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
> .
>
 | 
Pages: 1
Prev: Keeping Workbook Name Out of Sheet When Copying to Different Book
Next: name tags