I'm self-employed in the broadcasting business. I use a spreadsheet to schedule the to-air broadcasts.
In the particular worksheet I have a column "Calendar" which displays the date of a scheduled broadcast, which also has an ID in the form of number.
Every broadcast is pre-recorded, often but not always a week prior to its to-air broadcast date. I book the pre-recording date at the same time as I schedule the to-air broadcast. So, I have another column, "Pre-Record" which displays the date of the particular broadcast's pre-recording .
In other words, I enter both dates into a single row, identified by the “Calendar” date. And the pre-recording date is always ahead of the "Calendar" date.
Currently when I look down the Calendar column, I see the broadcast scheduled for each date. But I have to eyeball the sheet to locate the date of its pre-recording. This is risky, so I would like to automate things.
My idea is to have a new column adjacent to the existing Calendar column. This would present the ID of the broadcast that is to be pre-recorded on the day displayed in the Calendar column.
Thus would the particular row defined by the "Calendar" date present the ID of a pre-recording that is to be made on the particular "Calendar" date. Then I could quickly identify the broadcast that is to be pre-recorded on the particular day.
Can I do this programmatically and, if so, what would be the best approach, please?