I'm trying to write a macro to lookup the last number used in a column and auto generate the next number on another worksheet. This is what I have so far, the number changes but not base on the last number.
Please Login or Register to view this content.
Bookmarks