software

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: www.excelforum.com/member.php...oamp;userid=30788
View this thread: www.excelforum.com/showthread...hreadid=504455Move the application over to MS-Access and use the Report Writer to help you
with the layout and printing. The data tables should move over to the
MS-Access database without too much trouble and you will have more
functionality and less manual work in producing the statements.

P.

quot;Angel22quot; wrote:

gt;
gt; Hi all,
gt;
gt; Not sure if this is in the right place, if not could a moderator move
gt; it for me please.
gt;
gt; Basically i am looking for some help. I have a spreadsheet for a
gt; statement that i need to run once every quarter. At the moment it is
gt; set up using a sheet of data and a sheet that is set out how we need
gt; the statement to look. The statement is currently getting information
gt; to it through vlookups based on me manually typing in a report number.
gt; This is starting to become unpractical as there are now over 300
gt; statements that i need to print off every quarter.
gt;
gt; I have been thinking about maybe using a macro to make this quicker but
gt; the problem i have is that there are over 2000 lines and around 300
gt; statements to print, but the numbers are not the same every month.
gt;
gt; Does anybody know of a quicker (it's currently taking me a day and a
gt; bit to print them all off) way of doing things?
gt;
gt; I'm not sure if i make much sense. If i don't please ask and i will
gt; try to explain better.
gt;
gt; Thanks.
gt;
gt; Angel
gt;
gt;
gt; --
gt; Angel22
gt; ------------------------------------------------------------------------
gt; Angel22's Profile: www.excelforum.com/member.php...oamp;userid=30788
gt; View this thread: www.excelforum.com/showthread...hreadid=504455
gt;
gt;


Thanks for that. I never thought about doing it that way. I have
another quick question though. How do i get the information from Excel
to Access? I've never done it before. Is it simply a case of copy and
paste?--
Angel22
------------------------------------------------------------------------
Angel22's Profile: www.excelforum.com/member.php...oamp;userid=30788
View this thread: www.excelforum.com/showthread...hreadid=504455
Not to worry i've just managed to do it.--
Angel22
------------------------------------------------------------------------
Angel22's Profile: www.excelforum.com/member.php...oamp;userid=30788
View this thread: www.excelforum.com/showthread...hreadid=504455Let me (and others) know how this ends up....

P.

quot;Angel22quot; wrote:

gt;
gt; Not to worry i've just managed to do it.
gt;
gt;
gt; --
gt; Angel22
gt; ------------------------------------------------------------------------
gt; Angel22's Profile: www.excelforum.com/member.php...oamp;userid=30788
gt; View this thread: www.excelforum.com/showthread...hreadid=504455
gt;
gt;