+ Reply to Thread
Results 1 to 3 of 3

How to combine these two files with VBA

  1. #1
    Registered User
    Join Date
    09-17-2021
    Location
    Gdynia
    MS-Off Ver
    2016
    Posts
    66

    How to combine these two files with VBA

    Hey All,
    I have two files. The first one has the data updated every month and needs this data to be updated to his output file using VBA. The problem is that in the first file I have a date range of two years, and in the output one only for a year. I would like to create a button function that will update items with reference to the date. The data is always in the same place in the same range in two files. But I don't know what function, where to start and how

  2. #2
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,220

    Re: How to combine these two files with VBA

    Start by adding an attachment explaining what's going on. Read the yellow banner at the top of the page.

    Artik

  3. #3
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: How to combine these two files with VBA

    Please, check Forum rules about cross-posting (rules #3).

    Cross-post here: https://www.mrexcel.com/board/thread...h-vba.1182325/


    Moderator Note for @Palucci: Please read this link: https://www.excelguru.ca/content.php?184
    Last edited by alansidman; 09-20-2021 at 09:47 AM.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to combine different files
    By kdraghu in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-27-2020, 02:31 PM
  2. Excel vba to tel adobe combine two pdf files based on a spcified list of files
    By Abbadon486 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-30-2014, 12:04 PM
  3. Combine files in VBA
    By Andy910104 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-19-2014, 03:17 PM
  4. Combine all Files into 1
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2009, 12:56 PM
  5. Combine files
    By TinaK819 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-30-2009, 03:07 PM
  6. Combine csv files
    By RevJeff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2006, 04:55 PM
  7. [SOLVED] combine two files
    By Charles in forum Excel General
    Replies: 1
    Last Post: 08-09-2005, 05:05 PM

Tags for this Thread

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