Firstly thanks to the peeps who have helped me previously, albeit I'm not that good at explaining exactly what it is I am trying to do\achieve. anyway another puzzle. I have a continious running spreadsheet of all stationary orders placed and I need to keep a check on the most common items to watch just how many we are going through, so this is what I have

In column 'C' I have the qty, 'F' has the unique code ref,

What I want in columns I through R is the total so as I2 through R2 has the running total

for instance I want any cell in column I (running down) to look at 'F' and if it contains the code (2.547.525) to then look at 'C' and return the total. if the code is not in 'F' leave blank, and again for 'J' to look at 'F' and if it contains (701.079) and so on I know this would result in and error where the code is not found but that can be hidden with a simply ISERROR conditional format. I then want L2 to R2 to look down the colums and have the running total.I then have another worksheet that adds the totals for each tab (depot)

Again I appologise if this is not explained very clear but it's easy to know what I want but not easy to put it into text.

Looking up each code can be done with an IF statement or VLOOKUP. "Errors" can probably be dealt with within the formula itself and not need any conditional formatting. All that said, it's not clear to me what you mean by "

I then want L2 to R2 to look down the colums and have the running total."Please click on the following line and read the instructions on how to post data in this forum. Then post a sample of your data which might help clear things up.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Req Date Qty Description Item No Unit Cost Total Example 1 Example 2 Example 3 Example 4 Example 5 x £282 30 12 0 0 6 213726 12/08/2011 6 Tin Example 1 701.079 £14.30 £85.80 6 213726 12/08/2011 6 No Example 2 2.547.525 £1.15 £6.90 6 x 213525 01/08/2011 6 Tin Example 2 2.547.525 £1.15 £27.60 6 213525 01/08/2011 24 No Example 1 701.079 £14.30 £85.80 24 x 213294 13/07/2011 6 Box Example 5 1.538.675 £12.70 £76.20 6

Hi anyone managed to resolve my problem please

Ask Your Question

Weekly Poll