2 Loops for 2 worksheets

[creechmikel]

Ok, I two worksheets within the same workbook. While I'm on the first worksheet I want to loop through the each vaule in a particular column. With that value, I need to go to worksheet 2 and look for that a match on the value from the original worksheet and then capture cell values within that row, go back to the original worksheet and plug those values in or replace data.

I thought this could be done with two loops, but it doesn't seem quite efficient and I am having a problem, keeping active the sheet I need to loop on.

Any help or guidance would be greatly apprecieated.

Thanks.

[mikerickson]

Would VLOOKUP formulas with lookup_values from the first sheet get the results that you want?