hide/unhide row

Hi All, Can someone please help me to hide/ unhide rows on another sheet based on Text Value? For example, if 'Purchase Order' is enabled using a checkbox or a button, then rows containing 'Purchase Order' in a specific column, in this case Column D, will be shown. Note: I am trying to make...

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...

Hello, This is a long post, if you are too lazy, here is the issue. Need to make automatic changes to cells that will activate a "Run when Values Change Macro" without going into a loop forever. Getting "The object invoked has disconnected from...." when I've tried to link it I've got a job...

Hello All, I am working on a spreadsheet "B" in excel and I need to be able to hide/ unhide rows that dont have a value in them.( The rows are linked to another sheet "A" in the workbook) I would like to be able to have the rows in sheet "B"unhide when I enter information into my table on sheet...

I have this macro that adjust lines accordingly to the # chosen in the drop down box (using data validation). Private Sub Worksheet_Change(ByVal Target As Range) Dim r As Long If Not Intersect(Target, Range("d1")) Is Nothing Then Range("A10:A1793").EntireRow.Hidden = True r...