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 exce
files with each 20 sheets (named: 'XXX001' - 'XXX040')
Problem is that the layout of the master file has changed, and I nee
to copy most of the data to the new files, with the master file layou
(named: 'YYY001' - 'YYY040')
Most of the cells are protected and the layout of the sheets hav
changed, so I can't copy entire sheets. :(
So I can only copy the cells that I filled in (and are thu
unprotected)...

My question is now:
Is it possible to record a Macro. Where the first time I show exce
which cell to copy from the old file and where to copy the data in th
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 fil
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 b
very thankful !

Thanks in advance
Stefaan
aka Crup

--
Crup
-----------------------------------------------------------------------
Crupa's Profile: http://www.excelforum.com/member.php...fo&userid=1041
View this thread: http://www.excelforum.com/showthread.php?threadid=31495