VBA Help

[keyboard1960]

Trying to write code that would check a single column for data starting at the top and then subtract that cell's values with the next cell with data that it finds further down the column. Let me know if this doesn't make any sense. Thanks, Byron

 

[Jim North]

Please give an example of what you are looking to do.

 

[keyboard1960]

In column "K" if conditions are matched we would have data in a cell such as Column K Row 30 the data would be 650. Then another cell further down the column might also have data such as Column K Row 40 data value 900. In column "L" I would like to search automatically for all data in column K and subtract as in this example K30-K40. Hope this clarifys. Thanks in advance.

 

[Rylandir]

If ...

A1=10
A2=(blank)
A3=30
A4=100
A5=(blank)
and so on ...

Given that example, are you wanting a formula in B1 that = A1-A2-A3-A4-A5 (the blanks would evaluate to subtracting a zero)?

 

[keyboard1960]

I'm sorry in my 2nd post I should have listed as the example K40-K30. Then the next cell to be computed would be let's say K50-K40. You can see why I'm going nuts. I guess this would require some coding that would read ahead for the next entry in a column and subtract that entry from the previous one. Thanks for your help.