using your example, I want to fill J5 with data from F5.

row #6, there is data in A5, C5 AND H5. I want to fill J5 with data from H5.

"Gary''s Student" wrote:

Say in row #5 there is data in A5, C5, and F5. Do you want to go to A5 or F5?
--
Gary''s Student - gsnu200793


"Meanie" wrote:

I'm trying to clean up .pdf data that was exported to Excel. The columns are
a mess so I'm working left to right. I was hoping to create a macro that
would pick up the last occupied cell to the left. It is not always in the
same column but when I run the macro, it always goes to the same column. Is
there a way to say "+, ctrl left arrow, enter" and have it repeat everytime
hit the hotkey assigned?

Or... Does anyone know a better way to clean up a worksheet?