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.

Hi,

We need a little more detail - do you want to put the user name in a
specific location in column M. Do you want it to do this everytime they make
a change, what if they change the same cell 5 times, do you want the name 5
times? If all you see is the name 5 times what use will that be? What do
you mean by an "entry is scanned"? Is the change of any cell in the workbook
constitute a trigger for this or is it only in one sheet, and is it anywhere
on that sheet or only in a specific range?

What kind of changes should trigger the auto populate- clearing a cell,
entering data, formatting a cell, deleting a column, editing a formula,
entering text, entering numbers, entering dates, add a picture to the file,
inserting a chart, pivot table, autoshape, ....

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"BAKERSMAN" wrote:

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.

The spreadsheet I am referring to is used to track a specific raw material
that is used throughout a shift. We will probably use 200 or more boxes in a
shift. Everytime a box is used, the employee will scan a barcode on the box.
The time and date it automatically populated. There are fomulas used to
separate the differnt aspects of the bar code; date of manufacture, location,
lot, ect. I am looking to have the user's name populate everytime a barcode
is scanned and all the above mentioned data is populated. There is a shift
detail on sheet one of the book that has a place for the emplyees name. I am
looking to have this name populate into each cell of colum "M" each time a
new box is scanned. The importance of having the name is that a new employee
could take over during the shift and we would then need to see their name in
the spread sheet as they would have changed the shift detail on sheet 1.
Hope this is the detial you are looking for.

"Shane Devenshire" wrote:

Hi,

We need a little more detail - do you want to put the user name in a
specific location in column M. Do you want it to do this everytime they make
a change, what if they change the same cell 5 times, do you want the name 5
times? If all you see is the name 5 times what use will that be? What do
you mean by an "entry is scanned"? Is the change of any cell in the workbook
constitute a trigger for this or is it only in one sheet, and is it anywhere
on that sheet or only in a specific range?

What kind of changes should trigger the auto populate- clearing a cell,
entering data, formatting a cell, deleting a column, editing a formula,
entering text, entering numbers, entering dates, add a picture to the file,
inserting a chart, pivot table, autoshape, ....

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"BAKERSMAN" wrote:

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.