Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I share information between multiple sheets in Excel?
New question:
I know now how to use "=sheet1!a1" to copy cells from sheet 1 to sheet 2,3 etc. Is there is a formula that will allow me to enter data into sheet 2, and have it copy automatically into sheet 1 and 3, or into sheet 3 going to sheet 1 and 2? So that I can enter the data into any sheet and have it transfer to all sheets, rather than always from sheet 1 to sheets 2 and 3. |
#2
|
|||
|
|||
How can I share information between multiple sheets in Excel?
Nothing built into excel (except for the formula you showed).
But I'd be very hesitant to separate my data. I'd do my best to keep all the data on one worksheet. You can use Data|Filter|autofilter to get different "views" of the data. You can use data|sort, too. But by splitting the data (even worse automatically), it could be very difficult to track down typing mistakes. If you want to split the data from one worksheet into many based on a column, then both Debra Dalgleish and Ron de Bruin may have solutions for you: Debra'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 or 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 And Ron de Bruin's easyfilter. http://www.rondebruin.nl/easyfilter.htm lucasjackson wrote: New question: I know now how to use "=sheet1!a1" to copy cells from sheet 1 to sheet 2,3 etc. Is there is a formula that will allow me to enter data into sheet 2, and have it copy automatically into sheet 1 and 3, or into sheet 3 going to sheet 1 and 2? So that I can enter the data into any sheet and have it transfer to all sheets, rather than always from sheet 1 to sheets 2 and 3. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to save sheets in new excel files, automatically? | Excel Worksheet Functions | |||
Can I embed or link multiple .pdf files into or to an excel file? | Excel Discussion (Misc queries) | |||
how do i find data in multiple sheets in excel | Excel Discussion (Misc queries) | |||
how do i find data in multiple sheets in excel | Excel Worksheet Functions | |||
opening multiple instances of excel | Excel Discussion (Misc queries) |