Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rename tab to cell contents
Would like to have the tab name reflect the contents that appear in a
cell. It may contain numbers such as "40 2010" which is the result of a concatenated formula. . .(40 shipped in 2010, for example). Or, a cell contents which mayalso include text such as "100 2015 RED" (also the result of concatenating cells). Thanks for any code that could do this that may come your way. Pierre |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rename tab to cell contents
See
http://mcgimpsey.com/excel/events/sh...efromcell.html In article , Pierre wrote: Would like to have the tab name reflect the contents that appear in a cell. It may contain numbers such as "40 2010" which is the result of a concatenated formula. . .(40 shipped in 2010, for example). Or, a cell contents which mayalso include text such as "100 2015 RED" (also the result of concatenating cells). Thanks for any code that could do this that may come your way. Pierre |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rename tab to cell contents
Hi Pier
Say we use cell B9. Will you fill the cell manually or by formula?? -- Gary''s Student - gsnu2007L "Pierre" wrote: Would like to have the tab name reflect the contents that appear in a cell. It may contain numbers such as "40 2010" which is the result of a concatenated formula. . .(40 shipped in 2010, for example). Or, a cell contents which mayalso include text such as "100 2015 RED" (also the result of concatenating cells). Thanks for any code that could do this that may come your way. Pierre |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rename tab to cell contents
On Feb 10, 10:08*am, JE McGimpsey wrote:
See * *http://mcgimpsey.com/excel/events/sh...efromcell.html In article , *Pierre wrote: Would like to have the tab name reflect the contents that appear in a cell. It may contain numbers such as "40 2010" which is the result of a concatenated formula. . .(40 shipped in 2010, for example). Or, a cell contents which mayalso include text such as "100 2015 RED" (also the result of concatenating cells). Thanks for any code that could do this that may come your way. Pierre- Hide quoted text - - Show quoted text - This works great! Will fill by either text or formula, they both do the trick. Thanks you Gary's Student and JE McGimpsey. Pierre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rename worksheet based on contents of a cell in different workshee | Excel Discussion (Misc queries) | |||
Rename Multiple Excel Workbooks based on cell contents | Excel Discussion (Misc queries) | |||
new worksheet and rename from cell contents macro | Excel Worksheet Functions | |||
How to set SAVE AS file name to equal A1 contents when rename file | Excel Discussion (Misc queries) | |||
How do I automatically rename a sheet with the contents of a cell. | Excel Discussion (Misc queries) |