Closed Thread
Results 1 to 3 of 3

Need Macros to pull Data from one file into another - Several sheets involved - Mac

  1. #1
    Forum Contributor
    Join Date
    07-31-2014
    Location
    Texas
    MS-Off Ver
    Mac 2011 Version 14.5.4
    Posts
    106

    Need Macros to pull Data from one file into another - Several sheets involved - Mac

    Hi again everyone!
    **This is posted elsewhere but I only got a Macros suitable for Windows**

    I have two files Daily_Stress and SampleTest. SampleTest has column J that needs to be filled in using B and E as a reference. The Macros should pull data from Daily_Stress. Column B matches with Column A in each sheet of Daily_Stress. Column E matches with one of four Sheets in Daily_Stress. R1=R1, R2=R2, and PB1=PB1. Column J of SampleTest will ultimately be filled in with the data from the correct cell in Column E from Daily_Stress.

    BUT here is the kicker and the really confusing part. I cannot have 2/2/2015 on SampleTest matching with 2/2/2015 on Daily_Stress. Instead, I need the cell connected to 2/2/2015 on SampleTest to pull in data from 2/1/2015 on the correct Daily_Stress Sheet. I am trying to list the number of tourists the day BEFORE each sample was collected.

    Does this make sense? I attached the files and the first half of column J is filled in already.

    Whatever Macros is created, I need it to please run on a Mac.

    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Excel 2016
    Posts
    2,379

    Re: Need Macros to pull Data from one file into another - Several sheets involved - Mac

    The punishment for not crosslinking is a Japanese **** rocketsled ride: https://www.youtube.com/watch?v=zHiLIWe5GSo

    I'll let it "slide" this time since you at least mentioned it.

    Here is the crosslink:
    https://www.excelforum.com/excel-pro...ml#post4861577

    I think the macro works, it's just a path issue, "/" vs ":" or something.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    17,762

    Re: Need Macros to pull Data from one file into another - Several sheets involved - Mac

    Duplicate thread closed. If you need to, edit the title of the original thread.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

Closed 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1