I am working on a code that will identify a named range in cell B5 (this is done by use of data validation for user friendliness) What I need to do is program a button adjacent to these cells that when clicked will copy the range of (A7:F7) into the sheets in the named range. The named ranges are stored in a separate sheet named "Groups". So if "Group 1" was selected in the drop down it would refer to the items listed in the column that is labeled "Group 1" in the sheet "groups" and copy the values of range A7:F7 from the sheet titled "main page" to the sheets that are identified in that group of cells in this case the next available row of sheets "1", "2" and "3" as identified by "Group 1" in the sheet labeled "Groups". Hopefully that doesn't sound too confusing .
I have attached a workbook with an example of what I need it to do with comments that identify what the cells would reference etc. The sheets also have a highlighted row that shows how it would look if the code was run and pasted into the appropriate range. The example has limited pages but the actual workbook would consistent of hundreds of groups/sheets and would be applied to hundreds of sheets.
The user needs to be able to add sheets to groups at will by modifying or adding to the groups sheet. For instance adding a 10 to the next available row in Column A referring to Group 1 in sheet named "Groups" would mean the next time the button was pushed it would add the values of range A7:F7 to sheet "10" as well.
Thank you for your help and time
Bookmarks