VBA LOOP
VBA LOOP
(OP)
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
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





RE: VBA LOOP
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