Hide Rows With Variable Text Based On Dropdown Selection

Jun 11, 2014

I have a spreadsheet which contains our fleet information covering many vehicles in one list. The teams for these vehicles are listed in Column A. What I would like to have is:

A dropdown box to pick from All, or the various teams in A1To hide every row that doesn't match the selection of A1To reveal every row that contains the selection for A1 at any point in column A. e.g: "*Dog Team*"

This is because something might be listed as "Moved from Dog Team" or "Dog Team, temporarily on loan", or "Dog Team V66.m"

I have taken a small sample of the data I will be working from and made a very simple drop down box which displays the pages of information for the vehicles by hiding/unhiding blocks of columns:

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$2" Then
If Range("A2") = "MOT/Service" Then
ActiveSheet.Columns("A:P").EntireColumn.Hidden = False
ActiveSheet.Columns("Q:CE").EntireColumn.Hidden = True
ElseIf Range("A2") = "Contact Details" Then

[Code]....

But because there is also filters on the sheet, meaning the positions of the entries based on rows can change, I need it to search for the "*xyzzy*" method, but am unsure how to do this! While just using the Filters will work, due to some human limitations I have been asked to have a specific drop down box in a very specific location with instructions next to it.

View 1 Replies


ADVERTISEMENT

Hide Rows Based On Dropdown Selection?

Jan 8, 2005

I have a shared worksheet that has many rows of data... but only certain rows are relevant to each specific users. I would like each user to be able to select their name from a drop-down list in order to have all rows that are not important to them be hidden. I can put the name of the user in column 'A' in each row they need to see, but how could I make all rows that do not contain their name in column 'A' hide? In other words, if 'Bill' is selected from a drop-down list, only rows that contain 'Bill' in column 'A' would be seen.

View 9 Replies View Related

How To Hide / Unhide Rows Based On Selection From Dropdown Box

Feb 1, 2013

I have a worksheet that allows you to choose 1-20... depending on the selection it should unhide specific rows but I keep getting errors...

Code that will allow you to unhide other worksheets in the same book????

View 1 Replies View Related

Hide Rows Based On Drop-Down Selection

Jan 8, 2005

I have a shared worksheet that has many rows of data... but only certain rows are relevant to each specific users. I would like each user to be able to select their name from a drop-down list in order to have all rows that are not important to them be hidden. I can put the name of the user in column 'A' in each row they need to see, but how could I make all rows that do not contain their name in column 'A' hide? In other words, if 'Bill' is selected from a drop-down list, only rows that contain 'Bill' in column 'A' would be seen.

View 9 Replies View Related

Hide Rows Based On Combobox Selection

Dec 16, 2006

I know there are a lot of hide row threads... i've searched for ages... but (unfortunately) i can't a solution that addresses my problem and I'm stuck. Please help!

I have a data between rows 10 and 1310 and I would like to use a combo box option to select and view certain rows of data only. I don't want to use auto filter because i have a separate macro using an auto filter on the same data - they won't play together.

So in short - combo box will contain values from column A. When value is selected from combo box hide all non matching rows based on column A values.

So i have added a combo box to sheet1 and populated it with the following workbook code...

Sub Workbook_Open()
With Sheets("Sheet1").ComboBox1
.AddItem "Select Product Type"
.AddItem "Apples"
.AddItem "Mangoes"
.AddItem "Oranges"
.AddItem "Clothes pegs"........

View 9 Replies View Related

Displaying Input Box Based On User Selection Of Dropdown Selection?

Jun 3, 2013

If a user selects certain options from a drop down list created by cell verification (from list), is it possible to display an input box and have the resulting input populate on another worksheet in the workbook? I have an attendance template I'm working with and if a user selects OT (Over Time) then a input box is displayed prompting for how many hours. The overtime is then tracked on another worksheet.

View 1 Replies View Related

Hide Rows Based On Text Search In Three Columns?

Mar 22, 2013

I am working on a time management sheet for my company. I need to be able to click a button and have the file search 3 columns for a persons initials and then hide all the rows where the initials are not in at least one of the three columns. I seem to have no problem getting it to work for one column at a time, but as soon as I try to search more than one it all falls apart.

I will also need to create an unhide all button to reset the sheet after the macro has been run.

I have attached a sample of the sheet below. Each project needs to have 3 rows to show the schedule and budget broken down by each team member.

Project Number
Address
Service
PM
SS

[Code]....

View 5 Replies View Related

Hide Rows From Dropdown

May 22, 2009

i have a sheet with three dashboards built in and want to dispay on certain data depending on what is selected in a drop down menu (E8)

All - All rows are unhidden
UKIRSA - Rows 133 to 192
Glasgow - Rows 72 to 92
Sykes - Rows 12 to 70
Header - Rows 1 to 11
Footer - Rows 193 onwards

I want the header and footer to remain the same but the middle body of the dashboard to change depending on the selected option ie only the rows for the option are displayed, eg if Sykes selected then Glasgow and UKIRSA ranges are hidden

