Cell update

[Vic1976]

Hi everybody!
I'm new in using Excel together with VB utilities and therefore my problem is a quite simple one:
I have a book with several sheets and I want to update a certain cell- let's say A1 from sheet1- with the value from another cell- let's say A4 from sheet2- so that I can make a recurrent code. How can I do it? How can I say excel to do this for me a certain number of steps?

Thank you

 

[Makrini]

you mean

=Sheet2!A4

?

and welcome to the board.

 

[VoG]

Do you mean something like

Sheets("Sheet1").Range("A1:A10").Value = Sheets("Sheet2").Range("A4:A13").Value

 

[Vic1976]

The point is that I enter an initial value in excel sheet1- cell A1-, then excel makes a certain number of calculation steps, and finally returns another value in sheet2- cell A4-. My intention is making a loop so that after typing the initial value in A1 it will be updated in the later loops. Of course, it is also possible typing the initial value in A1 and becoming updated cell A2. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Do everybody understand what I’m trying to achieve? <o></o>
How can I say excel to do this for me a certain number of steps (updating cell A1 or A2)?

Thank you all<o></o>

 

[Peter_SSs]

The point is that I enter an initial value in excel sheet1- cell A1-, then excel makes a certain number of calculation steps, and finally returns another value in sheet2- cell A4-. My intention is making a loop so that after typing the initial value in A1 it will be updated in the later loops. Of course, it is also possible typing the initial value in A1 and becoming updated cell A2. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Do everybody understand what I’m trying to achieve? <o></o>
How can I say excel to do this for me a certain number of steps (updating cell A1 or A2)?

Thank you all<o></o>

Welcome to the MrExcel board!

Is this what you want?

<font face=Courier New><SPAN style="color:#00007F">Dim</SPAN> i <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">Long</SPAN><br><br><SPAN style="color:#00007F">For</SPAN> i = 1 <SPAN style="color:#00007F">To</SPAN> 4<br>    <SPAN style="color:#007F00">' Put your code here and it will be executed 4 times</SPAN><br><SPAN style="color:#00007F">Next</SPAN> i</FONT>

(My wife and I recently visited Barcelona for the first time and loved it!!)

 

[Vic1976]

Thank you all!!!
My code is now workin'!!!!