Worsheet Tab Names - Question

[Greegan]

You folks have given me a way to copy an existing sheet and add it to my
current workbook, naming it "temp".

I have a couple of questions of how to manipulate each sheet that's copied
to the workbook in question...

Cell BY4 will have my customer's name in that cell AFTER the Temp sheet is
copied and before the next sheet is added...

Can you provide me with a macro that would make the sheet's name change with
the contents of Cell BY4?


ALSO


I have another sheet where I want to list my customer names in the order of
the sheets (added and named as described above).
Is there a formula I could use that would link cell A1 of Page01 with the
name given in BY4 of sheet TEMP, soon to be named something else based this
cell?

Thanks in advance,
G

 

[Vasant Nanavati]

Something like:

With Worksheets("Temp")
.Name = .Range("BY4")
End With

 

[Bob Phillips]

Also, if you use a formula of

=TEMP!BY4

on Page01, when BY4 gets changed, and the worksheet thereby gets changed,
your formula will update to reflect it.

--

HTH

RP
(remove nothere from the email address if mailing direct)