This is the code i am trying but it is not working:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "E8" Then
Select Case UCase(Target.Value)
Case "Sykes": Rows("12:70").Hidden = False
Case "Sykes": Rows("72:192").Hidden = True

Case "Glasgow": Rows("12:70").Hidden = True
Case "Glasgow": Rows("72:132").Hidden = False

Case "UKIRSA": Rows("134:192").Hidden = False
Case "UKIRSA": Rows("12:132").Hidden = True

Case "All": Rows("12:192").Hidden = False
End Select
End If
End Sub

View 9 Replies View Related

Auto Fill The Rows After Particular Selection From Dropdown List?

Dec 16, 2012

auto fill the rows after selecting a particular option from a drop down list. For Ex., In Drop down list we have Cool drinks and Ice cream as two options. If i select Cool drinks the respective columns should be filled with brands like, Coke, 7 Up etc...

View 3 Replies View Related

VBA To Hide Rows Does Not Work With DropDown

Aug 21, 2014

Goal: Hide rows based on value in Drop Down Box

Problem: The code works fine if i manually change the $D$10. If I make changes to the Drop Down Box the cell link updates, but the rows are not hidden.

[Code] .....

View 6 Replies View Related

Display Userform Based On Dropdown Selection

Oct 5, 2013

I have created a User Form that has been tested and is working properly. Now my last step is to do the following:

I would like to Display the User Form (coded as CommRM) if in Column C (can be any cell as it is a large worksheet) someone selects "Retail News" from the drop down option.

The code that I have been able to create so far is below. The problem is that when I select Retail News from a drop down in Column C the user form does not appear.

VB:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range (C14, C3333).Text = "Retail News" Then Call UserForm_Initialize
End Sub
Private Sub UserForm_Initialize()
Load CommRM
CommRM.Show
End Sub

View 7 Replies View Related

Move Data To New Tab Based On Dropdown Selection

May 30, 2014

I have a excel file to keep track of sales pipeline. What I am looking for, is an automated utility or code that will allow excel to automatically move entire rows once a task is completed and can be moved to another sheet. In Prospects sheet I have a column for " Stage" and here you have to select from a drop down menu, either "Prospect", "Contacted" "quoted" "WON" "LOST" What I would like, is that once you have selected one of the sales stage, the entire row or entry, will be automatically moved to the right tab from the "prospects" to a new sheet according to each stage.

SalesPipeline.xlsx

View 2 Replies View Related

Auto-Populating Based On Dropdown Selection

Dec 4, 2013

I am trying to create a sheet for identifying work hazards based on the job assigned. So what I have set up is a drop down list to select the job type. Once this job type is selected I want the pre written hazards to autopopulate in the hazard box. I would also like the required PPE to appear in the PPE box for the job selected.

I have 6 different choices in the drop down list. For each choice I have the hazards and PPE in a separate sheets in the worksheet.

Is there a way to get this information to autopopulate?

View 1 Replies View Related

Changing Dates Based On Dropdown Selection?

Feb 12, 2014

I am trying to develop a worksheet that will adjust dates based on a selection from a drop down box. I can do basic formulas in excel

I am trying to get the drop down box in "Revisit Type" to include three selections ("Sanitation", "Spark", and "High Five"). Once the dropdown box is created I want to be able to make a selection and enter an initial visit date under "Initial Visit Date" then have the "Earliest Return Visit Date" and the "Latest Return Visit Date" automatically populated based on this information below:

Sanitation or Spark = 10-30 day window
High Five = 10-21 day window

I am at a loss . I have attached a sample of the workbook for reference.

View 3 Replies View Related

Formula Based On Dropdown Menu Selection?

Feb 21, 2014

Sheet 1 has a table of prices. There are 7 columns labelled 2 thru 8 and two rows, labelled 1 and 2. Each combo has a separate price.

Sheet 2 has a weight specification (1 or 2 referring to the rows in sheet 1) and a drop down menu with options 2 thru 8.

When I choose a number from the drop down menu, let's say 5, I want to populate another cell with the value from sheet 1 of column 5 on row "whatever the weight spec is", let's say 2.

View 1 Replies View Related

Display Information Based On Dropdown Selection?

May 21, 2014

I'm wondering how I could display information based on the user input through dropdown selection. I know how to make a dropdown-list already.

Example: A1 has a dropdownlist with Apple and Banana in it. If I select banana then I want B1 to display "8" and if I select Banana I want B1 to display "4".

View 5 Replies View Related

Changing Data Based On Dropdown Box Selection

Jan 28, 2013

Changing the data based on a drop down selection. My drop down list is based on the months I need the data (percentages for each person) to change depending on which month is chosen. So If I select Jan, the percentage fills in for each person. I've attached an example.

View 3 Replies View Related

Colored Cells Based On Dropdown Selection

