In the attached Sample file, I have a tab called ‘DataLists’ that I need to loop through the existing “State” tabs and paste in the “State” and “County” information starting in cell B4 that is copied from ‘DataLists’. The data pasted should only be relative to the “State” listed in column G of ‘DataLists’.
Any help would be greatly appreciated. Thank you!
P.S. I'm using Excel 2010