Good Morning, I'm new to working with Macros with Excel and looking for some help.
I've attached a spreadsheet with what I'm working on. I'm trying to figure out how to do some productivity numbers at a warehouse. Every time an employee scan and picks a case it creates a row on the spreadsheet but it only shows there "User" name on the first scan. I get this file for everyday. I want to set up something so it automatically fills out the user name for each row. I've highlighted the spaces I wanted to populate in yellow and the username in green. but I'm not sure how to have excel put in the user name automatically. This report was created so it can be printed out so it has header information which I've highlighted in orange. I don't need anything in the orange to do anything.
I don't know if there is a way to set it up so it looks for a list of user names and if the cell underneath it is empty it puts in the user. I've got another worksheet in there with a list of usernames.
Bookmarks