I have several worksheets each containing similar information about
different clients and once a fortnight I am expected to send a report on all
activity. To do this I need to collate the information on a daily basis from
each worksheet then present it in the report as a total of all the
worksheets. At present I am doing this by placing formulae on the worksheets
to search out information according to date then add the columns of
information either as a sum or countif equations then gathering and summing
on the report page before actually placing the result in the appropriate
place on the report.
I know there must be a way of doing the same using visual basic but I am
nowhere near clever enough. Does anyone have any ideas? At present I am using
in excess of 52mb and am afraid that soon it will be too big to open!

You've not given enough information so that anyone can help with specifics.
In the meantime, try recording a macro with what you want to do. They often
aren't as efficient, but it's a start. If you want, come back and post it
here and someone should be able to help.

"John D" wrote:

I have several worksheets each containing similar information about
different clients and once a fortnight I am expected to send a report on all
activity. To do this I need to collate the information on a daily basis from
each worksheet then present it in the report as a total of all the
worksheets. At present I am doing this by placing formulae on the worksheets
to search out information according to date then add the columns of
information either as a sum or countif equations then gathering and summing
on the report page before actually placing the result in the appropriate
place on the report.
I know there must be a way of doing the same using visual basic but I am
nowhere near clever enough. Does anyone have any ideas? At present I am using
in excess of 52mb and am afraid that soon it will be too big to open!