Automatically select last row in a set in Excel

Posted by Luke on Super User See other posts from Super User or by Luke
Published on 2012-12-01T04:25:37Z Indexed on 2012/12/01 5:07 UTC
Read the original article Hit count: 436

Filed under:

In Excel 2003, I am trying to keep track of some petty cash, and have it set up with the denomination along the top row, along with a sub total and difference column. I want a small section that shows how many rolls of coins I should have, by taking the total amount, and dividing it by however many should be in a roll, and rounding to the lowest whole number. That part is fine.

What I want done is for that ONE section (how many rolls) I should have, based on the last row that has information in it. For example, if the last row is row 13, it should read the data from B13, C13, D13, etc.

I don't mind learning Macros, if that's what the solution requires. I don't want to be manually selecting the last row each time though, I just want the worksheet to know automatically.

© Super User or respective owner

Related posts about excel-2003