Hello. I only have a bit of VBA experience, and I was hoping you all could help me with a macro that I have been trying to come up with for a few days (with spectacularly poor results).
I have a spreadsheet with three tabs (Tab1, Tab2, and Tab3). Every value in column A of tab2 is aslo in column A of tab1, but they are not in the same order because tab1 has a lot more rows (like 500,000 more...). I have been trying to come up with a macro that will: 1. look for each value in column A of tab2 in column A of tab1, and 2. copy that whole row to tab3.
This is really simple to do by hand. I look at cell A1 in tab2, and then go to tab1 and search for the value I just looked at. The search returns a match, and I copy the row and past it into row 1 of tab 3. It really easy to do (basically just a lot of control+c, control+f, control+v), but doing it thousand of time will take a while. Thank you for any help; it is really appreciated.
Bookmarks