Creating a tab name by entering a cell value in a different worksh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to enter a value in a cell on Worksheet 1 (first tab). I then want
that cell value to be used to name a new tab automatically. (ie Enter "PO:
123" in sheet1!A2, then enter "3" in sheet1!B2. I want sheet3 to then be
named "PO: 123")
If I can't have this, THEN:

If I name sheet3 "PO:123", can i populate sheet1!A2 with the sheet name
"PO:123" by indicating the sheet number in cell B2?

I'm trying to avoid double entering identical data by pulling values from
one cell or sheet name.

This seems like it should be within reach, but i can't see through the fog.

thanks,
tcs
 
Hi
this would require VBA. Not possible with formulas alone. Is this a
possible way for you?
 
Back
Top