great stuff peco.

again, this opens a new question. Lets say I want to copy the last 7 transactions, and paste them on another sheet so that I can chart them?

I'm assuming I could use a formula that looks to the last cell in that row, then the last cell in that row minus one cell position (to the left), then minus two cell positions, etc.?

I've got the "find the data from the last cell containing a number" thing by using the following lookup: (the desired result for this box is 6, and it returns 6)

=Lookup(9.99999999E307,'Sales'!198:198)

How can I get the cell directly to the left of it? I've tried =Lookup(9.99999999E307,'Sales'!198:198) -1 but that returns the value of 6-1. It should be 9.

Edit mod : post related to https://www.msofficeforums.com/excel...a-columns.html