Personally, I try to keep all my data on one sheet. I'd use data|filter or
data|sort to get views into how the data is categorized.

If I have to put stuff on other sheets, I'll do all my data entry (whatever
means necessary), then split the data whenever I need to. It's not automatic
during data entry, but it can be mechanized.

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Theguyfromnj wrote:

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

--

Dave Peterson