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...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.