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

Hi again everyone!

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!

Do I need more clarity? This file has a bit of a time crunch so I would love to find someone to help.
Thank you!

Originally Posted by dflak

Here is my shot at it.

In call B2 enter the path name to the source file. If you leave it blank it will assume the same path as the spreadsheet running the program.

In cell B3 enter the file name with the data

Click on the button.

Thank you so much! Unfortunately, it is not reading the file path. Could this be a Mac issue? When I select Debug it highlights this part of the code:"' Check that the file exists
If Dir(PathName & "\" & FileName) = "" Then"

Does anyone have a suggestion for how to adapt this code for a Mac? Thank you!

*sigh* They closed the thread on the Mac section.
Thanks for trying Jacc, but your fix didn't work.

I'm going to sit down at a Windows machine tonight and see if I can get the original code to work. Which is ok for the short term, but it really would be better to have it for a Mac.

Originally Posted by xlnitwit

Hi,

Don't use "\"- use

Please Login or Register  to view this content.

!!!!!!!! This may have done it!!!!!! Let me double check a random selection of data rows first.
THANK YOU

xlnitwit - your name should be xlawesomegeniusbrain

Thank you! You saved me weeks of error prone work with your simple edit. And I learned something new too!