Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations SDETERS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA LOOP

Status
Not open for further replies.

wwexcel

Specifier/Regulator
Jun 10, 2009
1
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
 
Replies continue below

Recommended for you

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor