Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy specific data form sheets into master sheet | Excel Worksheet Functions | |||
Combine multiple sheets (categories) into one master sheet | Excel Discussion (Misc queries) | |||
Other sheets to pick data from master sheet | Excel Discussion (Misc queries) | |||
Pulling information from master sheet to multiple sheets | New Users to Excel | |||
Moving data from master sheet to new sheets | Excel Worksheet Functions |