I have a workbook with 11 Tabs, RAW, 01, 02, 03, 04 ... 50
Each tab, 01-10, I want to name Cells A1:D4 "Group 1," cells A11:D12 "Group 2," cells A33:F45 "Stats."
1. Do the ranges have to be sheet specific, of can they be relative to the current sheet? Meaning can Group 1 be A1:D4 of the current tab, or does it have to be '01'!A1:D4, '02'!:A1:D4, '03'!A1:D4, etc.
2. If they are sheet specific only, is there a way to simply copy the selected range and apply it to another sheet? I'd like a way to auto select A1:D4 on sheet 2 and then sheet 3, and then sheet 4, rather than having to select it with my mouse 49 times.
Each tab, 01-10, I want to name Cells A1:D4 "Group 1," cells A11:D12 "Group 2," cells A33:F45 "Stats."
1. Do the ranges have to be sheet specific, of can they be relative to the current sheet? Meaning can Group 1 be A1:D4 of the current tab, or does it have to be '01'!A1:D4, '02'!:A1:D4, '03'!A1:D4, etc.
2. If they are sheet specific only, is there a way to simply copy the selected range and apply it to another sheet? I'd like a way to auto select A1:D4 on sheet 2 and then sheet 3, and then sheet 4, rather than having to select it with my mouse 49 times.