Date sensitive?

Doulos48 · Mar 27th, 2002, 11:46 AM

I have a spreadsheet where there is one master sheet, which is linked to about 20 other sheets. Each individual sheet has a number of columns with information that is totaled up at the bottom and each column labeled at the top with at date for each week (ex: 3/25, 4/1, 4/8..etc). These totals for each week from each sheet are linked to the master sheet under the same dates. Now the problem is each week it all needs to get updated to where the week prior gets deleted and a new one at the end needs to be added (basically each sheet is planned out 6 months ahead so for example the week of 3/25 I would delete the week of 3/18 and add a new blank column, at the end of the sheet, labeled the week of 9/30 with the same formulas and link to the master as the others) everything needs to be moved over but still keep their same date and totals. I tried a macro but it was very messy. I don’t know if there is a formula that is date sensitive or something. Any suggestions?

Yogi Anand · Mar 27th, 2002, 01:01 PM

Hi Doulos48:
Welcome to the Board! Your explanation is quite clear. From what you described, your date formulas should be setup just one time, and then the weekly updates should happen automatically.
Can you post some data where the dates are not moving or whatever else the problem is? Then let us take it from there!

Doulos48 · Mar 27th, 2002, 02:09 PM

Thanks for responding...I am not sure how to post an example of what I am trying to do on the website in excel format...is that what you need me to do?

Yogi Anand · Mar 27th, 2002, 02:46 PM

Quote:

On 2002-03-27 13:09, Doulos48 wrote:
Thanks for responding...I am not sure how to post an example of what I am trying to do on the website in excel format...is that what you need me to do?

Hi Doulos48:
You are right ... it is hard to post it on the board!
If you want you can email it to me and then let us take it from there!

Mar 27th, 2002, 01:01 PM	#2
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi Doulos48: Welcome to the Board! Your explanation is quite clear. From what you described, your date formulas should be setup just one time, and then the weekly updates should happen automatically. Can you post some data where the dates are not moving or whatever else the problem is? Then let us take it from there! __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

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

Mar 27th, 2002, 11:46 AM	#1
Doulos48 New Member Join Date: Mar 2002 Posts: 2	I have a spreadsheet where there is one master sheet, which is linked to about 20 other sheets. Each individual sheet has a number of columns with information that is totaled up at the bottom and each column labeled at the top with at date for each week (ex: 3/25, 4/1, 4/8..etc). These totals for each week from each sheet are linked to the master sheet under the same dates. Now the problem is each week it all needs to get updated to where the week prior gets deleted and a new one at the end needs to be added (basically each sheet is planned out 6 months ahead so for example the week of 3/25 I would delete the week of 3/18 and add a new blank column, at the end of the sheet, labeled the week of 9/30 with the same formulas and link to the master as the others) everything needs to be moved over but still keep their same date and totals. I tried a macro but it was very messy. I don’t know if there is a formula that is date sensitive or something. Any suggestions?

Mar 27th, 2002, 02:09 PM	#3
Doulos48 New Member Join Date: Mar 2002 Posts: 2	Thanks for responding...I am not sure how to post an example of what I am trying to do on the website in excel format...is that what you need me to do?