Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a row with data
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! -- igor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a row with data
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 wrote: 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! -- igor -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a row with data
Thank you vey much for you help, Dave.
I'll take a look at the links to see if it helps me. -- igor "Dave Peterson" wrote: 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 wrote: 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! -- igor -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry | Excel Programming | |||
Save 60% on Data Entry, Data Conversion, Data Processing Services byOffshore-Data-Entry | Excel Programming | |||
Reliable Data Conversion,Data Formats and Data Entry Services by DataEntry India | Excel Programming | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data | Excel Programming |