+ Reply to Thread
Results 1 to 4 of 4

Copy Data from One File to Another File

  1. 03-19-2020, 02:16 PM #1
    ionelz
    ionelz is offline
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    Copy Data from One File to Another File

    I have a VBA which Copy Data from File 1 to File 2
    In File2, where I am working, in Range A1:C100
    I have a Formula which use this range, like Index(A1:C100,...)

    When I clean A1:C100 for a new Copy , I am loosing the reference in Index...A1:C100 became #ref!
    How to solve this ?
    Reply With QuoteRegister To Reply
  2. 03-19-2020, 04:17 PM #2
    p24leclerc
    p24leclerc is offline
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Copy Data from One File to Another File

    How do you clean your range (A1:C100)?
    If you use range("A1:C100").ClearContents, if will not change you formula.
    Deleting the cells will create an issue, though.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.
    Reply With QuoteRegister To Reply
  3. 03-19-2020, 06:17 PM #3
    ionelz
    ionelz is offline
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    Re: Copy Data from One File to Another File

    I am using .ClearContents
    But my Index is full of #refs!
    Reply With QuoteRegister To Reply
  4. 03-19-2020, 08:03 PM #4
    p24leclerc
    p24leclerc is offline
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Copy Data from One File to Another File

    is it possible to attach your workbook?
    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. [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. [SOLVED] File dialog box to open a excel file then copy data close file
    By mmikem in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-01-2019, 09:57 AM
  3. Copy data from txt file to excel file then delete text file
    By gratedane8 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-11-2018, 07:36 PM
  4. How to copy data from a source file to other excel file without opening (target files)?
    By Kyawthura in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2015, 01:04 AM
  5. Use Code written in xlsm file to open .xls file and copy-paste data from xls to xlsm file
    By kgiorgosss in forum Excel Programming / VBA / Macros
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1