Filtering of data in a master excel sheet from multiple sheets
 

In a worksheet, sheet-1 is a master sheet which have about 15,000 rows in the
following columns
A1(Unique id)
A2 Names of persons
A3 Address
A4 Amount for the year 2006
A5 Amount for the year 2007
A6 Amount for the year 2008 (Blank / no date)

In sheet-2 I have 22,500 rows and have following columns
A1 (Unique id)
A2 Names of person
A3 Address
A4 Amount for the year 2008

In sheet-3 I have 12,000 rows and have following columns
A1 (Unique id)
A2 Names of person
A3 Address
A4 Amount for the year 2008

In sheet-4 I have 2,500 rows and have following columns
A1 (Unique id)
A2 Names of person
A3 Address
A4 Amount for the year 2008


I require automatic updation of all the rows of column A6 (from 01 to
15,000) of sheet 1 from column A4 of sheet-2, sheet-3 and sheet-4 with the
help of Unique ID.

Please help to filter the data as I urgently needs this macro or formula to
save my time to search each & every data.

Filtering of data in a master excel sheet from multiple sheets
 

Excel 2007 Tables, PivotTable
Consolidate tabs.
Transpose column blocks to rows.
Sum with PT.
No formulas, code aplenty.
http://c0444202.cdn.cloudfiles.racks.../01_23_10.xlsm

Filtering of data in a master excel sheet from multiple sheets
 

Dear Herbert Seidenberg, i this would not solve the problem or could not
understand the Pivot Table. As i only need to update the data in Sheet i.e.
all the rows of column A6 from sheet-2, sheet-3 & sheet-4 which exists on the
same worksheet.

"Herbert Seidenberg" wrote:

Excel 2007 Tables, PivotTable
Consolidate tabs.
Transpose column blocks to rows.
Sum with PT.
No formulas, code aplenty.
http://c0444202.cdn.cloudfiles.racks.../01_23_10.xlsm
.

Filtering of data in a master excel sheet from multiple sheets
 

The Pivot Table provides the data
to update Table7.
http://c0444202.cdn.cloudfiles.racks.../01_23_10.xlsm