ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Set formulae to read the adjacent or next spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/212754-set-formulae-read-adjacent-next-spreadsheet.html)

Jammings

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

T. Valko

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





All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com