Data dependent on date

[smbridges]

Good Morning,

I have an excel spreadsheet where I input certain data per week and for each additional week I have to create a new sheet. I was wondering how could I make it where I could have a drop down of the date and then enter my numbers for the week and it save the numbers I enter and I can refer back to them by using the drop down.

Make sense?

 

[oldbrewer]

why are you creating a new sheet each week ?

 

[smbridges]

For each week I have different data inputed.
Like Monday the 23rd has one value, but last Monday had another value. Each week is different values for each day, but I am creating new sheets each week so that the old data could be saved rather than erased.

 

[oldbrewer]

if you put the dates in col A and the values in column B it is very easy say to total the values between 2 specified dates, or to create a chart based on all wednesday values. even if you have 200 weeks of data = 1400 rows, analysis is simple. but maybe I am not grasping why you want new sheets for every week...

 

[smbridges]

Ok so I don't want multiple sheets, but am currently using it. I also don't need to total the values together between 2 different dates. Basically I'm wanting a history of numbers from dates prior.

I was hoping by having the cells reference the date it could pull up historical data.

 

[oldbrewer]

do you have only one data value for a date, or several. If only one it is very simple. Details in 2 minutes

 

[oldbrewer]

dates	values
01/04/2018	37
02/04/2018	48
03/04/2018	59
04/04/2018	70				enter date	07/04/2018
05/04/2018	81
06/04/2018	92
07/04/2018	103				103	< < < F8
08/04/2018	114
09/04/2018	125
10/04/2018	136				formula
					=OFFSET($A$1,MATCH($G$5,$A$2:$A$11,0),1)

<colgroup><col><col span="5"><col><col span="4"></colgroup><tbody>
</tbody>

 

[smbridges]

	Week of:		April 23
			4/23	4/24	4/25	4/26	4/27	4/28	4/29
			MONDAY	TUESDAY	WEDNESDAY	THURSDAY	FRIDAY	SATURDAY	SUNDAY
	Daily	6
	MPA	2
	DTM	1
	#	1

<colgroup><col><col><col><col><col><col><col span="5"></colgroup><tbody>
</tbody>

 

[smbridges]

That helps me get in the general direction.
It's actuiall pulling 4 different values for each date though.

 

[smbridges]

	Week of:		April 23
			4/23	4/24	4/25	4/26	4/27	4/28	4/29
			MONDAY	TUESDAY	WEDNESDAY	THURSDAY	FRIDAY	SATURDAY	SUNDAY
	Daily	6
	MPA	2
	DTM	1
	#	1

<colgroup><col style="mso-width-source:userset;mso-width-alt:768;width:16pt" width="21"> <col style="mso-width-source:userset;mso-width-alt:4278;width:88pt" width="117"> <col style="mso-width-source:userset;mso-width-alt:1316;width:27pt" width="36"> <col style="mso-width-source:userset;mso-width-alt:5522;width:113pt" width="151"> <col style="mso-width-source:userset;mso-width-alt:1133;width:23pt" width="31"> <col style="mso-width-source:userset;mso-width-alt:3620;width:74pt" width="99"> <col style="mso-width-source:userset;mso-width-alt:5522; width:113pt" span="5" width="151"> </colgroup><tbody>
</tbody>