Results 1 to 27 of 27

extract excel sheet and save in reference folder

Threaded View

  1. 05-13-2016, 01:06 PM #1
    gondal
    gondal is offline
    Forum Contributor
    Join Date
    04-19-2015
    Location
    pakistan
    MS-Off Ver
    2013
    Posts
    335

    extract excel sheet and save in reference folder

    hello all

    PFA ..in given sheet in column "J" file names are under it.i have similar file name folder at desktop and sub folder in it with company name which is in sheet 3 column B & C..
    all folder and sub folders are in one folder which name "Main" at desktop.

    i want in sheet 1 only UM 01 data automatically save in sub folder of UM 01 and similar all others.

    result like sheet 2..mean only excel sheet in sub folder




    Gondal
    Attached Files Attached Files
    Last edited by gondal; 05-15-2016 at 05:26 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto save to specific folder based on cell contents
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2015, 09:07 AM
  2. macro to bring up stored workbook, auto save to a new folder, then auto fill
    By Rick23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2014, 06:58 PM
  3. vba to print active sheet to pdf, auto save in specific folder then mail using outlook
    By lathamashly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2014, 04:57 AM
  4. auto save e-mail attachment to folder after sending
    By ncaravela in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2010, 05:23 PM
  5. auto save to a folder resurrection
    By stevesunfold in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-22-2008, 08:08 AM
  6. Save WB from reference found in cell D1 to specific folder
    By Annette in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2006, 12:35 PM
  7. I like to open a folder,auto print,save then close
    By tied of opening files in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2005, 06:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1