Date parameter search function

**macquhele** · 12-04-2012, 02:28 PM

Hi guys

Is it possible to create a date parameter search function.

As an example I have a list of stock items with quantities that have been bought on certain days. Is it possible to create functionality to be able to type in 2 dates, a stock item and get a return of number of the stock item bought within that date period.

Any help greatly appreciated.

Regards.

**xladept** · 12-04-2012, 03:08 PM

Hi macquhele:

This is set up for dates in Column A And Output on sheet 1 in the same book:

Please Login or Register  to view this content.

And you invoke it like this:

Please Login or Register  to view this content.

**macquhele** · 12-05-2012, 04:33 AM

Hi there.

Thank you for the quick response. I struggled to get your code to work to be honest. I've attached a sample database of what I am trying to achieve. Will the above code assist with this?

Thnaks again for your help.

Regards

**xladept** · 12-05-2012, 05:20 PM

Hi macquhele,

I couldn't get it to work by clicking the Rectangle - although i think I've done it before. This version will run after you change the entry in H13! See if it will do for you:Biscuits().xlsm

**macquhele** · 12-05-2012, 06:28 PM

Hi there

This is great thank you. Very clever.

Regards

**xladept** · 12-05-2012, 07:12 PM

You're welcome!

Date parameter search function

LinkBack

Thread Tools

Rate This Thread

Display

Date parameter search function

Re: Date parameter search function

Re: Date parameter search function

Re: Date parameter search function

Re: Date parameter search function

Re: Date parameter search function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions