Hi all,

I have a fantastic e-Ordering file i've been working on for a week
it's brilliant. i love excel after doing it.

Basically, i've attached it to save me from explaining it.

20 rows of ordering space, because it fits on an A4 page perfectly (i
may be faxed, or emailed)

Lots of pretty macros (thanks to you lot!) and lots of potential (
think)

BUT, some one made a comment that's got me proper confused.

"What if i want to order more than 20 items in one order?"

Ahhhhh!
I don't want to add rows, because then it won't fit on an A4 page, bu
i can't think of any other way of giving them the opportunity to ad
more things, without completly anihilating my existing macros that too
me and you so long!

Do you have any ideas to get around this?

Thank you SO much

+-------------------------------------------------------------------
|Filename: FM Purchase Order.zip
|Download: http://www.excelforum.com/attachment.php?postid=4478
+-------------------------------------------------------------------

--
druce
-----------------------------------------------------------------------
drucey's Profile: http://www.excelforum.com/member.php...fo&userid=3255
View this thread: http://www.excelforum.com/showthread.php?threadid=52394

Since you like msgboxes, put several in to tell the user to make a second
order.

--
Regards,
Tom Ogilvy

"drucey" wrote in
message ...

Hi all,

I have a fantastic e-Ordering file i've been working on for a week,
it's brilliant. i love excel after doing it.

Basically, i've attached it to save me from explaining it.

20 rows of ordering space, because it fits on an A4 page perfectly (it
may be faxed, or emailed)

Lots of pretty macros (thanks to you lot!) and lots of potential (i
think)

BUT, some one made a comment that's got me proper confused.

"What if i want to order more than 20 items in one order?"

Ahhhhh!
I don't want to add rows, because then it won't fit on an A4 page, but
i can't think of any other way of giving them the opportunity to add
more things, without completly anihilating my existing macros that took
me and you so long!

Do you have any ideas to get around this?

Thank you SO much!


+-------------------------------------------------------------------+
|Filename: FM Purchase Order.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4478 |
+-------------------------------------------------------------------+

--
drucey
------------------------------------------------------------------------
drucey's Profile:
http://www.excelforum.com/member.php...o&userid=32553
View this thread: http://www.excelforum.com/showthread...hreadid=523948

haha! Exactly what i wanted to do, but it causes too much payment/admi
work to do 2 orders

And of course i do, i only discovered how to do them an hour ago

--
druce
-----------------------------------------------------------------------
drucey's Profile: http://www.excelforum.com/member.php...fo&userid=3255
View this thread: http://www.excelforum.com/showthread.php?threadid=52394