Hey everyone,
This is my first time posting on this website and I really need some help. I have been spending endless hours copy and pasting stuff from one workbook to another.
Here is my situation.....
To make it simple I have one workbook that in column A- i have numbers listed 1-10. Then in column B each number is matched with a city. Then in column C each city is matched with a state. So for example #1 could be Erie, PA, #2 could be Anaheim, CA, and #3 could be Miami, FL.
My other worksheet then just has the store number so I may get numbers 1, 4, 7, and 9. With this worksheet I don't get the cities and states to go along with the number. So what I have been doing is taking both sheets finding where the numbers match and then taking the city and state from my template and pasting it in the cells two to the right on my page with the random numbers. The only problem is I am doing this with thousands of different cells not just a couple.
I feel like I need to tell excel if anything in column A from workbook 1 matches anything from column A in workbook two fill in the cells 2 to the right from the original template workbook. I have no idea where to start with this process and was hoping that someone could help me out! My eyes are starting to bug out and my hands are starting to hurt clicking copy and paste a couple thousand times.
I would appreciate any help!
Thanks,
matt
Bookmarks