Hiding rows in table based on cell value

[dearsong]

I have a worksheet with all of our daily orders in Table2 (currently B5 to Z959). I want a command button that will hide all rows in Table2 that contain a date in column X (which is the order completed date) but not the rows where column X is empty. Then I want to switch the Command Button's caption to "Show All Rows" and unhide all rows next time it's clicked. Nothing I've tried has worked. My knowledge of VBA is too sporadic and I would appreciate any ideas. This is the first time I've posted anything anywhere so I hope I've given enough information.

[TMS]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.