referencing from one sheet to another, cant reference from column to row

[cicapuki]

Hi!

I have 2 sheets. On one sheet I have a vertical column with numbers from 1-36. I would like to reference these numbers in a second sheet however to a horizontal row. WHen I am referencing :
first =Calculations!F12
second: =Calculations!F13
third= =Calculations!F14

I have a lot of numbers, how can I copy the formula so it will automatically reference to sheet 1? I tried fixing with $F12 however then the F column is good because it is not moving however the 12-13-14 is not growing but stays the same: f12-f12-f12-f12

[Glenn Kennedy]

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

The paperclip icon

[cicapuki]

I would like to reference from calculations sheet(turnover) to incomes sheet(hungary turnover)

[Glenn Kennedy]

in the example attached, does this do what you want?

=INDEX(Sheet1!$A$1:$A$36,COLUMN(A$1))

[Glenn Kennedy]

sorry, I didn't see your sheet. give me a minute....

[cicapuki]

I got thisUntitled.png

[Glenn Kennedy]

=INDEX(Calculations!$F$12:$F$47,COLUMNS($A:A))

but is there something wrong with the calculations in column E of calculations? It looks very odd...

[cicapuki]

To be honest I didnt know how to automate that so I wrote it bymyself

[Glenn Kennedy]

What is it trying to do?

[cicapuki]

same problem again

Untitled.png

[Glenn Kennedy]

you had 3 different formulae in the first 3 cells. Maybe this is what you wanted...

=C12+(SUM($D$12:D12)) copied down.

[Glenn Kennedy]

The first character should be an equal sign, not an underscore. there may also be problems, cos you might use a comma separator in Hungary. see this sheet,

[cicapuki]

Thank you so much!!

[Glenn Kennedy]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.