Set formulae to read the adjacent or next spreadsheet

J

Jammings

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

T. Valko

You can use INDIRECT but you haven't provided enough info to make a more
specific suggestion.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup by date 10
How to Automatically transfer specific Data from Sheet 1 to Sheet 12
How do I pull data for consecutive months in an Excel spreadsheet 2
Referecing Worksheet names that are dates in a formula 2
Need to count dates in a spreadsheet 4
Splitting data from one spreadsheet into multiple spreadsheets 2
Challenging Formula Issue 1
Lookups - how to obtain data from a master spreadsheet into another 5

Top