row to refer to formulas in a column on another worksheet

If you're rows are contiguous and match from sheet1 to sheet2, why not just use =Sheet1!B10 and fill that formula down as many rows as you need? Would take all of 5 seconds and you'd be done.

If your rows aren't setup that way, is there any other data that links the two sheets for which you could perform a vlookup or index/match function?

Originally Posted by parrothead

This has to be pretty basic, but I am not finding a solution - probably making it too complex. I have two adjacent columns of sales figures that are formulas on Sheet1. I need to have those same figures run across two adjacent rows on Sheet2. I know I can transpose the values, but I need each cell in the rows in Sheet2 to change if the corresponding values in Sheet1 change. Is there a way to make this work without doing the "='Sheet1'!B10" thing in each individual cell that I need on Sheet2?

Many thanks for any help.

see the attached file

Originally Posted by parrothead

On Sheet1
A B C
10 April 07 =b9*d10 =c9*e10
11 May 07 =b10*d11 =c10*e11
12 Jun 07 =b11*d12 =c11*e12
and so on down the page


On Sheet2, I need:

A B C
1 April 07 May 07 Jun 07
2 =Sheet1B10 =Sheet1B11 =Sheet1B12
3 =Sheet1C10 =Sheet1C11 =Sheet1C12
and so on across the page

please see the attached file from my previous post (above), it is set for the same purpose.

I can sort of see how that works, but I am just getting "#REF" errors. I think I am not following the &COLUMN reference....how does it relate to the position of the data on the first sheet?

Originally Posted by parrothead

I can sort of see how that works, but I am just getting "#REF" errors. I think I am not following the &COLUMN reference....how does it relate to the position of the data on the first sheet?

please attach here your file with data in zip format so that formula could be implemented in it.