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