Master sheet into template, copy template to sheets named after master column.

Hi

I am doing some excel work for a volunteer run group who run bookable trips on specific dates. I receive the schedule of dates with the drivers names and time of the trip. I have managed to make up a workbook that creates worksheets for each scheduled trip date off a template that names the sheets as the date. They can then click on the date to get a form that they complete with childrens names, tel contact and next of kin contact, that they can send out to the drivers.

What I am struggling with is, to set into the template references that will carry the other date specific data of the schedule I receive. - driver name, start time, destination etc into each worksheet of the corresponding date.

Is there syntax that will allow me to code on the template a way to lookup the worksheet name, and reference the data in that date row on the schedule sheet. That way when I run the VBA code to create the worksheets for each date, the details of that dates trip go on the worksheet too?

I hope this makes sense.

Thanks Mariner

Making progress.

So far with no rants.

I found how to make a cell return the name of the worksheet. At the moment it just says template, but after I run the VBA it should return the worksheet name. Which will be a date.

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

Now to write reference to the CELL lookup in index column schedule and return row values into the template. i.e Driver name on the worksheet form should return the driver name on the schedule sheet by looking in the schedule column 1 for the CELL name/date and return the driver name from that row on to the form. Then for each cell I want to retain the data for.

Something like this:-

Image2.jpg