Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Copying Data
Dear all,
I've a workbook with several worksheets, namely "Jan06", "Feb06"......and "Summary". This Summary worksheet consolidates all data from columns A, B & E of all other worksheets in the same workbook(they are identical). Every time when I filled in all records for that month, I've to copy the data from columns A, B & E to the "Summary" worksheet for further analysis purpose. Is there a macro which can copy those required data from any of the worksheets automatically to the first blank row in the "Summary" worksheet? If yes, please write me that macro. Thanks in advance. Best regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying data as static as source data changes | Excel Worksheet Functions | |||
Auto updating pivot tables using external XML data | New Users to Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Copying Filtered Data | Excel Discussion (Misc queries) |