formula set up help

[suesolotel]

i want to produce a summary report from data in 15 individual reports each
month. The reports are saved under the same file name each month but in a
newly named folder - I have set up my report for this month - I want to be
able to have a system whereby all i do is enter a new folder name somewhere
in the master report and it automatically knows to look for the same data but
in a new month - help!

 

[Roger Govier]

Hi
Ron de Bruin has written lots of code to deal with different types of data
aggregation like this.
Take a look at
http://www.rondebruin.nl/copy3.htm

 

[suesolotel]

Thanks Roger
I'll try this out

Hi
Ron de Bruin has written lots of code to deal with different types of data
aggregation like this.
Take a look at
http://www.rondebruin.nl/copy3.htm