If/then macro tranposing information from one sheet to another in a different format

[Drunsul]

I have a spreadsheet that auto-updates itself from a file, each entry making up a new row of data. In one cell of the row there will be 3 different possible answers. Looking for a macro that reads the new cell each time a new row is entered and puts an "X" in a specific cell on another worksheet depending on which of the 3 possible choices are made. Each of the three choices goes to a different cell on the other worksheet. Thanks for the help!!

[arlu1201]

Please attach a sample file.

[Drunsul]

I am unable to provide a sample BUT it would look something like this.

Date Qnty Part# From To
6/11 20 1 CA OH
6/12 5 1 OH NV
6/13 3 1 NV CA


The second sheet has 6 different check boxes. One for each location that it's going from and one for each location that it's going to and an "X" is placed in the boxes and also clear any "X"s that were previously on there.

So:

FROM: OH ___ NV ____ CA ___
TO: OH ___ NV ____ CA ___

So as new data is entered on sheet1, it needs to update the check box on sheet2.

Hope this helps!