Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Data Transfer
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Data Transfer
Hi Freshman
You don't need a macro to do this. If, for example, you want to add the data in A1 of each sheet totalled in the Summary sheet, simply go to the Summary Sheet and click in A1. Now type = and then click on the A1 cells in each sheet It might look like this =SUM(Jan06!A1+Feb06!A1..............) From then each time you change data in the sheet cells the summary sheet will change as well HTH Michael M "Freshman" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Data Transfer
Hi Mike,
Thanks for your help. May be I haven't raised my question clear. Sorry for the confusion. My question is not going to total all values in A1 of other worksheets to cell A1 in Summary worksheet. I want to copy every record in columns A, B & E of every worksheet to the Summary worksheet then I use them for analysis in a pivot table. Since the records are filled in month after month, so I want the completed records of the current month can be automatically copy to the row under the last record in the Summary worksheet, i.e. May06's records under Apr06's record. I hope this can make my question clear. Can you help in this aspect? Thanks once again. Regards. "Michael M" wrote: Hi Freshman You don't need a macro to do this. If, for example, you want to add the data in A1 of each sheet totalled in the Summary sheet, simply go to the Summary Sheet and click in A1. Now type = and then click on the A1 cells in each sheet It might look like this =SUM(Jan06!A1+Feb06!A1..............) From then each time you change data in the sheet cells the summary sheet will change as well HTH Michael M "Freshman" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Data Transfer
Sorry, I understand now.
Unfortunately, my VBA is only scratchy but I'm sure there will be other users that will have input and can fit you with a Macro Regards Michael M "Freshman" wrote: Hi Mike, Thanks for your help. May be I haven't raised my question clear. Sorry for the confusion. My question is not going to total all values in A1 of other worksheets to cell A1 in Summary worksheet. I want to copy every record in columns A, B & E of every worksheet to the Summary worksheet then I use them for analysis in a pivot table. Since the records are filled in month after month, so I want the completed records of the current month can be automatically copy to the row under the last record in the Summary worksheet, i.e. May06's records under Apr06's record. I hope this can make my question clear. Can you help in this aspect? Thanks once again. Regards. "Michael M" wrote: Hi Freshman You don't need a macro to do this. If, for example, you want to add the data in A1 of each sheet totalled in the Summary sheet, simply go to the Summary Sheet and click in A1. Now type = and then click on the A1 cells in each sheet It might look like this =SUM(Jan06!A1+Feb06!A1..............) From then each time you change data in the sheet cells the summary sheet will change as well HTH Michael M "Freshman" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
auto saving transfered data | Excel Discussion (Misc queries) | |||
How Do I Automatically Refresh Auto Filtered Data? | Excel Discussion (Misc queries) | |||
transfer data in excel between sheets | Excel Discussion (Misc queries) | |||
How do I transfer data between Excell sheets? | Excel Worksheet Functions |