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, 11 views)

Is the attached what you need ?

Attached Files

From Date To Date.xlsx (13.8 KB, 18 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.