Hi
I am trying to fill cells in a worksheet where the textbox fills the next available cell in column B. I have got that bit right but i also need to do the same with column A, the problem is i have two textboxes to fill cells in B and only one in A and i want the one in A to be in the same row as the first textbox in B, it will work the first time but when i follow on there is obviously cells in A which are empty and they dont line up.
A = textbox1= "text" B =textbox2 = "text" this row is correct
empty row
A = textbox1 = "text" B = textbox3 = "text" this row in Column A should be empty
empty row
A = textbox1= "text" B =textbox2 = "text" this row is correct
hope i have explained correctly
Bookmarks