Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In sheet 1 I have about 15,000 rows in the following columns
A1(Unique id) A2 Names of persons A3 Address A4 Amount for the year 2005 A5 Amount for the year 2006 A6 Amount for the year 2007 (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 2007 Same above column in sheet 3, sheet 4 and sheet 5 I have to update the rows of column A6 of sheet 1 through column A4 of sheet 2, sheet 3, sheet 4 and sheet 5 Please help to filter the data |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlink and Filter Data in Multiple Sheets | Excel Discussion (Misc queries) | |||
macro to find data and filter it and copy to another worksheet | Excel Programming | |||
Creating a macro to filter data on multiple sheets | Excel Programming | |||
Macro to Filter Information in Multiple sheets and Make graph | Excel Worksheet Functions | |||
Combine multiple sheets of data into one worksheet | Excel Discussion (Misc queries) |