Good afternoon everyone! I haven't been able to find a reasonable answer to my current dilema (hit and miss, but not exact)...



I have data on sheet 1 and on sheet 2, I have what I'm calling a form that I use to present to my supervisor. Right now, For each of the 5 categories of data, I use the countif function to report how many instances of "widget a" are represented in column A during a particular date range in column B. Now, to do this every week, although not to awfully time consuming, is slightly frustrating.

What I want to do is provide the user with a FROM and TO prompt for the range of days. Then, after the user either tabs out of the FROM field or selects a SUBMIT button, I want the data to populate each of the five fields... of course automatically.

I hope that I've been clear on what I want, and if not, I am certainly willing to elaborate more.

Thanks ahead of time for any assistance!!!

Mike