+ Reply to Thread
Results 1 to 4 of 4

Req.vba code searching bill no.s and copy to another folder

  1. #1
    Forum Contributor
    Join Date
    06-16-2018
    Location
    India
    MS-Off Ver
    2021
    Posts
    177

    Req.vba code searching bill no.s and copy to another folder

    Dear Sir,

    I have a sheet, the first sheet contains a list of bill nos. These bills are in a folder E:\SUBHASH FILES\APR-22-BILLS\

    PDF DIR.png

    I need vba code by searching in the bills above folder in the sheet1, & copy those bills to another folder. D:\APR-22 COPY BILLS\

    xls sheet.png

    which bills were not searched, that bill has to be written in sheet2

    Please help me.

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,514

    Re: Req.vba code searching bill no.s and copy to another folder

    Please Login or Register  to view this content.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    06-16-2018
    Location
    India
    MS-Off Ver
    2021
    Posts
    177

    Re: Req.vba code searching bill no.s and copy to another folder

    Superrrrr , Sintek Sir

    code working 100% perfect

    Thank you very much.. Sir

  4. #4
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,514

    Re: Req.vba code searching bill no.s and copy to another folder

    ..........................
    Thanks.png

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA code Sub Open Folder / searching sub folders isn't working
    By Nebucanezars in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2021, 02:18 AM
  2. [SOLVED] Searching For Code: Collect Languages and copy
    By missginius in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2021, 10:01 AM
  3. [SOLVED] VBA Code to Copy a folder Template
    By Subtotalatom in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-05-2020, 06:55 PM
  4. Replies: 3
    Last Post: 08-13-2019, 06:03 AM
  5. Code to copy pdf files from a folder
    By tejboyd in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-22-2016, 05:56 PM
  6. [SOLVED] VB Code to COPY certain files in another folder
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2015, 10:27 AM
  7. [SOLVED] VBA Code open files in folder, copy text to workbook-Next time folder opened copy only new
    By Bikeman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2013, 07:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1