Multi-Variable table search to fill horizontal calendar from data table

NatDeroxL7

New Member
Joined
Oct 25, 2023
Messages
3
Office Version
  1. 365
Platform
  1. MacOS
Trying to figure out how to get a horizontal daily calendar to fill with information from an open ended table. Basically, I want each employee to simply enter data into the table at the bottom, and the calender will built itself from colum C to the right for 2 years worth of dates.


Test Sheet .xlsx
ABCDEFGHIJKLMNOPQR
11-Oct-232-Oct-233-Oct-234-Oct-235-Oct-236-Oct-237-Oct-238-Oct-239-Oct-2310-Oct-2311-Oct-2312-Oct-2313-Oct-2314-Oct-2315-Oct-2316-Oct-23
2AConference StartConference EndNew Computers Start
3Employee hire dateCost54003400
4PositionFund SourceStore AStore C
5Activity TypeTravelPurchase
6BSales Trip StartSales Trip End
7Employee hire dateCost1200
8PositionFund SourceStore A
9Activity TypeTravel
10CInstall Storage StartInstall Storage End
11Employee hire dateCost3400
12PositionFund SourceStore B
13Activity TypeFacility Improvement
14DAdvertising StartAdvertising End
15Employee hire dateCost500
16PositionFund SourceStore B
17Activity TypePurchase
18
19
20
21NameStart DateEnd DateCostFund SourceActivity NameActivity Type
22A1-Oct-234-Oct-235400Store AConferenceTravel
23B5-Oct-2310-Oct-231200Store ASales TripTravel
24C1-Oct-2310-Oct-233400Store BInstall StorageFacility Improvement
25A9-Oct-239-Oct-231200Store CNew ComputersPurchase
26D7-Oct-2316-Oct-23500Store BAdvertisingPurchase
27List continutes indefinitely…....
Sheet1
Cell Formulas
RangeFormula
D1:R1D1=C1+1
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Also to note, the table can't need to be in any particular order, I need the employees to be able to just add things to it on the next line down at any time with no sorting etc.
 
Upvote 0
Correction to the original post / goal.

Trying to figure out how to get a horizontal daily calendar to fill with information from an open ended table. Basically, I want each employee to simply enter data into the table at the bottom, and the calendar will built itself from column C to the right for 2 years worth of dates. I also need it to work with the table at the bottom being in any order - I need the employees to be able to enter a new line at any time at the bottom without regard for it the dates or names or anything else is in a particular order. I specifically want the activity name to only show in the start and end dates boxes, but I want the activity type to fill every dates between the start and end dates, inclusive of the start and end dates. (So I can conditionally format with colors later on) Would be ideal if it automatically append the words "Start" and "End" to calendar entries as shown based on the start/end dates, but I could live without that.


Test Sheet (1).xlsx
ABCDEFGHIJKLMNOPQR
11-Oct-232-Oct-233-Oct-234-Oct-235-Oct-236-Oct-237-Oct-238-Oct-239-Oct-2310-Oct-2311-Oct-2312-Oct-2313-Oct-2314-Oct-2315-Oct-2316-Oct-23
2AConference StartConference EndNew Computers Start
3Employee hire dateCost54003400
4PositionFund SourceStore AStore C
5Activity TypeTravelTravelTravelTravelPurchase
6BSales Trip StartSales Trip End
7Employee hire dateCost1200
8PositionFund SourceStore A
9Activity TypeTravelTravelTravelTravelTravelTravel
10CInstall Storage StartInstall Storage End
11Employee hire dateCost3400
12PositionFund SourceStore B
13Activity TypeFacility ImprovementFacility ImprovementFacility ImprovementFacility ImprovementFacility ImprovementFacility ImprovementFacility ImprovementFacility ImprovementFacility ImprovementFacility Improvement
14DAdvertising StartAdvertising End
15Employee hire dateCost500
16PositionFund SourceStore B
17Activity TypePurchasePurchasePurchasePurchasePurchasePurchasePurchasePurchasePurchasePurchase
18
19
20
21NameStart DateEnd DateCostFund SourceActivity NameActivity Type
22A1-Oct-234-Oct-235400Store AConferenceTravel
23B5-Oct-2310-Oct-231200Store ASales TripTravel
24C1-Oct-2310-Oct-233400Store BInstall StorageFacility Improvement
25A9-Oct-239-Oct-231200Store CNew ComputersPurchase
26D7-Oct-2316-Oct-23500Store BAdvertisingPurchase
27List continutes indefinitely…....
Sheet1
Cell Formulas
RangeFormula
D1:R1D1=C1+1
 
Upvote 0

Forum statistics

Threads
1,223,886
Messages
6,175,198
Members
452,616
Latest member
intern444

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