davidhall80
Well-known Member
- Joined
- Jul 8, 2006
- Messages
- 663
I am trying to get the net change between the last two columns of data I have. The only problem is that each week my data extends a column because weekending data comes in. So I can't make any cell references in my macro when subtracting because I need to extend to the next column the next week. Is there something in VB that figure out the last two columns of data that I have in a sheet and then subtract the last from the previous in the next column over.
for ex. If my last two columns of data are range B5:C100, I need to get the difference between those two columns in range D5:D100. However, the following week, the last two columns of data will be in range C5:D100 then I will need the difference in range E5:E100. Make sense, I hope. thanks in advance.
for ex. If my last two columns of data are range B5:C100, I need to get the difference between those two columns in range D5:D100. However, the following week, the last two columns of data will be in range C5:D100 then I will need the difference in range E5:E100. Make sense, I hope. thanks in advance.