Macro question Excel 2000

  • Thread starter Thread starter watergirl
  • Start date Start date
W

watergirl

Excel 2000 Sorry for inconvenience to reader this has been
posted in programming and new user but I have not gotten
any response to my problem so I am trying this group for
help.

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.
 
Your questions are very general, which is probably why you're not seeing any
replies (unless there's a technical problem where you can't see the
replies).

It sounds like you can use formulas for #1 (just make the references much
bigger than they need to be to begin with), and formulas or pivot tables for
#2.
 
water

Your posting in programming group was 2 minutes prior to this one.

Frank Kabel answered that one. Please check there.

Gord Dibben Excel MVP
 
Back
Top