Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
synchronize 2 worksheets to preserve functions
I have a very large mixed product list with various different choices
available to all products. The data has been carefully added over a long period of time and is accurate. I have created another worksheet using columns that extract any relavant data for each product to create a piped string as this example. red¦red|blue¦blue|pink¦pink which will be used in a csv file to import into another application. At the moment my 2 worksheets have synchronized lines of data, but I will need to delete and add products on one of the sheets. Is there a simple way to maintain 2 synchronized worksheets without physically scrolling the 2 sheets together and making the changes to both sheets? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
synchronize 2 worksheets to preserve functions
If you select both sheets (group them) then changes made to one sheet are duplicated in the other sheet. You should experiment first in a separate test workbook. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Excel Helps" wrote in message I have a very large mixed product list with various different choices available to all products. The data has been carefully added over a long period of time and is accurate. I have created another worksheet using columns that extract any relavant data for each product to create a piped string as this example. red¦red|blue¦blue|pink¦pink which will be used in a csv file to import into another application. At the moment my 2 worksheets have synchronized lines of data, but I will need to delete and add products on one of the sheets. Is there a simple way to maintain 2 synchronized worksheets without physically scrolling the 2 sheets together and making the changes to both sheets? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
synchronize 2 worksheets to preserve functions
Thanks Jim,
I'll give that a try. "Jim Cone" wrote: If you select both sheets (group them) then changes made to one sheet are duplicated in the other sheet. You should experiment first in a separate test workbook. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Excel Helps" wrote in message I have a very large mixed product list with various different choices available to all products. The data has been carefully added over a long period of time and is accurate. I have created another worksheet using columns that extract any relavant data for each product to create a piped string as this example. red¦red|blue¦blue|pink¦pink which will be used in a csv file to import into another application. At the moment my 2 worksheets have synchronized lines of data, but I will need to delete and add products on one of the sheets. Is there a simple way to maintain 2 synchronized worksheets without physically scrolling the 2 sheets together and making the changes to both sheets? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to synchronize data value across two worksheets in one workbook? | Excel Worksheet Functions | |||
synchronize worksheets with master worksheet | Excel Worksheet Functions | |||
In Excel 2002, how do I synchronize data with other worksheets? | Excel Discussion (Misc queries) | |||
synchronize multiple worksheets | Excel Worksheet Functions | |||
HOW DO i SYNCHRONIZE MULTIPLE WORKSHEETS IN EXCEL? | New Users to Excel |