Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing name of worksheet based on data in cell of another worksheet
I have an excel workbook, with a "master" worksheet for data input and
have 18 other worksheets titled Stud1 through Stud18. I am trying to have the names of the "Stud" worksheets automatically change to the student's lastnames on the "master" worksheet (there is a column on the master worksheet named "lastname" from B13 to B30. The lastname entered in B13 should be the name of the "Stud1" worksheet and B14 the name of "Stud14" worksheet, and so on.) I have little to no VBA experience and would love some help with this. Anyone out there have any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Cell Color based upon value on another worksheet | Excel Programming | |||
Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
Select correct worksheet based on data entered into a cell | Excel Worksheet Functions | |||
Select correct worksheet based on data entered into a cell | Excel Programming | |||
Changing cell values based on a worksheet name | Excel Programming |