I want to have macro form button with a code on it that when click the selected cell will be the last non-empty cell on the Column B. Note B1 is non-empty. because that's where I'm keeping the visibility of the button. Also the Column A is pre-filled with data(ID No.) thats why i need the code to check the Column B. Please let me know if there are more information needed.