Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Naming sheets from a cell value
Hi there,
Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#2
|
|||
|
|||
See
http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#3
|
|||
|
|||
Thanks for the quick response. Stupid question! When does the code get
executed? I tried pressing F9, or do I have to change something? Thanks again "JE McGimpsey" wrote: See http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#4
|
|||
|
|||
If you put it in the worksheet code module, per the instructions, the
macro will fire whenever a cell in the sheet is changed manually. In article , "Tony4X4" wrote: Thanks for the quick response. Stupid question! When does the code get executed? I tried pressing F9, or do I have to change something? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming sheets from a cell value
Hi ..I am really green at this.. could you please help me by starting with
where to creat this macro .. I have tried.. cannot seem to make it happen "JE McGimpsey" wrote: See http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming sheets from a cell value
can we take this abit farther? I'd like then tab names to come up in reverse
order..is there away of doing this? e.g going from left to right December to the left and January to the far right? also if there is a date formula in A1 how do I change the macro as it wants only to read text.. "kathy" wrote: Hi ..I am really green at this.. could you please help me by starting with where to creat this macro .. I have tried.. cannot seem to make it happen "JE McGimpsey" wrote: See http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming sheets from a cell value
this is what I was working from just want the dates to appear on the tabs in
reverse order from what this does.. "Don Guillett" wrote: I don't see the first part of the thread but try sub namesheets() for i=1 to 12 sheets(i).name=sheets(i).range("a1") next end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "kathy" wrote in message ... can we take this abit farther? I'd like then tab names to come up in reverse order..is there away of doing this? e.g going from left to right December to the left and January to the far right? also if there is a date formula in A1 how do I change the macro as it wants only to read text.. "kathy" wrote: Hi ..I am really green at this.. could you please help me by starting with where to creat this macro .. I have tried.. cannot seem to make it happen "JE McGimpsey" wrote: See http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming sheets from a cell value
for 12 to 1 step -1
-- Don Guillett Microsoft MVP Excel SalesAid Software "kathy" wrote in message ... this is what I was working from just want the dates to appear on the tabs in reverse order from what this does.. "Don Guillett" wrote: I don't see the first part of the thread but try sub namesheets() for i=1 to 12 sheets(i).name=sheets(i).range("a1") next end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "kathy" wrote in message ... can we take this abit farther? I'd like then tab names to come up in reverse order..is there away of doing this? e.g going from left to right December to the left and January to the far right? also if there is a date formula in A1 how do I change the macro as it wants only to read text.. "kathy" wrote: Hi ..I am really green at this.. could you please help me by starting with where to creat this macro .. I have tried.. cannot seem to make it happen "JE McGimpsey" wrote: See http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming sheets from a cell value
yup yup that works.. thanks
"Don Guillett" wrote: for 12 to 1 step -1 -- Don Guillett Microsoft MVP Excel SalesAid Software "kathy" wrote in message ... this is what I was working from just want the dates to appear on the tabs in reverse order from what this does.. "Don Guillett" wrote: I don't see the first part of the thread but try sub namesheets() for i=1 to 12 sheets(i).name=sheets(i).range("a1") next end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "kathy" wrote in message ... can we take this abit farther? I'd like then tab names to come up in reverse order..is there away of doing this? e.g going from left to right December to the left and January to the far right? also if there is a date formula in A1 how do I change the macro as it wants only to read text.. "kathy" wrote: Hi ..I am really green at this.. could you please help me by starting with where to creat this macro .. I have tried.. cannot seem to make it happen "JE McGimpsey" wrote: See http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming sheets from a cell value
here is one more that worked but now is giving me a"compile error code
-variable not defined" on the "intTemp = 2"part here is the whole thing.. Sub createmonthsheets() 'Dim intTemp Dim dtTemp As Date dtTemp = "Jan 10" ActiveWorkbook.Sheets.Add Count:=(12 - 1 - ActiveWorkbook.Sheets.Count) For intTemp = 2 To ActiveWorkbook.Sheets.Count ActiveWorkbook.Sheets(intTemp).Name = _ Format(DateAdd("y", (intTemp - 2), dtTemp), "mmm-yy") Next ActiveWorkbook.Save End Sub "kathy" wrote: yup yup that works.. thanks "Don Guillett" wrote: for 12 to 1 step -1 -- Don Guillett Microsoft MVP Excel SalesAid Software "kathy" wrote in message ... this is what I was working from just want the dates to appear on the tabs in reverse order from what this does.. "Don Guillett" wrote: I don't see the first part of the thread but try sub namesheets() for i=1 to 12 sheets(i).name=sheets(i).range("a1") next end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "kathy" wrote in message ... can we take this abit farther? I'd like then tab names to come up in reverse order..is there away of doing this? e.g going from left to right December to the left and January to the far right? also if there is a date formula in A1 how do I change the macro as it wants only to read text.. "kathy" wrote: Hi ..I am really green at this.. could you please help me by starting with where to creat this macro .. I have tried.. cannot seem to make it happen "JE McGimpsey" wrote: See http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming sheets from a cell value
Have you tried un-commenting Dim intTemp
Gord Dibben MS Excel MVP On Thu, 3 Sep 2009 12:29:02 -0700, kathy wrote: here is one more that worked but now is giving me a"compile error code -variable not defined" on the "intTemp = 2"part here is the whole thing.. Sub createmonthsheets() 'Dim intTemp Dim dtTemp As Date dtTemp = "Jan 10" ActiveWorkbook.Sheets.Add Count:=(12 - 1 - ActiveWorkbook.Sheets.Count) For intTemp = 2 To ActiveWorkbook.Sheets.Count ActiveWorkbook.Sheets(intTemp).Name = _ Format(DateAdd("y", (intTemp - 2), dtTemp), "mmm-yy") Next ActiveWorkbook.Save End Sub "kathy" wrote: yup yup that works.. thanks "Don Guillett" wrote: for 12 to 1 step -1 -- Don Guillett Microsoft MVP Excel SalesAid Software "kathy" wrote in message ... this is what I was working from just want the dates to appear on the tabs in reverse order from what this does.. "Don Guillett" wrote: I don't see the first part of the thread but try sub namesheets() for i=1 to 12 sheets(i).name=sheets(i).range("a1") next end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "kathy" wrote in message ... can we take this abit farther? I'd like then tab names to come up in reverse order..is there away of doing this? e.g going from left to right December to the left and January to the far right? also if there is a date formula in A1 how do I change the macro as it wants only to read text.. "kathy" wrote: Hi ..I am really green at this.. could you please help me by starting with where to creat this macro .. I have tried.. cannot seem to make it happen "JE McGimpsey" wrote: See http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming sheets from a cell value
yes that got the thing to run but I still have the months listed as Jan to
December left to right and I need them the other direction Dec to Jan left to right.. I appreciate your input.. "Gord Dibben" wrote: Have you tried un-commenting Dim intTemp Gord Dibben MS Excel MVP On Thu, 3 Sep 2009 12:29:02 -0700, kathy wrote: here is one more that worked but now is giving me a"compile error code -variable not defined" on the "intTemp = 2"part here is the whole thing.. Sub createmonthsheets() 'Dim intTemp Dim dtTemp As Date dtTemp = "Jan 10" ActiveWorkbook.Sheets.Add Count:=(12 - 1 - ActiveWorkbook.Sheets.Count) For intTemp = 2 To ActiveWorkbook.Sheets.Count ActiveWorkbook.Sheets(intTemp).Name = _ Format(DateAdd("y", (intTemp - 2), dtTemp), "mmm-yy") Next ActiveWorkbook.Save End Sub "kathy" wrote: yup yup that works.. thanks "Don Guillett" wrote: for 12 to 1 step -1 -- Don Guillett Microsoft MVP Excel SalesAid Software "kathy" wrote in message ... this is what I was working from just want the dates to appear on the tabs in reverse order from what this does.. "Don Guillett" wrote: I don't see the first part of the thread but try sub namesheets() for i=1 to 12 sheets(i).name=sheets(i).range("a1") next end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "kathy" wrote in message ... can we take this abit farther? I'd like then tab names to come up in reverse order..is there away of doing this? e.g going from left to right December to the left and January to the far right? also if there is a date formula in A1 how do I change the macro as it wants only to read text.. "kathy" wrote: Hi ..I am really green at this.. could you please help me by starting with where to creat this macro .. I have tried.. cannot seem to make it happen "JE McGimpsey" wrote: See http://www.mcgimpsey.com/excel/event...efromcell.html In article , "Tony4X4" wrote: Hi there, Thanks for reading my question. Is it possible to name a sheet from a cell value with in the sheet? i.e. I have 12 sheets, each sheet represents a month and the month value is in cell A1. Can I rename a sheet by refering to cell A1 instead of manually renaming the sheets to January, February etc. Many thanks Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell Reference, Multiple Sheets | Excel Worksheet Functions | |||
Copy cell values across separate sheets | Excel Discussion (Misc queries) | |||
Copying the same cell from different sheets | Excel Discussion (Misc queries) | |||
One cell from several sheets to one column | Excel Discussion (Misc queries) |