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!