jcoleman5534
New Member
- Joined
- Jul 12, 2013
- Messages
- 9
Hello-
Here's what I'm trying to do....
I have ~2250 names in SheetA, Column A (Cells A1:A2250). I need VBA to add 2250 worksheets for each of the names in the Column. When it adds the new worksheet I need cell B7 in each of the new worksheets filled by with the names from cell A1 then A2 then A3 and so on for every sheet that is added. Additionally, it would be great to have the sheet names also equal cell B7.
Here's what I'm trying to do....
I have ~2250 names in SheetA, Column A (Cells A1:A2250). I need VBA to add 2250 worksheets for each of the names in the Column. When it adds the new worksheet I need cell B7 in each of the new worksheets filled by with the names from cell A1 then A2 then A3 and so on for every sheet that is added. Additionally, it would be great to have the sheet names also equal cell B7.