I have a workbook that has a Master Roster Sheet and a Template sheet among others. The Master Roster sheet can and does change frequently from event to event. The Template sheet has cells that are populated from the Master Roster Sheet. I currently manually create a new copy of the template sheet for each row that is not blank within a range on the Master Roster sheet and then go to each sheet and repair the cell reference back to the Master Roster row for that individual sheet.
What I would like to build is a macro button that can be selected to run when the Master Roster range is complete for each event that creates a new sheet that is a copy of the template sheet with the cell references on each sheet accurately pointing back to specific information for a row in the Master Roster sheet
What I would like to build is a macro button that can be selected to run when the Master Roster range is complete for each event that creates a new sheet that is a copy of the template sheet with the cell references on each sheet accurately pointing back to specific information for a row in the Master Roster sheet