HELP with macro problem Excel 2000

[watergirl]

Excel 2000
Any information regarding the following would be greatly
appreciated:

How to formulate a macro for ever expanding worksheets.

#1. A summary worksheet which is constantly being updated
and would like to input this same data on individual
worksheets.

#2. Would like to summarize monthly data only, not entire
worksheet. i.e. although the data would include Jan
results, I would like to summarize Feb only and hide Jan.

 

[Frank Kabel]

Hi
the problem with your question is: It's to general. To get some answers
you may try the following:
- post some example rows of your monthly sheets (plain text - no
attachments please)
- describe how you want them on your summary sheet
- Show us your expected result based on your example data

As a tip: try asking one question at a time for a specific problem.
This NG normally does not provide complete, ready-to-use, full tested
spreadsheets but provide you with help for specific issues