condense macro

[nicko54]

Hi there,

I have recorded a macro to copy data from one workbook and paste into sheets into other workbooks then save and close.

Please Login or Register  to view this content.

It works, but is there anyway I can condense the macro...

any ideas welcome.

many thanks,

Nicko

[pike]

hi nicko54
Try this loop with an array of files

Please Login or Register  to view this content.