Add a row with data

[Igor]

Hello, everyone,

I'm hoping that one of you can help me.

If I add a row in Sheet 1 and input data into it's cells, how can I have a
duplicate row added automatically in Sheet 2 (i.e. containing the data I just
added in Sheet 1)?

Thanks in advance!

 

[Dave Peterson]

Excel isn't really good at pushing data to other locations.

You can use event macros to try to do this, but in my thinking, it would be too
complex to make the process robust.

I do my best to keep all my data on one sheet and then use data|sort or
data|filter to see what I want to see.

But....

If you really have to create multiple worksheets based on a unique field/column,
you could do all the data entry on one sheet, then when you're ready, you could
split it up.

I'd look at these techniques:

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

 

[Igor]

Thank you vey much for you help, Dave.

I'll take a look at the links to see if it helps me.


--

igor

Excel isn't really good at pushing data to other locations.

You can use event macros to try to do this, but in my thinking, it would be too
complex to make the process robust.

I do my best to keep all my data on one sheet and then use data|sort or
data|filter to see what I want to see.

But....

If you really have to create multiple worksheets based on a unique field/column,
you could do all the data entry on one sheet, then when you're ready, you could
split it up.

I'd look at these techniques:

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