HELP PLEASE
Board Regular
- Joined
- Jan 8, 2005
- Messages
- 156
Hello all,
Cell A1 has the first three leters of the current month, then a dash and the last two letters of the current year; example (Feb-05). I need a macro that creates a new worksheet with the cell A1's contents as its name if a worksheet with that name does not already exist. Is that possible? Thanks for all your help always! Carl
Cell A1 has the first three leters of the current month, then a dash and the last two letters of the current year; example (Feb-05). I need a macro that creates a new worksheet with the cell A1's contents as its name if a worksheet with that name does not already exist. Is that possible? Thanks for all your help always! Carl