Macro to Hide Certain Rows with the Click of a Button, and other Rows with the Click of Another Button?

[duusomething]

Hello,

I have a spreadsheet that is broken into costs for Canada and for the US. I don't know much about Macros, but am hoping to use a macro to hide all the rows that relate to an American cost when you click a button that might say "Canada" for example. And I'm hoping to have another button that you can click which will hide all the rows for the Canadian costs when you click a button that might say "US". I'm hoping to do this so that when people look at the tab they can see the costs for both countries, the cost just for Canada or the cost just for US.

The Canadian data is in rows: 8-27, 48-59 and 74-87
The American data is in rows: 29-46, 61-72, and 89-102

I'm using Windows 7, with excel 2010.

Thanks in advance

 

[Andrew Poulsom]

The macro recorder should get you started.