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
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