Is this possible

[Naan]

In my last post I had talked about setting up a school shop, well I now need to do receipts and I have some small problems.

Well I need to take the information that is required (e.g. what is being bought) to be taken to another sheet where it says the cost, price and quantity and the grand total. This is simple if I am using a Macro to copy and paste one line, but what if the child buys than more product?

I have and an idea, I thought if the Quantity Section had a IF statement (e.g. IF there is more than 1 in this section than move it to the receipt.)

But I do not know how to get round this. I need all the help I can get, If you want to provide any more idea's I would be greatful

[Ardus Petus]

Please post some sample data.

Cheers,
--
AP

"Naan" <[email protected]> a écrit dans le
message de news:[email protected]...
>
> In my last post I had talked about setting up a school shop, well I now
> need to do receipts and I have some small problems.
>
> Well I need to take the information that is required (e.g. what is
> being bought) to be taken to another sheet where it says the cost,
> price and quantity and the grand total. This is simple if I am using a
> Macro to copy and paste one line, but what if the child buys than more
> product?
>
> I have and an idea, I thought if the Quantity Section had a IF
> statement (e.g. IF there is more than 1 in this section than move it to
> the receipt.)
>
> But I do not know how to get round this. I need all the help I can get,
> If you want to provide any more idea's I would be greatful
>
>
> --
> Naan
> ------------------------------------------------------------------------
> Naan's Profile:
http://www.excelforum.com/member.php...o&userid=32380
> View this thread: http://www.excelforum.com/showthread...hreadid=521896
>