| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set formulae to read the adjacent or next spreadsheet
Can I sent a formulae in the column one sheet such that the column to the
right pick up data from the sheet to the right of the current. eg there are four sheets first sheet - master sheet second - january third - february Fourth - march Column b should read data in january sheet Column C should read data in February sheet Column D should read data in March sheet |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Set formulae to read the adjacent or next spreadsheet
You can use INDIRECT but you haven't provided enough info to make a more
specific suggestion. -- Biff Microsoft Excel MVP "Jammings" wrote in message ... Can I sent a formulae in the column one sheet such that the column to the right pick up data from the sheet to the right of the current. eg there are four sheets first sheet - master sheet second - january third - february Fourth - march Column b should read data in january sheet Column C should read data in February sheet Column D should read data in March sheet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| displaying adjacent cell when using max/min formulae | Excel Worksheet Functions | |||
| Ruby access to an existing Spreadsheet with complex formulae | Excel Discussion (Misc queries) | |||
| Average Non-Adjacent Cells in Budget Spreadsheet | Excel Worksheet Functions | |||
| Average Non-Adjacent Cells in Budget Spreadsheet | Excel Worksheet Functions | |||
| Formulae in spreadsheet no longer update with new data | Excel Worksheet Functions | |||
Linear Mode
