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

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

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

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

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