Data dependent on date

S

smbridges

New Member
Joined
Apr 24, 2018
Messages
8
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?
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
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.
 
Upvote 0
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...
 
Upvote 0
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.
 
Upvote 0
do you have only one data value for a date, or several. If only one it is very simple. Details in 2 minutes
 
Upvote 0
[TABLE="width: 718"]
<colgroup><col><col span="5"><col><col span="4"></colgroup><tbody>[TR]
[TD]dates[/TD]
[TD]values[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]01/04/2018[/TD]
[TD="align: right"]37[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/04/2018[/TD]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03/04/2018[/TD]
[TD="align: right"]59[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]04/04/2018[/TD]
[TD="align: right"]70[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]enter date[/TD]
[TD="align: right"]07/04/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05/04/2018[/TD]
[TD="align: right"]81[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]06/04/2018[/TD]
[TD="align: right"]92[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]07/04/2018[/TD]
[TD="align: right"]103[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]103[/TD]
[TD]< < < F8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]08/04/2018[/TD]
[TD="align: right"]114[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]09/04/2018[/TD]
[TD="align: right"]125[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/04/2018[/TD]
[TD="align: right"]136[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]formula[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]=OFFSET($A$1,MATCH($G$5,$A$2:$A$11,0),1)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
[TABLE="width: 1210"]
<colgroup><col><col><col><col><col><col><col span="5"></colgroup><tbody>[TR]
[TD]
[/TD]
[TD="colspan: 4"][/TD]
[TD]
[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Week of:
[/TD]
[TD] [/TD]
[TD]April 23[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="colspan: 5"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4/23[/TD]
[TD="colspan: 2"]4/24[/TD]
[TD]4/25[/TD]
[TD]4/26[/TD]
[TD]4/27[/TD]
[TD]4/28[/TD]
[TD]4/29[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]MONDAY[/TD]
[TD="colspan: 2"]TUESDAY[/TD]
[TD]WEDNESDAY[/TD]
[TD]THURSDAY[/TD]
[TD]FRIDAY[/TD]
[TD]SATURDAY[/TD]
[TD]SUNDAY[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]Daily[/TD]
[TD="align: right"]6[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]MPA[/TD]
[TD="align: right"]2[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]DTM[/TD]
[TD="align: right"]1[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]#[/TD]
[TD="align: right"]1[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
That helps me get in the general direction.
It's actuiall pulling 4 different values for each date though.
 
Upvote 0

<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>
[TD="class: xl65, width: 21"] [/TD]
[TD="class: xl66, width: 117"]Week of:
[/TD]
[TD="class: xl66, width: 36"] [/TD]
[TD="class: xl67, width: 151"]April 23[/TD]
[TD="class: xl68, width: 31"] [/TD]
[TD="class: xl68, width: 99"] [/TD]
[TD="class: xl79, width: 755, colspan: 5"] [/TD]

[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl69"][/TD]
[TD="class: xl70"]4/23[/TD]
[TD="class: xl70, colspan: 2"]4/24[/TD]
[TD="class: xl70"]4/25[/TD]
[TD="class: xl70"]4/26[/TD]
[TD="class: xl70"]4/27[/TD]
[TD="class: xl70"]4/28[/TD]
[TD="class: xl70"]4/29[/TD]

[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl72"]MONDAY[/TD]
[TD="class: xl72, colspan: 2"]TUESDAY[/TD]
[TD="class: xl72"]WEDNESDAY[/TD]
[TD="class: xl72"]THURSDAY[/TD]
[TD="class: xl72"]FRIDAY[/TD]
[TD="class: xl72"]SATURDAY[/TD]
[TD="class: xl72"]SUNDAY[/TD]

[TD="class: xl73"][/TD]
[TD="class: xl77, width: 153, colspan: 2"]Daily[/TD]
[TD="class: xl89, width: 151"]6[/TD]
[TD="class: xl86, width: 130, colspan: 2"] [/TD]
[TD="class: xl74, width: 151"] [/TD]
[TD="class: xl74, width: 151"] [/TD]
[TD="class: xl74, width: 151"] [/TD]
[TD="class: xl74, width: 151"] [/TD]
[TD="class: xl74, width: 151"] [/TD]

[TD="class: xl73"][/TD]
[TD="class: xl81, width: 153, colspan: 2"]MPA[/TD]
[TD="class: xl90, width: 151"]2
[/TD]
[TD="class: xl85, width: 130, colspan: 2"] [/TD]
[TD="class: xl75, width: 151"] [/TD]
[TD="class: xl75, width: 151"] [/TD]
[TD="class: xl75, width: 151"] [/TD]
[TD="class: xl75, width: 151"] [/TD]
[TD="class: xl75, width: 151"] [/TD]

[TD="class: xl73"][/TD]
[TD="class: xl81, width: 153, colspan: 2"]DTM[/TD]
[TD="class: xl89, width: 151"]1[/TD]
[TD="class: xl86, width: 130, colspan: 2"] [/TD]
[TD="class: xl74, width: 151"] [/TD]
[TD="class: xl74, width: 151"] [/TD]
[TD="class: xl74, width: 151"] [/TD]
[TD="class: xl74, width: 151"] [/TD]
[TD="class: xl74, width: 151"] [/TD]

[TD="class: xl73"][/TD]
[TD="class: xl83, width: 153, colspan: 2"]#[/TD]
[TD="class: xl90, width: 151"]1[/TD]
[TD="class: xl85, width: 130, colspan: 2"] [/TD]
[TD="class: xl76, width: 151"] [/TD]
[TD="class: xl75, width: 151"] [/TD]
[TD="class: xl75, width: 151"] [/TD]
[TD="class: xl75, width: 151"] [/TD]
[TD="class: xl75, width: 151"] [/TD]

</tbody>
 
Upvote 0
You must log in or register to reply here.

Similar threads

O
  • Question Question
Calculating Average # of Procedures per Week
Replies
2
Views
306
RobP
R
C
  • Question Question
Analysing Data According to day of the week.
Replies
5
Views
194
Asbestos_Jen
Asbestos_Jen
T
  • Question Question
Populate Names against Dates and Course Names
Replies
2
Views
96
TerryE123
T
F
  • Question Question
Drop down list for weekly calculation
Replies
4
Views
309
fragment
F
M
  • Solved
Filter multiple options in return
Replies
5
Views
78
Joe4
Joe4

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top