Each month I need to collate information from a number of invoices. Each invoice has a different number of lines on it.
What I need/want to be able to do is automate this process as much as possible.
I have a complete list of products from which I have created a lookup (with some help!) and this part works fine in that I type in a product code and the description and pack size come up automatically.
What I need to do now is check the amount of each invoice is correct as I am going along.
Someone I spoke to said that if I numbered each entry, so all lines on invoice one would have a number 1 in column A, all lines on invoice two would have a number 2 and so on, then I could add up the total of each invoice somehow and that is where I am stuck. I don't know how to this!
If anyone understands what I am on about, could you please help!