| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cross Reference between sheets
Novice here...
How do I carry a value found on one sheets cell over to another sheet. So I want the value located on sheet 2 BE,30 to be carried forward to 'sheet one' at a cell location. Effectively its a budget imp making for a project. I have different pages showing different types of expenses, On the front page however, I wish to have the various subtotals of all the individual pages showing, always reflecting any changes throughout the document. thank you for your help JP |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cross Reference between sheets
In 'sheet one'!A1 enter formula:
='sheet 2'!BE30 HTH -- AP "JP" a écrit dans le message de news: ... Novice here... How do I carry a value found on one sheets cell over to another sheet. So I want the value located on sheet 2 BE,30 to be carried forward to 'sheet one' at a cell location. Effectively its a budget imp making for a project. I have different pages showing different types of expenses, On the front page however, I wish to have the various subtotals of all the individual pages showing, always reflecting any changes throughout the document. thank you for your help JP |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cross Reference between sheets
thanks..worked a treat
"Ardus Petus" wrote in message ... In 'sheet one'!A1 enter formula: ='sheet 2'!BE30 HTH -- AP "JP" a écrit dans le message de news: ... Novice here... How do I carry a value found on one sheets cell over to another sheet. So I want the value located on sheet 2 BE,30 to be carried forward to 'sheet one' at a cell location. Effectively its a budget imp making for a project. I have different pages showing different types of expenses, On the front page however, I wish to have the various subtotals of all the individual pages showing, always reflecting any changes throughout the document. thank you for your help JP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying the same cells from many sheets | Excel Worksheet Functions | |||
| can i use a cell value as another sheet's cell reference | Excel Worksheet Functions | |||
| How do I locate a highlighted cell as a cross hair type reference | Setting up and Configuration of Excel | |||
| Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Linear Mode
