Have excel search for and autofill repeat values from another spreadsheet?

**Merboy** · 09-15-2015, 08:02 AM

Hello!

I'm not sure if this is even possible but I really need some help with a problem. I have two Microsoft Excel 2007 spreadsheets that I work with every day. The spreadsheet I fill out any given day is full of order numbers listed in column B. I have to fill out column F.

The problem however is that I have hundreds of these and many, many, many of the orders are leftovers from the previous day. So what I've been doing is using the Find and Replace feature to copy each and every order number from Column B on my current day's spreadsheet and searching for it in yesterday's Column B spreadsheet. If there's a match I copy and paste the information from Column F of that spreadsheet (yesterday's spreadsheet) and paste it into Column F of today's spreadsheet. This is because I've already dealt with that order and don't need to do it again. If there's NOT a match on yesterday's spreadsheet then that means the order is new and I will need to work on it.

As you can imagine this is enormously time-consuming. So I was wondering if there was a way (a macro? a formula? I don't know) to have today's spreadsheet look at Column B of yesterday's spreadsheet, see if there are repeats and if there are then take the information from that row's Column F and automatically fill it into Column F of today's spreadsheet. Or in other words, basically do what I'm doing manually.

Is this possible? And if so how? Like I said this is taking up a tremendous amount of time and I desperately need a solution, I'm just not sure if this is even possible and I'm not extremely literate with the finer functions of Excel.

Thank you so much!

**zbor** · 09-15-2015, 08:05 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

**hoyasaxa215** · 09-15-2015, 08:58 AM

Should be possible with a =VLOOKUP. Can you upload a sanitized sample file so showing your desired outcome? Then we can just fill in the formula for you.

**Merboy** · 09-15-2015, 09:21 AM

Hey! Thanks for responding! I'm so sorry, I'm not exactly sure what you mean by a sanitized sample file? I am however including two files that are mock-up's of what my actual files are (only these are obviously fake data to protect information and there are only three orders per spreadsheet). Basically you can see in them that I'm just needing the spreadsheet for today to look back at yesterday's, find any matches in Column B, and if there are any matches then populate today's Column F with yesterday's Column F. If there is not a match obviously Column F would be left empty.

**hoyasaxa215** · 09-15-2015, 09:26 AM

Well your example didn't have any matching orders, so I added one. Also consolidated the sheets. Let me know if this works or if you have any questions.

**Merboy** · 09-15-2015, 09:36 AM

Ok, awesome thanks... I'm not sure what to actually do with this spreadsheet you provided though. I see the added row and the green cell in Column F with the forumula but what do I do with this?

**hoyasaxa215** · 09-15-2015, 09:42 AM

That's an example of populating the information you requested. The formula looks for a matching ID number and then populates the columns in Column F. You would use that formula in your files to pull in the comments from the previous day's file. Just copy and paste the formula into the new file's Column F and change the formula to reference yesterday's file.