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

Hi

maybe it would help if you could post a sample of your data. Layout might be important

OK Pecoflyer, attached is my spreadsheet with the sample data. Please be the one!!!

Attached Files

From Date To Date.xlsx (15.3 KB, 9 views)

Is the attached what you need ?

Attached Files

From Date To Date.xlsx (13.8 KB, 16 views)

PecoFlyer, that is EXACTLY what I want. Thank you so very much!

I'm forever indebted to you

My pleasure.
I think you can marked the thread " solved" somehow, but I don't know how yet ( new to he forum)

Yes, I tried to find the "Solved" icon, but without luck.