Hello,
Who can help me out on this one?

I have a file with about 12,000 loans. However the amount differs from month
to month. Because I only need about 300 of them for my porpose, I delete al
the other rows. I also delete a number of columns and I insert two new
columns with additional data using VLOOKUP. The number of columns is each
month the same (=7). As all these steps are the same each month I recorded a
macro. At some point in this macro I want to go to the cel at the last row
with data left and the most right column with data. When I use <Ctrl+<End,
Excel brings me to row 12,000, but the bottomrow filled with data is about
300.
* is there on other command I can use?
* is there a line of VBA-code available which can bring me to the right cel?
* preferally I want all steps in the macro

I hope for your help!

Ciao,
Andries