Im not sure if this is the right topic for this question, I apologize if
its not.

I have 3 worksheets in my excel workbook. I enter the same data in 2
of the worksheet by means of a bar code reader. However, as the data
is entered into sheet 1, the same data has to be entered into sheet 3,
but each time the data changes in sheet 1 I need it to move to another
row in sheet 3. Im not sure if this is clear so I will try to make an
example he

Sheet 1
Column A

|Product A|
|Order number 123|
|Customer name Bob Smith|

Sheet 3
Row 35

|Product A |Order number 123 |Customer name Bob Smith|

The data changes in sheet 1 every time I scan the item, so I need
something that will take the data from sheet 1 column A and copy it to
a new row on sheet 3.

Does this make sense to anyone? Can it be done?

Any help would be appreciated.

*Using an = function wont work because the data changes, and it would
change all the data in sheet 3, not just row i need updated.


--
Theguyfromnj
------------------------------------------------------------------------
Theguyfromnj's Profile: http://www.excelforum.com/member.php...o&userid=35700
View this thread: http://www.excelforum.com/showthread...hreadid=554849