R rnkshan Feb 9, 2009 #1 HOW DO I NAME VARIOUS SHEETS IN MY WORK BOOK WITH DATES OF A MONTH e.g. FEB 9, FEB 10 ETC IN ONE SHORT
HOW DO I NAME VARIOUS SHEETS IN MY WORK BOOK WITH DATES OF A MONTH e.g. FEB 9, FEB 10 ETC IN ONE SHORT
M muddan madhu Feb 9, 2009 #2 try this in Sheet1 , Range A1: A10 type FEB 9, FEB 10 and so on run this macro Sub sheet_name() For a = 1 To Sheets.Count Sheets(a).Name = Cells(a, 1).Value Next End Sub
try this in Sheet1 , Range A1: A10 type FEB 9, FEB 10 and so on run this macro Sub sheet_name() For a = 1 To Sheets.Count Sheets(a).Name = Cells(a, 1).Value Next End Sub
R Roger Govier Feb 9, 2009 #4 Hi I have written a macro that will produce 12 workbooks with sheets named for each day within each month. It can be downloaded from here http://www.contextures.com/CreateMthlyWkbks.zip
Hi I have written a macro that will produce 12 workbooks with sheets named for each day within each month. It can be downloaded from here http://www.contextures.com/CreateMthlyWkbks.zip
