pulling worksheet name from page data

  • Thread starter Thread starter Kimberly
  • Start date Start date
K

Kimberly

In order to save time with dozens of identical worksheets bearing
similar name, I am trying to find a function that would remain in
cell that based upon one set of input criteria would insert
descriptor name into the worksheet name.
For instance, I have 4 pages tracking production costs on 4 widgets.
Costs are all the same, but at different levels. Using the indirec
search function and vlookup, I can quickly update each widgets shee
from a master list of costs. However, I am tired of having to renam
each sheet and the production name on it for each line with each ne
product group.
I would like to maintain one list (with columns widget id #, widge
name, widget line, widget cost, etc). I would like to be able to jus
copy my production cost tracking page, input the widget id #, and th
rest would feet automatically. All of that is not a problem with th
exception of the WORKSHEET NAME. Can anyone please help me pull th
widget name into the worksheet name. Like:
Widget name: Mongo
Worksheet name: Mongo production worksheet
Thanks!!! Kimberl
 
Hi
this can only be done with VBA.
e.g.
sub foo()
activesheet.name = activesheet.range("A1").value _
& " production worksheet"
end sub

if A1 sotres your worksheet name
 
Back
Top