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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation in another sheet 1
Use formula to populate cells 1
Compare values and place corresponding value in another sheet 3
Help to create a macro 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Copy Sheet #'s, but leave cell reference 3
Incrementing no.s creating new but not changing no. opening saved 2
Highlighting Like Names in a Column 3

Back
Top