Excel Macro To Return Column Values

[MLS Packer Lover]

I'm using this macro to search for serial numbers throughout 100's of workbooks on the the C:drive. In addition to the serial number, I also want it to return the values in the next 5 columns. (Serial number is in column IQ and the other values are in columns IR:IV.)

I've attached the spreadsheet with the macro that I run, and it is called LaunchSearch. The other spreasheet is an example of a workbook that it searches through to find the serial number, etc.

Please Login or Register  to view this content.

Thank you for any help!

Michele

[blane245]

Hey Michele,

Do know how much help you need. Here is a single line to get you started. If you place this in your ProcessFolder routine below the group of lines similar, it will pick up the cell in the next column (IR) and copy it over.

Please Login or Register  to view this content.

Similar code will copy the rest of the cells

[MLS Packer Lover]

Thank you!!