Đang Thực Hiện

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.

Kỹ năng: Excel, Visual Basic cho Ứng dụng

Xem thêm: local search script, excel 16, drive time, attached files, use, 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, local file, find file

Về Bên Thuê:
( 18 nhận xét ) Hot Springs, United States

Mã Dự Án: #1718601

Đã trao cho:

expertatwork

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

$30 USD trong 1 ngày
(16 Đánh Giá)
3.6

4 freelancer đang chào giá trung bình $45 cho công việc này

mrbrave

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 trong 1 ngày
(69 Đánh Giá)
5.3
ineedWorkJob

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 trong 1 ngày
(20 Đánh Giá)
4.8
BenHowe

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

$60 USD trong 2 ngày
(0 Đánh Giá)
0.0