How can I edit this command button code so that when it adds the data form the userform to the sheet, that it also adds the word 'Manual' to the corresponding E column on the same row?
I tried adding the following line, but it didn't work:Please Login or Register to view this content.
.Cells(LR, 4).Value = "Manual"
Bookmarks