By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,651 Members | 1,757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,651 IT Pros & Developers. It's quick & easy.

VB Command button return total count from another worksheet

P: 6
Help. I am using Excel to enter in daily numbers in worksheet 2. I want to use vb (w/in excel) to create a command button in worksheet 1. I want to enter a date in a cell and click the command button. I then want to use the date i entered into the cell to sum the total of numbers from worksheet 2 by filtering the numbers by the date.
I want to enter 7/15/2007. I want to return the total count of all "Reg" jobs somewhere on worksheet 1

Example of data on worksheet 2.
Date Job Count
07/15/2007 Reg 1415
07/12/2007 Sat 913
07/11/2007 Reg 115
07/15/2007 Reg 413
07/15/2007 Din 215
07/15/2007 Reg 831
Sep 20 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 2,364
This looks promising:

You may need to read a bit to get an idea what's happening...

Good luck and please stay tuned if added ino needed!
Sep 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.