VBA LOOP

[wwexcel]

Hello All,

Something simple I hope..

Have 3 worksheets.
Worksheet one has a list of numbers 1-100.
Worksheet two will fish into worksheet one and retrieve the number one from cell A1.
When placed back in worksheet one, the number 1 will trigger calculations all across that row. I then would like that row to be copied, and pasted to a row in worksheet 3.

Repeat until there are 100 rows in worksheet three.

Any suggestions would be most appreciated ! Thx

 

[FrancisL]

First, it would help if you explained Why you want to do this.
Second, why would Worksheet two need to go into worksheet one to retrieve the number one from cell A1 if you already know it contains One?
Third, it sounds like something that might be better done in a relational database, without any VBA at all.
I keep coming across Excel being used when the functions are far better done in (say) Access