Macros - Return a value based on two dates

Hi,

I currently have a set of data with some dates that are entered by a user. What i want to do is check whether the dates fall within a particular range and if so, return that range in one cell. The dates may fall in multiple ranges so the ranges may need to be concatenated in once cell. Once one row has been checked, I want the macro to work it's way down the list until there is no more data. I did a bit of reading and I think it might be some kind of do loop with a vlookup perhaps? I'm quite inexperienced with macros so any help would be much appreciated. See attached for a better explanation.

Cheers

Try this user defined formula

Please Login or Register  to view this content.

Alt F11 to get to the VBA editor. Insert-module. Paste in the above. Alt F11 back to worksheet.

Paste

=GetSalesDrives(D4,F4,'Range Lookup Formula'!C11:C23,'Range Lookup Formula'!D11:D22,'Range Lookup Formula'!E11:E23)

into H4 and copy down.