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 "A". I also have a macro set up on sheet "B" to sort the data by date in ascending order. I am a noob to Macro and I remeber some stuff from college but no much. Can you please help??!!
The code I cuurently have in to sort by date is:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
Range(A").Sort Key:=Range("A2"),_
Order1:x1Ascending, Header:=x1Yes, _
OrderCustom:=1, MatchCase:=False
Orientation:=x1TopToBottom
End Sub
P.S. Im using MS Excel 2010
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 "A". I also have a macro set up on sheet "B" to sort the data by date in ascending order. I am a noob to Macro and I remeber some stuff from college but no much. Can you please help??!!
The code I cuurently have in to sort by date is:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
Range(A").Sort Key:=Range("A2"),_
Order1:x1Ascending, Header:=x1Yes, _
OrderCustom:=1, MatchCase:=False
Orientation:=x1TopToBottom
End Sub
P.S. Im using MS Excel 2010
