Funny Story

Brian from Maui · Feb 28th, 2002, 11:30 PM

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

Mar 1st, 2002, 02:41 AM

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 · Mar 1st, 2002, 08:43 AM

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

Brian

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 11:30 PM	#1
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	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

Mar 1st, 2002, 02:41 AM	#2
Guest Posts: n/a	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.

Mar 1st, 2002, 08:43 AM	#3
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Glad I could make a contribution, although inadvertently..... Brian