N
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
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