Results 1 to 10 of 16

Thread: Copy data from Unique files into Masterfile all the files in the same folder.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-24-2018, 10:01 AM #3
    RaghavendraPrabhu
    RaghavendraPrabhu is offline
    Junior Member
    Join Date
    Mar 2018
    Posts
    12
    Rep Power
    0
    Once Again Doc Elstein,

    Thank you very much for your input. I am sure this will save a lot of problems we are experiencing at our work.

    The date column L should have the date the macro was run on for the record's data that was copied.

    For Example in Raghu.xlsx, record with serial no.3 and 8 are not completed. When they are completed, the column L for these two records should have the date they were copied.

    In zMaster.xlsm, again the column L should have the date the records were copied.

    Hopefully, from Monday, we will have fewer problems thanks to your input and help.

    Regards
    Raghavendra

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=314837#p314837
    https://www.eileenslounge.com/viewtopic.php?f=21&t=40701&p=314836#p314836
    https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314621#p314621
    https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314619#p314619
    https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314600#p314600
    https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314599#p314599
    https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314274#p314274
    https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314229#p314229
    https://www.eileenslounge.com/viewtopic.php?f=27&t=40621&p=314195#p314195
    https://www.eileenslounge.com/viewtopic.php?f=36&t=39706&p=314110#p314110
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40597&p=314081#p314081
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40597&p=314078#p314078
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=314062#p314062
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40597&p=314054#p314054
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=313971#p313971
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=313909#p313909
    https://www.eileenslounge.com/viewtopic.php?f=27&t=40574&p=313879#p313879
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=313859#p313859
    https://www.eileenslounge.com/viewtopic.php?f=30&t=40533&p=313855#p313855
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 03-02-2024 at 02:59 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Make macro create unique files only once.If files exist amend them.
    By RaghavendraPrabhu in forum Excel Help
    Replies: 7
    Last Post: 03-23-2018, 02:02 PM
  2. Choose folder, loop thru files to copy data & paste in new master workbook
    By sarahb76 in forum Excel Help
    Replies: 2
    Last Post: 03-09-2015, 11:26 PM
  3. Code to open up files in folder and sub-folder
    By Howardc in forum Excel Help
    Replies: 7
    Last Post: 08-26-2014, 07:01 AM
  4. VBA Macro To Open And Modify Files By Looping Through Files In Folder
    By Howardc in forum Excel Help
    Replies: 15
    Last Post: 08-23-2013, 12:03 PM
  5. Macro to copy data from a set of excel files
    By Sreejesh Menon in forum Excel Help
    Replies: 5
    Last Post: 11-15-2012, 11:17 AM

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