Need a solution!

[drucey]

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!

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

"drucey" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[drucey]

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

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