Jeannie,

More information?

For instance, copy from where (workbook, worksheet, range), to where (same
details). How they are defined (pick the source book from an open file
dialog?, create a new workbook), etc.

You could also try to repeat those manual steps, but with the macro recorder
on. It will give you some start code, an d you could post that for
improvements, and to be made dynamic (different books etc.)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jeannie" wrote in message
oups.com...
Admission of being a Novice first of all, BUT so hungry to learn! That
said, I would greatly appreciate any advise on a project I'm working
on. Having a spreadsheet that tracks multiple types of data by weeks
for the entire year. Such as Transactions, Service, etc. Currently I
copy/paste the linking formulas from the current week to the next and
then copy/paste as values the previous week. This is because the
linked files are over written each week. I would like a formula or VBA
that could do a compare or something that if called upon it would
automatically copy/paste these formulas for me instead of the manual
process in place now. Or do you think there would be a better way?
Again thank you in advance for you expertise!