+ Reply to Thread
Results 1 to 3 of 3

Lookup data based on date, paste in different workbook based on date

  1. #1
    Registered User
    Join Date
    09-20-2010
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Lookup data based on date, paste in different workbook based on date

    I would like to do is create a macro that goes into document1, copies data based on the date into document2 based on the date. Is there anyone who can help me with this.

    Thank you!!!!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    12,988

    Re: Lookup data based on date, paste in different workbook based on date

    Are you asking to have the macro look in document2 based on the date in any particular row, find that same date in doc2 and return "blocked" and "Pickup" from that same row?
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    09-20-2010
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Lookup data based on date, paste in different workbook based on date

    The dates will always be in the same column and row for document2. The dates will always be in the same column on document1, however the rows will change (Please see the new attached). Once today passes, it will no longer be displayed on document1. So 9/20/2010 will be gone and cell A4 will start with 9/21/2010.

    I would like to be able to look up the values in document1 under "blocked" and "pickup" based on the date and paste into document2 under "blocked" and "pickup" for the same dates.

    Is this possible?

    Thank you so much for your help!!!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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