# copy and pasting thousands of cells.

1. ## copy and pasting thousands of cells.

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

2. you can use the vlookup function

3. Suppose you have:

• In sheet1 the list of stores, cities and states in columns A, B and C respectively.
• In sheet 2 you have the stores numbers in column A starting in row 1.

Then this is what you can do:

1. In sheet2 column B1 enter the following:

=VLOOKUP(\$A1,Sheet1!\$A\$1:\$C\$10,2,FALSE)

2. In sheet2 column C1 enter the following:

=VLOOKUP(\$A1,Sheet1!\$A\$1:\$C\$10,3,FALSE)

3. Do autofill to update the rest of the cells in columns B an C

http://www.exceldigest.com/myblog/20...okup-function/

http://www.exceldigest.com/myblog/

4. Thank you so much!

That basically helped save me a lot of time!

Matt

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1