Macro for selecting data to sum using a fliter over 50 sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyon

I am very new to using Excel and am looking for a Macro which will allow me to filter weekly data, select that data, then sum the aforesaid data, display it in a another sheet, then print it off using the week number in a header, if possible by just entering a week number ( ie 23 = Week 23) in a cell which the macro then operates upon. I can perform the task now by select all the weeks I do not want then slecting all the sheets and then deleating all that data, it seems very long winded, I have tried to record this sort of macro but can't save the macro as saving changes means losing all the data
Hopefully some one can help or at least suggest where to star

Thanx in advance
 
Paul

contextures.com has excellent tips including macros for
Filters and advanced filters.

Regards
Peter
-----Original Message-----
Hi everyone

I am very new to using Excel and am looking for a Macro
Click to expand...
which will allow me to filter weekly data, select that
data, then sum the aforesaid data, display it in a another
sheet, then print it off using the week number in a
header, if possible by just entering a week number ( ie 23
= Week 23) in a cell which the macro then operates upon. I
can perform the task now by select all the weeks I do not
want then slecting all the sheets and then deleating all
that data, it seems very long winded, I have tried to
record this sort of macro but can't save the macro as
saving changes means losing all the data.
 
If you want to record a macro without messing up the data, make a copy of
the file first and then record the macro in the copy.
If you wish, send me, via email, a small file with a sample of your data
and an example of what you want to happen, and I'll try to work up something
for you. Remove "cobia97" from my email address.
Working with week numbers is dicey at best. The definition of what
constitutes a week varies by people. Clearly state what definition of "a
week" you use. Is it Monday through Sunday? Etc? Also clearly state what
you consider week 1 to be in any given year. HTH Otto
UKPaulB said:
Hi everyone

I am very new to using Excel and am looking for a Macro which will allow
Click to expand...
me to filter weekly data, select that data, then sum the aforesaid data,
display it in a another sheet, then print it off using the week number in a
header, if possible by just entering a week number ( ie 23 = Week 23) in a
cell which the macro then operates upon. I can perform the task now by
select all the weeks I do not want then slecting all the sheets and then
deleating all that data, it seems very long winded, I have tried to record
this sort of macro but can't save the macro as saving changes means losing
all the data.
 
Back
Top