Hi all,

Not sure if this is in the right place, if not could a moderator move
it for me please.

Basically i am looking for some help. I have a spreadsheet for a
statement that i need to run once every quarter. At the moment it is
set up using a sheet of data and a sheet that is set out how we need
the statement to look. The statement is currently getting information
to it through vlookups based on me manually typing in a report number.
This is starting to become unpractical as there are now over 300
statements that i need to print off every quarter.

I have been thinking about maybe using a macro to make this quicker but
the problem i have is that there are over 2000 lines and around 300
statements to print, but the numbers are not the same every month.

Does anybody know of a quicker (it's currently taking me a day and a
bit to print them all off) way of doing things?

I'm not sure if i make much sense. If i don't please ask and i will
try to explain better.

Thanks.

Angel


--
Angel22
------------------------------------------------------------------------
Angel22's Profile: http://www.excelforum.com/member.php...o&userid=30788
View this thread: http://www.excelforum.com/showthread...hreadid=504455