I want the data entered in the textboxes to also empty on to another worksheet called 'Worksheet AT' only starting in 'B10'
the data is go here:
'copy the data to the database
ws.Cells(iRow, 1).Value = Me.LstNm.Value
ws.Cells(iRow, 5).Value = Me.FrstNm.Value
newSheetName = ws.Cells(iRow, 1) & "," & ws.Cells(iRow, 5)
but I also want it to show on 'worksheet AT' starting with cell 'b10'
I am quite slow at vba code so explain resolution to me in simple terms. baby steps please.
Thanx for taking a look at this for me.
Bookmarks