Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COPYnPASTE from one workbook to multiple workbooks in the same fol
Hi there,
Could you please tell me how to paste from a single workbook to multiple workbooks in the same folder. I need to copy 5 columns to the same sheet on all the multiple workbooks. I need to copy it after column AN. I am new to programming. Thank you in this regard. Have a good day further. Jerome |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
COPYnPASTE from one workbook to multiple workbooks in the same fol
This will get you close to what you want on Ron DeBruin's site..
http://www.rondebruin.nl/tips.htm Check out the Copy/Paste/Merge examples. From what I remember on these examples are that the source workbook is in a different folder than the target workbooks. Perhaps you will find something here that fits, or you could temporarily move the source book long enough to make the copy, then put it back with the others. Mike F "Jerome" wrote in message ... Hi there, Could you please tell me how to paste from a single workbook to multiple workbooks in the same folder. I need to copy 5 columns to the same sheet on all the multiple workbooks. I need to copy it after column AN. I am new to programming. Thank you in this regard. Have a good day further. Jerome |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
COPYnPASTE from one workbook to multiple workbooks in the same fol
Use macros.
Tools-Macros-Record and then define the shortcuts and record down your multiply actions; Use this shortcut to apply to your other tables "Jerome" wrote: Hi there, Could you please tell me how to paste from a single workbook to multiple workbooks in the same folder. I need to copy 5 columns to the same sheet on all the multiple workbooks. I need to copy it after column AN. I am new to programming. Thank you in this regard. Have a good day further. Jerome |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
COPYnPASTE from one workbook to multiple workbooks in the same
Thank you for your response ... I appreciate it ... have a good day
"Mike Fogleman" wrote: This will get you close to what you want on Ron DeBruin's site.. http://www.rondebruin.nl/tips.htm Check out the Copy/Paste/Merge examples. From what I remember on these examples are that the source workbook is in a different folder than the target workbooks. Perhaps you will find something here that fits, or you could temporarily move the source book long enough to make the copy, then put it back with the others. Mike F "Jerome" wrote in message ... Hi there, Could you please tell me how to paste from a single workbook to multiple workbooks in the same folder. I need to copy 5 columns to the same sheet on all the multiple workbooks. I need to copy it after column AN. I am new to programming. Thank you in this regard. Have a good day further. Jerome |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
COPYnPASTE from one workbook to multiple workbooks in the same
Thank you for your response .... I appreciate it ... have a good day
"Aaron" wrote: Use macros. Tools-Macros-Record and then define the shortcuts and record down your multiply actions; Use this shortcut to apply to your other tables "Jerome" wrote: Hi there, Could you please tell me how to paste from a single workbook to multiple workbooks in the same folder. I need to copy 5 columns to the same sheet on all the multiple workbooks. I need to copy it after column AN. I am new to programming. Thank you in this regard. Have a good day further. Jerome |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine multiple workbooks into one workbook | Excel Discussion (Misc queries) | |||
Separating 1 workbook into multiple workbooks | Excel Discussion (Misc queries) | |||
Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
Combine multiple workbooks into one workbook | Excel Discussion (Misc queries) |