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 here:
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.
Bookmarks