Quote Originally Posted by framcc06 View Post
If i wanted to get the values from Column A from Sheet2 into Column D of Sheet1 by comparing values of Column B of Sheet1 and Sheet2 would I need to use offset somewhere in the rng2 worksheet name?
I'm confused. Sheet1 doesn't have any values in column B until after one of the macros is run. So could you supply a workbook to clarify what you're wanting?