+ Reply to Thread
Results 1 to 8 of 8

create sheets based on extensions files and copy to each months

  1. 03-15-2021, 04:16 AM #1
    ABDELFATTA
    ABDELFATTA is offline
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    create sheets based on extensions files and copy to each months

    hello
    I have many folders in my directory contains many extension file in my folders PDF, XLSX, XLSM, XLS, DOC .. etc.
    so what I want create sheets after sheet main based on extension files and create header of months and copy the files each of months and update when I add anew files in the folder
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-17-2021, 02:22 AM #2
    ABDELFATTA
    ABDELFATTA is offline
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: create sheets based on extensions files and copy to each months

    any helps experts, please?
    Reply With QuoteRegister To Reply
  3. 03-19-2021, 12:08 AM #3
    ABDELFATTA
    ABDELFATTA is offline
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: create sheets based on extensions files and copy to each months

    assistance guys?
    Reply With QuoteRegister To Reply
  4. 04-06-2021, 09:44 AM #4
    ABDELFATTA
    ABDELFATTA is offline
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: create sheets based on extensions files and copy to each months

    is not possible?
    Reply With QuoteRegister To Reply
  5. 04-06-2021, 09:56 AM #5
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: create sheets based on extensions files and copy to each months


    Quote Originally Posted by ABDELFATTA View Post
    […] and update when I add anew files in the folder
    Hi,

    no automatic update so you must launch the VBA procedure each time when necessary for the current state of files …

    For further help well elaborate your need in order there is nothing to guess !
    Reply With QuoteRegister To Reply
  6. 04-06-2021, 10:00 AM #6
    ABDELFATTA
    ABDELFATTA is offline
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: create sheets based on extensions files and copy to each months

    hello
    VBA procedure each time when necessary for the current state of files
    even this I accept it
    but what I have to issue for more details if my post is not clear
    Last edited by ABDELFATTA; 04-06-2021 at 10:05 AM.
    Reply With QuoteRegister To Reply
  7. 04-07-2021, 05:29 AM #7
    ABDELFATTA
    ABDELFATTA is offline
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: create sheets based on extensions files and copy to each months

    I issued in this forum
    http://www.vbaexpress.com/forum/show...621#post408621
    Reply With QuoteRegister To Reply
  8. 04-07-2021, 06:04 PM #8
    ABDELFATTA
    ABDELFATTA is offline
    Forum Contributor
    Join Date
    06-02-2019
    Location
    libya
    MS-Off Ver
    2010
    Posts
    734

    Re: create sheets based on extensions files and copy to each months

    it's solved
    thanks Mr. Kenneth Hobs for a great assistance
    anybody interests just follow the link
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Create New Folder Based on Cell Name and Copy Files into it
    By mattmar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2020, 11:29 AM
  2. [SOLVED] create a new sheets & copy data from sheet to multiples and sum based on month
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-11-2020, 09:56 AM
  3. Create list from sheets and copy based on value
    By daniel79 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2019, 09:53 PM
  4. [SOLVED] VBA to create folders and copy files based on file names
    By R12345 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-28-2017, 10:45 PM
  5. [SOLVED] VBA: Create new sheets based on cell value and copy data
    By Metrazal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2015, 07:33 PM
  6. create an array of files with certain extensions
    By duckboy1981 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2010, 08:17 AM
  7. getting files' extensions?
    By ahartman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-16-2008, 12:50 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