+ Reply to Thread
Results 1 to 2 of 2

Copy data to another file based on dates when the dates in the files do not match

  1. #1
    Registered User
    Join Date
    12-17-2014
    Location
    Cincinnati, Ohio
    MS-Off Ver
    2010
    Posts
    2

    Copy data to another file based on dates when the dates in the files do not match

    Hello,

    I am trying to copy data from one file to another and it depends on the date. In one file I have every day since 1/1/2000. The other file excludes weekends and holidays. Is there a way to copy the data from the file without weekends to the file that includes weekends, while keeping the integrity of the date?
    So maybe to better explain.....I have file 1 and file 2 and would like to copy file 1 to file 2 and end up with the desired result.

    File 1 File 2 Desired
    1/1 5 1/1 6 1/1 5 6
    1/2 10 1/2 8 1/2 10 8
    1/3 8 1/3 8 1/3 8 8
    1/6 9 1/4 9 1/4 9
    1/5 10 1/5 10
    1/6 7 1/6 9 7

    Thank you

  2. #2
    Registered User
    Join Date
    12-17-2014
    Location
    Cincinnati, Ohio
    MS-Off Ver
    2010
    Posts
    2

    Re: Copy data to another file based on dates when the dates in the files do not match

    Ok so apparently the spacing did not post the way I thought it would. If I need to better explain what I need please let me know.

+ 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. VBA Code to Match Dates in Two Cells Then Copy the Data Under the Corresponding Date
    By jlanderson18 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2014, 05:33 PM
  2. Copy entire rows of data to another tab based on dates
    By photochic10 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-18-2013, 12:52 PM
  3. [SOLVED] Highlight Group of Dates if Dates Match List of other Dates
    By martinpgibson in forum Excel General
    Replies: 5
    Last Post: 10-24-2012, 08:14 PM
  4. [SOLVED] Auto filling dates based on previously entered dates and averaging numbers if dates equal
    By grambograham in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2012, 03:21 PM
  5. Copy data based on dates?
    By Galrash in forum Excel General
    Replies: 4
    Last Post: 02-28-2010, 06:54 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