Hi
I have a table that has a series of values in three columns,
A - date
B - time1
C - time2
I want to run a script that will take each date and create a separate worksheet for each value in column A (so 365 worksheets for a year) and then paste the three items to specific cells into a blank template. Date to B3, time1 to B5 and time2 to B7, then save the worksheet using the date as the name.
Thanks
I have a table that has a series of values in three columns,
A - date
B - time1
C - time2
I want to run a script that will take each date and create a separate worksheet for each value in column A (so 365 worksheets for a year) and then paste the three items to specific cells into a blank template. Date to B3, time1 to B5 and time2 to B7, then save the worksheet using the date as the name.
Thanks