Can I do a global find and replace on the tabs in Excel 2007

S

Sandi

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
 
R

Roger Govier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Global Template Network and saving auto texts & macros 2
Find and Replace 1
Can I disable the Save As Function? 1
How to get range names to Apply across multiple tabs 1
How can I copy data produced by a formula, not the formula? 2
how can I use Word find and Replace to search inside a stringvariable (in a macro) 1
Can Excel 2007 copy and add worksheets based on population a cell 0

Top