I would like to create an appointment book using as much automation as possible. I have a sheet with preformatted contents such as 'time', 'employee', 'reason for appointment', etc. The preformatted contents are in the range A1:Z18.I have another workbook with the company calendar. The workbook consists of 12 sheets, one for each month of the year. Under every date there is a box that we either fill with o, or fill in with x. X means a working day. O means not a working day.I need some way of taking all the cells with X on a sheet, and generating a workbook with as many sheets as there are x. So if there are 20 x (20 workdays in the month), the workbook should have 20 sheets. Each sheet should be automatically named after the cell that was above an x. So if Jan 2 had an x beneath, Jan 3 had an x beneath, etc., the workbook should have sheets named Jan 2 and Jan 3. Each sheet should be populated with the preformatted content from range A1:Z18.Then this should be repeated for all 12 sheets (months) in my calendar.I haven't found any code for generating an appointment book like this. If anyone has, please do advise.
How to create and name each new sheet in a google spreadsheet from a list
google spreadsheets;worksheet function;google sheets addons