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