Use Excel data to find files on local drive

I have an Excel spreadsheet with 7 columns. In column 1, the 14 digit character "20121234554321" is part of a file name that should be located on my computer's hard drive. Column 6 is a date field "06/11/2012". The files that I need to locate are named as follows: "column 1"(space)"NOS"(space)"column 6" (no slashes, dashes..." or "20121234554321 NOS [url removed, login to view]".

I want the macro or script to take the data from the two columns, conduct a search of a selected drive, folder, subfolder...and return two results. First result a list of the files not found and secondly, copy the found files to a created folder on the desktop.

I have attached a sample spreadsheet. The files that I am looking for are all pdf files.

The macro or script should be portable, meaning that I can use it on future spreadsheets that have the same format as the sample.

Time is critical.

Taidot: Excel, Visual Basic for Apps

Näytä lisää: local search script, excel 16, drive time, find my name, attached files, Use, macro excel, macro + excel, find my, excel visual basic, excel 7, data visual, macro script file, excel digit, sample visual basic excel, copy pdf excel macro, computer folder, drive script, 504, copy result excel, return time excel, excel copy format file, excel sample file, file name excel, search list excel

Tietoa työnantajasta:
( 18 arvostelua ) Hot Springs, United States

Projektin tunnus: #1718601

Myönnetty käyttäjälle:


We are a team of excel VBA experts and we can do it easily. Looking forward to work with you on this.

$30 USD 1 päivässä
(16 Arvostelua)

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Ready to develop and complete macro in next 2-3 hours.I am expert in these kind of work with heavy experience.I am available now to start off and can finish it in mentioned time....Thanks

$60 USD 1 päivässä
(69 arvostelua)

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)

$30 USD 1 päivässä
(20 arvostelua)

Good day! I'm an IT savvy and well handling on Excel and VB. I can help you on this!

$60 USD 2 päivässä
(0 arvostelua)