G
Gaz
Hi, I'm required to produce a monthly report and doing it manually would be a
nightmare and time consuming. I've been studying how to link data from the
excel file and this looks ideal but:
The spreadsheet rows will increase on a monthly basis
and
I wish to breakdown sections of the report as we would in excel using
autofilters i.e. select rows of data on a single field for import to word.
Also, how do I compare the data sources from month to month to identify
changes?
Any help much appreciated. I'm using excel 2003.
nightmare and time consuming. I've been studying how to link data from the
excel file and this looks ideal but:
The spreadsheet rows will increase on a monthly basis
and
I wish to breakdown sections of the report as we would in excel using
autofilters i.e. select rows of data on a single field for import to word.
Also, how do I compare the data sources from month to month to identify
changes?
Any help much appreciated. I'm using excel 2003.