| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to update data from multiple sheets to one specific sheets
In worksheet 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 | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update same charts in multiple sheets at once | Excel Worksheet Functions | |||
| Update multiple sheets | Excel Worksheet Functions | |||
| Update multiple sheets at once | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| search multiple sheets for specific date, return data in cell to r | Excel Discussion (Misc queries) | |||
Threaded Mode
