Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Date Range Prompt Date Range Prompt
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 12-02-2011, 01:33 PM
MikeWooZ MikeWooZ is offline Date Range Prompt Windows 7 64bit Date Range Prompt Office 2007
Novice
Date Range Prompt 		 
Join Date: Dec 2011
Posts: 4
MikeWooZ is on a distinguished road
Default Date Range Prompt
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
Reply With Quote
  #2  
Old 12-03-2011, 02:35 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Date Range Prompt Windows XP Date Range Prompt Office 2003
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Hi

maybe it would help if you could post a sample of your data. Layout might be important
Reply With Quote
  #3  
Old 12-03-2011, 03:43 PM
MikeWooZ MikeWooZ is offline Date Range Prompt Windows 7 64bit Date Range Prompt Office 2007
Novice
Date Range Prompt 		 
Join Date: Dec 2011
Posts: 4
MikeWooZ is on a distinguished road
Default Sample Data
OK Pecoflyer, attached is my spreadsheet with the sample data. Please be the one!!!
Attached Files
File Type: xlsx From Date To Date.xlsx (15.3 KB, 11 views)
Reply With Quote
  #4  
Old 12-04-2011, 11:03 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Date Range Prompt Windows XP Date Range Prompt Office 2003
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Is the attached what you need ?
Attached Files
File Type: xlsx From Date To Date.xlsx (13.8 KB, 18 views)
Reply With Quote
  #5  
Old 12-04-2011, 12:18 PM
MikeWooZ MikeWooZ is offline Date Range Prompt Windows 7 64bit Date Range Prompt Office 2007
Novice
Date Range Prompt 		 
Join Date: Dec 2011
Posts: 4
MikeWooZ is on a distinguished road
Thumbs up Thanks a million
PecoFlyer, that is EXACTLY what I want. Thank you so very much!

I'm forever indebted to you
Reply With Quote
  #6  
Old 12-04-2011, 12:42 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Date Range Prompt Windows XP Date Range Prompt Office 2003
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,948
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
My pleasure.
I think you can marked the thread " solved" somehow, but I don't know how yet ( new to he forum)
Reply With Quote
  #7  
Old 12-04-2011, 02:10 PM
MikeWooZ MikeWooZ is offline Date Range Prompt Windows 7 64bit Date Range Prompt Office 2007
Novice
Date Range Prompt 		 
Join Date: Dec 2011
Posts: 4
MikeWooZ is on a distinguished road
Default Thanks again
Yes, I tried to find the "Solved" icon, but without luck.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Range Prompt Help with Document Properties Prompt Macro KJJ Word VBA 14 11-10-2016 08:18 PM
Date Range Prompt Suppress the Save prompt UTSUPPORT Word 1 01-16-2012 09:27 PM
Saving as PDF causes prompt for printable region out of range chrisxyz Word 0 02-22-2010 05:58 PM
new appointment date always reverts back to today's date msills Outlook 0 08-24-2007 08:57 AM
Date Range Prompt Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:05 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft