If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I do a global find and replace on the tabs in Excel 2007
I'm trying to create a template in which each tab has a month designation,
and on the worksheet the colums would have the daily date. Is there any quick way of doing this? I have already created a couple of months, and have tried to do a global replace the the dates, but get a dialog box stating no matching info. Help |
#2
|
|||
|
|||
Can I do a global find and replace on the tabs in Excel 2007
Hi
Whilst I feel that it is always better to keep all data on the same sheet, with month as a column, then use filters to select any individual month, I recognise that there are people who want to work as you outline. To this end I created a macro which will generate such a workbook for you. it can be downloaded here http://www.contextures.com/CreateMthlyWkbks.zip -- Regards Roger Govier Sandi wrote: I'm trying to create a template in which each tab has a month designation, and on the worksheet the colums would have the daily date. Is there any quick way of doing this? I have already created a couple of months, and have tried to do a global replace the the dates, but get a dialog box stating no matching info. Help |
Thread Tools | |
Display Modes | |
|
|