Here's what I have. I would like to enter a date in one worksheet and based
on that date, find the date in the second worksheet and place a range of data
it into the first. For example:
On worksheet 1 I want to enter a date into cell d1, then I need it to look
for the date in column A on worksheet 2 and when it finds it return a range
of data thats 6 cells up and 2 to the right, 7 high and 10 wide. I'm not
having any luck. I appreaciate any help you can provide.