hides

Hi Lads, I have macro below which hides all rows and leaves all rows with text ''APPLE'' in F column on Sheet2, it works ok, but the problem is that in this table all cells are referrencing to different sheet i.e. ='Sheet1'!A1 which means Marco hides all rows not containing APPLE and all the...

Can anyone come up with formula that hides certain rows based on a column value?

My macro hides all rows that have the number 3 in the first column. I would like to make it so that it hides rows that have 3,4 or 5. How would I do that here? Sub HideMaddie() BeginRow = 4 EndRow = 141 ChkCol = 1 For RowCnt =BeginRow To EndRow IfCells(RowCnt...

<tbody> A B C D E F G H JAN FEB MAR APR ACT FCST BUDGET BUDGET X X </tbody> Hi All, I have question. I have a range of columns above. Each month uses two columns (Jan uses both columns A&B ex) How do I code the above to show only the columns...

Can excel be used to randomize a secret Santa draw? It needs to have functionality that it randomises a name and wither emails that person or puts onto a tab or hides the name from everyone else.. maybe only access with a password so the host doesn't see who has who either?

Hi, Curious if there is a way to hide or delete a row based on criteria? So if O3 says "Presented", then the whole row (3) either hides, deletes, or maybe moves to another tab. Is this possible? Thx

Hello, I have an excel file in which , cell G23 ( remaining dept fot year 2018 ) equals cell AJ22 ( unpaid depts Year 2019 ). What i need is a formula that hides the value in cell G23 if its not 2019 yet. Thanks in advance. Younan

Wondering if I could get some help. I currently have the following code in VBA, the code works well but it hides all rows with anything that is blank. I'm using this with a search box and the column has around 3000 lines. Thanks Private Sub TextBox1_Change() ActiveSheet.Unprotect...

Hi guys I am trying to make a sheet unhide the row below when someone inputs a value in a certain cell. and if they delete that value the same row will got back to hidden. I have this code which hides the row but how to I make it hide the row if the value in the cell is deleted. Public Sub...