Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing data on multiple worksheets
I created a workbook, that contains all of the same customes and data. I want
to know if there is a way that when I edit data on the first worksheet, the data will edit also, even though they are in different cells. Any suggestions?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing data on multiple worksheets
Don't do it.
Keep your data that you update in one worksheet. Then try to use data|sort or data|filter|autofilter to see what you want. But if you have to make separate worksheets (to share with customers???), you can split the data (as a report--not for updating) into different worksheets. 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 Derek wrote: I created a workbook, that contains all of the same customes and data. I want to know if there is a way that when I edit data on the first worksheet, the data will edit also, even though they are in different cells. Any suggestions?? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing data on multiple worksheets
Only if the cells are linked back to the first worksheet.
See help on "linking". Gord Dibben MS Excel MVP On Thu, 16 Aug 2007 18:04:57 -0700, Derek wrote: I created a workbook, that contains all of the same customes and data. I want to know if there is a way that when I edit data on the first worksheet, the data will edit also, even though they are in different cells. Any suggestions?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying data from multiple worksheets | Excel Discussion (Misc queries) | |||
editing and analysis of cells in multiple worksheets AND workbooks | Excel Discussion (Misc queries) | |||
How do i update multiple data ranges across multiple worksheets? | Excel Discussion (Misc queries) | |||
same data multiple worksheets | Excel Discussion (Misc queries) | |||
How to link worksheets so editing one will edit others automatica | Excel Worksheet Functions |