sheet name

[tpkelley_no]

I have multiple excel sheet I need to name. the sheets will have a name already for example: order, cost labor. the name i would like to add will be on a sheet called proposal and the cell will be located in cell "B3" so the sheets need to have cost - "cell information from B3"

 

[Rick Rothstein]

Is this what you want...

[table="width: 500"]
[tr]
	[td]Sub ChangeSheetNamesAccordingToCellB3()
  Dim WS As Worksheet
  For Each WS In Worksheets
    If Len(WS.Range("B3")) Then WS.Name = WS.Name & " - " & WS.Range("B3")
  Next
End Sub[/td]
[/tr]
[/table]

 

[tpkelley_no]

do they have a formula I can use?

 

[Rick Rothstein]

do they have a formula I can use?

You cannot rename a sheet using a formula... formulas only return values to the cell they are in.

 

[tpkelley_no]

I only need this to work on the following work sheet tab named : orders, and the copy location for that sheet will be cell "C2", Cost cell location "B2" Labor: cell location "C2" Sorry about that

 

[Rick Rothstein]

I only need this to work on the following work sheet tab named : orders, and the copy location for that sheet will be cell "C2", Cost cell location "B2" Labor: cell location "C2" Sorry about that

I am sorry, but I am not at all clear on what you want to do. Can you provide a more detailed description of your current layout and what you want it to look like afterwards?

 

[tpkelley_no]

Sorry about that.Sorry about that. the source sheet is called Cost Sheet and the location of the cell is "C2". the contents of that cell needs to be added to the following sheets: Orders, Costs, Labor. Example: if Cost Sheet has "BBK" in Cell "C2" the following sheet need to have Order - BBK, Cost - BBK, Labor - BBK.
the source sheet is called Cost Sheet and the location of the cell is "C2". the contents of that cell needs to be added to the following sheets: Orders, Costs, Labor. Example: if Cost Sheet has "BBK" in Cell "C2" the following sheet need to have Order - BBK, Cost - BBK, Labor - BBK.

 

[Rick Rothstein]

Example: if Cost Sheet has "BBK" in Cell "C2" the following sheet need to have Order - BBK, Cost - BBK, Labor - BBK.

What exactly do you mean by "the following sheets need to have"... need to have what?

Are you changing the sheet names to what you show?

Or are those value being placed on those sheets somewhere? If yes, where (what cells)?

 

[tpkelley_no]

the work book does have multiple sheets and i only need the following sheets names to be change. Cell C2 on "Cost" tab has BWW. I need the following sheets to have BBW added. the sheets are named Orders, Cost, and Labor. after the code is ran it should have Orders-BWW, Cost- BWW, Labor - BWW. i can not get a screen shot to past.

 

[Rick Rothstein]

the work book does have multiple sheets and i only need the following sheets names to be change. Cell C2 on "Cost" tab has BWW. I need the following sheets to have BBW added. the sheets are named Orders, Cost, and Labor. after the code is ran it should have Orders-BWW, Cost- BWW, Labor - BWW. i can not get a screen shot to past.

Okay, so we are changing the sheet names themselves... that means we must use VB code to do it. Here is a macro that will do what I think you have described above...

Sub ChangeSheetNamesAccordingToCellB3()
  Dim V As Variant
  For Each V In Array("Orders", "Labor", "Cost")
    Sheets(V).Name = Sheets(V).Name & "-" & Sheets("Cost").Range("C2").Value
  Next
End Sub