May 23, 2013

I am trying to create a spreadsheet which allows me to select an antibiotic from a drop-down menu (refer to cell D1) on Sheet 1.jpg, which would then color the cells below based on the color-coded coverage based on another sheet (refer to D2-D17 of Sheet 2.jpg).

View 10 Replies View Related

Populating Drop-Down Based On Selection Of Another Dropdown

Sep 12, 2006

There's a table with all the raw data in it

camp name
session name

to put in the correct format I am thinking of usinf drop down boxes so that the user can selct the camp name from drop down and based on that the session name can be populated and alos the rest of infomration of that accput in to the specified fields

View 6 Replies View Related

Populate Cell Based On A Dropdown Selection Of Another

Jan 25, 2008

I found many examples on this forum of how one can pull in data from closed workbooks, or copy it and have it stored in the active sheet. So far so good, but I need a solution which would do the opposite - I need the macro to take a range of data form the active sheet store it in a closed workbook and save any changes in the target workbook without opening it.

View 2 Replies View Related

Update Cells Based On A Dropdown Selection

Jun 17, 2008

I am trying to use a row of cells as update cells, where the user inputs an amount into greyed out cells, which in turn updates Sheet1!$I$2:$I$11, from which it will update other worksheets that are currently in progress. but I do not know how to go about it. Is it possible?

For each amount the user enters (for each Code Number) a date will be displayed below the amount.

View 9 Replies View Related

Hide Columns Based On Selection

Aug 30, 2008

I have a worksheet that lists the months of the year on row 3 from columns C through N.
What I am trying to do is to be able to select the month I want from a drop down list or combobox and then hide the remaining columns based on the selection. For example if JAN is selected the months FEB through to DEC would be hidden.

View 9 Replies View Related

Change Color Of Cell Based On Dropdown Selection

Dec 14, 2012

I have a dynamic drop down list using OFFSET and want to change a selection of cell colors based on the drop down selection. My drop down list is located in cell G4 and the cells I want to change are

=$C$9,$C$10,$C$11,$B$11,$B$12,$C$12,$B$13,$C$13,$C$14,$C$15,$H$15,$H$14,$H$13.

These are random cells. There is no value in the cells, I just want to change the color from green to gray.

View 3 Replies View Related

Auto-Populate Field Based On Dropdown Box Selection?

Jan 20, 2013

I have a dropdown list selection on the form for types of machines. The list of machines, their sizes and related noise level are in a chart on worksheet 2 and I'd like to automate the form so that when the machine is selected, the related noise level auto populates.

The dropdown box has been put in the form using the data validation function.

View 7 Replies View Related

How To Copy Table From One Sheet To Another Based On Dropdown Selection

Jan 16, 2014

Need achieving the following:

I have 2 sheets in one workbook, the first sheet named D1 where I have dropdown menus and the second sheet called reference where I have fixed data

what im looking for is when the user select an option from the dropdown menu on cell b3 on "D1" sheet based on the selection an entire table (4 rows by 3 columns) called "Default" from reference sheet to be automatically pasted into the D1 sheet.

View 1 Replies View Related

VBA Copy / Paste Cells Based On Dropdown Selection?

Apr 22, 2013

I have two sheets that I am using. sheet 2 has a list of experiments in column C with information regarding the experiment in columns F - J. On sheet 1 I have a dropdown box with a list of all the experiments. When I select an experiment from the dropdown box I would like to populate columns K - O on sheet 1 with the information from columns F - J for the selected experiment on sheet 2.

View 9 Replies View Related

Combine Rows With Similar Info In Dropdown Menu Or Selection For User

Nov 29, 2012

I have a spreadsheet that has a long list of charges... some of those charges have multiple codes attached to them... when this happens I am wanting to group them together and let the user pick which one they want to view at one time.

Here is a very small example of what exactly I am referring to... with charge #14 I am wanting it to combine and let the user pick between 2565 and 2566. The problem is that the values can range and will not always be 2565 & 2566 and there is 10,000 + records similar to this.

test.xlsx

View 1 Replies View Related

Automatically Color Worksheet Tab Based On Dropdown List Selection

Nov 21, 2012

I am new to VB macros, I am trying to figure out how to color a tab Green based on a selection from a drop down list.

View 9 Replies View Related

Insert Date Stamp Based On Dropdown Menus Selection

Aug 11, 2014

The worksheet is basically a sales funnel and I want to use a drop down menu selection in ever row of column Z to update the relevant cell, based on the selection, in the same row, column Q to Y, with a date stamp which will then not change as the drop down is progressively changed to suit the relevant stage of the job.

View 2 Replies View Related

Populate Master Sheet Based On Dropdown Selection That Selects Other?

May 2, 2014

For example, I have a master sheet that has a drop-down list of the months January and February, which have their own sheets. I am trying to populate the sales of the week 1, 2 ,3 ,4 in the master sheet based on the same data for the month chosen.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved