| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel referencing across sheets
Hi all, I've a conundrum I wonder if anyone can help me with? The situation I
have is a workbook with 2 sheets, call the Sheet A and Sheet B. I have it set so far so that whatever value I put in a specific cell in Sheet A is replicated in a specific (but not the same) cell in Sheet B. However, Excel obviously has a problem if I try to get these two cells to update each other, ie. I'd like to be able to type the data into EITHER of the cells, and for the other cell to update the data. (As opposed to always having to type it into Sheet A). Any ideas please?! Richard. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
| Updating, Deleting and inserting rows over two Excel Sheets | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
Threaded Mode
