Hello,

I'm rather a newby concerning Macro's and so I have a question:

I'm in the situation that I have filled in data in some 40 big excel files with each 20 sheets (named: 'XXX001' - 'XXX040')
Problem is that the layout of the master file has changed, and I need to copy most of the data to the new files, with the master file layout (named: 'YYY001' - 'YYY040')
Most of the cells are protected and the layout of the sheets have changed, so I can't copy entire sheets.
So I can only copy the cells that I filled in (and are thus unprotected)...

My question is now:
Is it possible to record a Macro. Where the first time I show excel which cell to copy from the old file and where to copy the data in the new file. (using the 'record new macro' function in excel)
So that for the other 39 files I just need to open the old and new file and run the macro.
Which would ofcourse save me a lot of time!

If somebody could guide me onto the right path to follow, I would be very thankful !

Thanks in advance
Stefaan
aka Crupa

it should actually be a simple matter. Record the macro as you would normally, then just add a form with a dialog control to allow you to select the old and new file each time. Pass the file names to your macro and the job is done :)