hide / unhide rows

So, I currently have a checkbox that hides rows based on if the cell has data. I want to be able to now have a button (inserted Shape) to copy cells L2:P40 but remove rows that cells M4:M38 do not have any data. I want to copy this out to the clipboard as a grid with all the formatting Here...

Good Day to you all, Newbie here, looking for some advice 😊. I have a spreadsheet linked here (hope it works) Its my works training record for different areas. I could split it down to different positions but I'm sure there's a way to keep it all together. I have browsed through to see if i...

Hi All I'm a novice and looking for help to fix and resolve this. I thought it would be straight forward but I've been going around in circles to get it to work. I have sheet1 with check boxes (across columns) that informs sheet2 rows if they are checked (True) or un-checked (False). On sheet2...

Hi All, I'm a total novice when it comes to VBA and i have been watching a number of tutorials but cant quite get the scripted i need to make my spreadsheet work. I have a dropped down in cell D16 with various text (all, essential, desirable, mandatory, general) I have a corresponding table...

Hi, I have a sheet in my workbook that compiles info from 4 other sheets using formulas to call up cells from other sheets, for example: ='STEAM (SH)'!D3 . this leaves me with rows that have info in every column or just one column at times. I want to be able to quickly hide the rows that have...

For this example we have 3 agents (Agent 1, Agent 2, Agent 3) listed drop-down menu. When their name is selected from the drop-down the monthly table (the green one) will auto populate their info. Below this there are 3 additional tables: One for each Agent showing their stats month by month. I...

Hi everyone I hope, that some of you are able to help me. I have a large excel sheet with a lot of rows. I column "F" I have the status stated. It can be open, closed or blank. I would like to have a checkbox that hides every row with the status of "Closed". I have tried this, but that won't...

Hello, I have a report that produces a spreadsheet where column B has last names and column C has first names. There are many tabs like this and that number of tabs may vary. On a new tab named "Name Filter" I have set up Column A for Last names and a Column B for First names. What I want to...

Hi All I am trying to work on a vba code to hide rows if 2 or more criteria have been met. If Cell1 contains "Govt Agencies & Stat Board" and Cell2 contains "Yes", I would need to hide rows 5 rows If Cell1 contains "Govt Agencies & Stat Board" and Cell2 contains "No", I would need to hide rows...

Hello all, Very new to VBA so bear with me - the attached picture is what I have so far and does hide rows 40 -42. I would like to hide multiple groups of rows with the same button and have tried the following with no success: xAddress = "40:42, 44:46, 48:50" xAddress = "40:42", "44:46" ...

Hi Guys, I am trying to do something rather simple but I am not sure how to do this. So basically I just want the workbook to only show the week number that I select from the dropdown list and the rest should be hidden. Attached is a screenshot for better understanding. Dropdown is in C2 and...

Hello every One . I hope To help me To reverse this Code This code Hide From Row 8 to Row 20 . I want to Start Hide form row20- row8 Thx Sub test2() Dim startRow As Long: startRow = 8 Dim lastRow As Long: lastRow = 20 Do While startRow < lastRow + 1 If ActiveSheet.Rows(startRow &...

Dear VBA Masters I want below code to check range and If any row contains value FALSE then EntireRow.Hidden = False , else I want rest of rows to be hidden. Seems simple but it does not work the way I want. Below code shows only 2 rows from below example. Why ? Sub ShowFalseOnly() Dim...

Hi all, I'll be the first to admit I'm quite new to VBA, but delving into it as much as I can. I've been building a questionnaire & want to be able to hide certain rows based on a certain value of a cell. I have managed this successfully on one sheet within my workbook, however when I copy...

Hello, I wanted to hide specific rows in multiple sheets. I've sheet "Info" which have dropdown list (View,Hidden). I also have sheets "Jan" to "Dec" When i choose dropdown list "Hidden" in sheet "Info". It should hide all the specific rows (Example rows 1:10) in all sheets "Jan" to "Dec". I...

Hi All, I am trying to use a code that allows me to hide/unhide x number of rows based on another cell value. I also need this to update automatically when the cell value changes. So for example if cell A1 is =1, I want it to show row 5 and hide rows 6-10, when the cell value changes to 2, I...

Hi all, I am trying to create an Excel that allows me to hide/unhide rows based on cell data based on a formula. It works the first time but then when the data changes it does not unhide/hide the previous data unless I go to the code and refresh after the new data has been selected. I have...

Hi, I would like a page within my macro enabled workbook to automatically hide and unhide rows based on the cell reference within column C of each row. Page Name "Pilot Log" Possible text references within column C would be "MA" "SA" "P3" "P4" "P5" The rows I would like to hide / unhide...

I have a working code, but it doesn't hide until i Run the code from VB Editor : Maybe those D3,D4 and D5 are formulated , that's why it is not running on its own : The above code isto run the formula in cells in CheckList sheet so that they take in values from the drop down list. This code...

Hi there, I have a set of data which can change via formulas. To reduce the amount information the user is looking at, I wanted to hide the rows with a zero balance. I went to test the below VBA code but it was taking so long, I had to stop it. As you can see, there's over 4,000 rows. Since...