Results 1 to 5 of 5

Copy data from one file to an other file

Threaded View

  1. #1
    Registered User
    Join Date
    12-30-2017
    Location
    Luxembourg
    MS-Off Ver
    2016
    Posts
    33

    Copy data from one file to an other file

    Hello,

    I have to copy 120 sheets per month for some months from one WB to a second one. The shape of the area is the same: F5:AC66.

    At first glance the operation may seems useless, but it is necessary due to a new system of calculation and it seems the best choice to me to copy the data from the sheets with the ancient formulas to the sheets with the new formulas.
    Beside the action of copying the macro has also to create a sheet in the destination WB for every sheet in the source WB that doesn't exist yet and to put the name of the sheet into the cell U1 of every sheet.
    There are 3 sheets that don't have to be copied: DoNotCopy 1 to 3.
    How should the code look like which could do the required performance?
    Kind regards

    AmicusA
    Attached Files Attached Files
    Last edited by AmicusA; 01-17-2018 at 06:11 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy the data from Master file and paste into individual excel file as per criteria
    By Vikas_k in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-30-2023, 09:15 AM
  2. Macro to copy fresh data from master file n paste to destntion file
    By awl0111 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-13-2017, 02:56 AM
  3. Replies: 1
    Last Post: 07-11-2015, 01:04 AM
  4. Require help in modifying the code to copy data to an existing file instead of new file
    By ahamedcader in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2014, 02:57 PM
  5. Replies: 3
    Last Post: 05-21-2013, 08:22 AM
  6. [SOLVED] open variably named file, copy/paste data into consolidation file, open next file in list
    By sllawrence1968 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 09:49 PM
  7. [SOLVED] Macro to copy file names and data from each file in a folder into master spreadsheet
    By dee1989 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-10-2012, 05:52 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1