VB Command button return total count from another worksheet

[crystalgal]

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

[Dököll]

This looks promising: http://www.scribd.com/doc/267102/5-t...heets-in-Excel

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

Good luck and please stay tuned if added ino needed!