assigning value to a cell from a cell on another sheet

[kato01]

Hello,

I am in sheet5.cells(737,1) and i need to have in that cell the value of sheet1.cells(3,2).

I would like to use a formula, not a macro.

Any suggestions?

Thanks

 

[Smitty]

Welcome to the Board!

Should just be: =Sheet1!B3

HTH,

 

[Norie]

Couldn't you just put this formula in row 737, column 1(A) on the worksheet named 'Sheet5'?

='Sheet1'!B3

Or is there more to what you want to do?

 

[kato01]

Welcome to the Board!

Should just be: =Sheet1!B3

HTH,

Thank you for your answer.

I though about that but I need to use the cell.(x,x) function. I need to be able to do this in a loop like:

I need to define

for i=2 to 101
sheet1.cells(3,i) = sheet5.cells(737,1+13*(i-1))
next i

I don't think I can do this with letters

 

[Smitty]

I don't think I can do this with letters

Sure you can, just copy the original formula and paste it across as far as you want it.

 

[Norie]

Katto

If you want help you really need to explain what help you want.