I have a spread sheet that I use to track the usage of a material on a
production line. I need to be able to see who is making entries in the spread
sheet. Sheet one has a place for the operator to enter their name. I want
this name to auto populate into colum "M" in the tracking spread sheet (sheet
2) everytime an entry is scanned. The person making entries into the spread
sheet will probably change 2 or 3 time a day so a general VLOOKUP would not
work, i dont think.