Excelish12
New Member
- Joined
- Aug 24, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi
I have a worksheet that creates a schedule for venues based on same basic user input i.e. start and end date, times for days of the week. I have a formula that calculates the number of columns to insert after the start date column. I have so far been able to insert blank columns after the start date, to fill in the dates and to calculate the day of the week above the date.
What I cannot figure out is how to insert the formula for time going down and across. The VBA must only insert formulas down up to last row of data based on Venue column and must only fill formula data across up to the Duration Column.
P.S: columns are fixed up to the first date i.e. a user cannot insert any columns here but the columns after this are variable based on the end date.
What is the best way to go about this?
I have a worksheet that creates a schedule for venues based on same basic user input i.e. start and end date, times for days of the week. I have a formula that calculates the number of columns to insert after the start date column. I have so far been able to insert blank columns after the start date, to fill in the dates and to calculate the day of the week above the date.
What I cannot figure out is how to insert the formula for time going down and across. The VBA must only insert formulas down up to last row of data based on Venue column and must only fill formula data across up to the Duration Column.
P.S: columns are fixed up to the first date i.e. a user cannot insert any columns here but the columns after this are variable based on the end date.
What is the best way to go about this?