Want to see only the row data for today's date

I want to create a macro that when I click on the 'Today's Calls' button that I already created, will ONLY display the rows of data that have today's date entered in the cell.

E.g.
Name Phone Product Cost Next Contact Date
John 555-555-5555 Excel $100 4/25/2013

Thank you,
Jakub

In what column is today's date?

How did you do that Mumps1??? It worked just fine. How can one learn the coding methodology for macros? Most of what you wrote is like a foreign language to me.

Thank you

Hi Jakub. I'm glad it worked out for you. Everything that I know about VBA, I learned on-line. Forums are a great source of help and information. I have found that by doing searches, I can find pretty much what I need and by putting it into practice and doing some tweaking, I can get it to work. Just to give you an example to go along with your case, if you searched for "hide rows excel vba", I'm pretty sure that you would have found a solution. There are also many on-line tutorials that are of great help. Good luck with it!

Hey Mumps1,

Thanks for the "tutorial" Now I'm faced with 2 issues with this Macro. Issue #1 is, how do I then unhide all the rows that do not have today's date. I thought that by clicking again on the Macro, it would bring me back to seeing all of the rows (bad assumption, I know). Issue #2, when I do click on the macro it hides the name of the columns (i.e. Name, phone number, product, price, next contact date, etc.).

I hope I didn't stump you

Thanks,
Jakub

Hi Jakub. Have a look at the attached file. Is this what you were looking for?

Hi again Mumps1,

Thanks for spending your free time to show me how to do all of this. The spreadsheet you sent me did leave the heading columns visible (congrats) this time but if I click it again, it does not return back to all the data being visible again. Could you try again? I also want to name the button 'Today's Calls' instead of 'Hide' for example (this should be easy enough for me to do on my own but it didn't work when I tried it). Lastly, could you create another button called 'Todays and Unmade Calls' that will show me today's calls and any other calls with a prior date (i.e. 5/8 but also 5/3, 4/29, etc.).

This is the last request I promise!

Sincerely,
Jakub M.

Hi Jakub. Try the attached file. I've taken a slightly different approach. Let me know how it works out.

By golly, it worked! Thanks Mumps1! I gotta learn this stuff

It was my pleasure.