Search column in one spreadsheet to output info into another column in another spreadsheet

Hi Mary,

Here is a Loop that should do the job, you will need to change the names of the workbooks in the code.

Please Login or Register  to view this content.

Hope that helps,

Matt

Matt,
Thank you so much! Unfortunately, when I use this code, I get the error message of: Run-time error '9': Subscript out of range

I have never worked with Excel macros before so I am probably doing something wrong. I tried putting this code in each of the files, because I thought maybe it was in the wrong place?
I went to the "Developer' tab and under 'Controls' I clicked 'View Code.' I then copied and pasted the code (and changed the names of my workbooks). But when I hit 'Run' (the green arrow button), I get the error message. Any suggestions?

I would appreciate any info. you can provide! Thank you again!

Mary

Hi

Could you check these things for me.

1. You have the right file extension the files could be ".xlsm" or ".xlsx" just change the "m" or "x" in the code to fit the file type.
2. That both workbooks are currently open.
3. Check the sheet names in the code are correct, in your post you said they were "InspectionPlanByContract" and "Sheet1" if these are wrong just correct them

... Actually looking back at your equation in the post I think the issue is the sheet is called "InspectionPlanByContract_Excel" not "InspectionPlanByContract" just change that and you should be fine.

as for the code you can paste it in a module in either workbook and it should run fine.

Cheers,

Matt

It works! Thank you both so much for your help!