Funny Story

[Brian from Maui]

Aloha,

I've been doing a spreadsheet with months as tabs...jan feb...etc. And I made a template and just copied sheet. I have same formula in all work sheets, just needed to change range reference jan to feb to mar etc. I've been doing it manually cell by cell. When all this time I could just go to edit/replace/type jan replace with feb. I feel so STUPID, I can only laugh!!!



Brian

 

[Guest]

Hello Brian,

hahaha... on me too. I've been doing the same thing month after month, copying my template to the new month and then manually replacing each link!

Thanks for the tip.

 

[Brian from Maui]

Glad I could make a contribution, although inadvertently.....

Brian