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


ADVERTISEMENT

Dropdown List In Spreadsheet Which Combine Info From Two Columns

Oct 24, 2012

I'm trying to have a drop down list in a spreadsheet which combines the info from two columns.

For example:

A B
1 John 29
2 Sandy 40, etc

And the drop down list turns into

John 29
Sandy 40

Is this possible?

View 1 Replies View Related

Dropdown Menu Selection

May 1, 2013

How to create a dropdown menu to pick from two selections?

Basically, I have a 'Status' column and the status will always be 'Open' or 'Closed' and I'd like you just to be able to click a cell in that column and select one or the other.

View 2 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

Use VLOOKUP From Dropdown Menu Selection

Feb 27, 2007

I have a spreadsheet which is made up of 4 worksheets. I have a drop down menu on the front page (created with data validation). I want to be able to choose one of the 7 geographical areas from the drop down menu, then have a formula search through the other worksheets for rows of data with this geographical area in it. Any ideas on how to do this, I have tried with VLOOKUP but cannot get the formula to refer to the drop down menu for the first input, i.e. the geographical area that it should be looking to match.

View 5 Replies View Related

If Function To Test Dropdown Menu Selection?

Jun 11, 2014

I am developing a spreadsheet at work that is very similar to one that I made at a previous job. I am using the same formula in each spread sheet, but the one I am developing now does not work, where the previous one works perfectly.

I have a drop down menu created with data validation. Each possible selection is one or two letters of text, or the selection can be left blank. The drop down is cell A12, and an example of the if function that is used many times in this spreadsheet is as follows:

=IF($A$12="L",1,0)

In the previous spreadsheet, the function returns true only when the appropriate selection is made. In the latest version, it will return true if the appropriate selection is made, or if drop down selection is blank. I have been able to work around this with the following:

=IF($A$12="",0,IF($A$12="L",1,0))

View 6 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

Change Button Function Based On Dropdown Menu Selection?

Jun 9, 2014

I've got a drop-down menu with four options in it that match up with the cells D11:D14, and next to those I've got spots for counting the totals (E11:E14). Next to the drop-down I've got plus and minus buttons, and I need to make it so if I have the top option selected in the dropdown and press plus, it adds +1 to E11. Second option and the same plus button, +1 to E12, and so on.

The purpose is for a call tracker, the employee would select the reason for the call (maybe more added later) and hit the button to add the call to the report.

I've looked so I know you normally ask for what I've got so far, and that's nothing. I've got all the other buttons wired up but I don't even know where to start with this one. I can include a screenshot if necessary.

View 5 Replies View Related

Excel 2003 :: Limiting Dropdown List Based On User Selection

Jun 27, 2014

I would like to be able to limit a drop down list's contents based on a user's selection in a different drop down. I am using Excel 2003, and I know how to do this in Access, but I can't figure it out in Excel. Basically, I have a list of themes in one drop down. The user picks a theme, and goes to a second drop down which is a list of sub-themes attributable to that one theme and no other theme.

View 1 Replies View Related

Adding Rows To Dropdown Menu

Nov 28, 2011

I created a Validation list from 2 to 20. I want to have it (the list) add a row every time you select the proper data.

Example: If I want to add 2 row I would select the 2 in the drop down menu. If I need 5 rows I need to select 5 from the drop down menu.

Is this a VBA code? Or can I use a formula?

View 5 Replies View Related

Copy / Paste From Cell In One Sheet To A Cell In Another Dependent On Selection Of Dropdown Menu

May 31, 2012

I have a workbook with two sheets. The idea behind the workbook is an Interview Guide to be used just before an Interview. For now my problem is this.

Sheet 2 "Competencies" is just data. It stores competencies with their associated definitions and questions.

Sheet 1 "Control Page" is the sheet where the questions will eventually go. The user (Interviewer) will input data on the first two pages which will include name of candidate, date of interview etc. but they will also select 5 Competencies from the already existing drop down menus on page two. From there as the selections are made I wish for a code to copy the corresponding definition on sheet 'Competencies" to cells lower down in sheet "Control page".

I don't see a place to upload a file as I have a sample of the sheet ready to go.

View 2 Replies View Related

Blank Rows From Merged Cells In Dropdown Menu

Feb 20, 2006

Merge a cell to the cell below it. Now merge the cell below the merged cell to the cell below it. Make one more merged cell. Now put text in each one like this "excel", "hates", "me". Now click on a different cell somewhere else on the page and go to menu Data --> Validation. Choose "List" and then in the source click the little button to the right and then highlight your three cells. Now you have a drop down menu in the somewhere else cell.

But when you go to the dropdown menu it has blank spaces in between the entries (because of the merged rows). If you do the same thing but the list is with cells that are not merged to the rows below then it doesn't have the blank rows. If you are only dealing with cells that are merged in twos it is okay because it is spaced all pretty and everything. The problem is when the cells are not merged evenly so everything looks uneven.

how to get rid of the apparent blank entries in the drop down menu?

View 2 Replies View Related

Move Rows To Another Sheet When Value Is Chosen From Dropdown Menu In Cell

Nov 25, 2013

i am making a simple complaint tracking system and there is a column where there are two choices Resolved and Unresolved if you choose resolved it copies the row to the resolved sheet and if it's unresolved it copies the row to the unresolved sheet. i attached a template to give you an idea, i want the first complaint to be copied to the resolved sheet and second one to the unresloved sheet, i don't want the status column which contains the choices to be copied to the other sheets, also the unresolved sheet doesn't have a 'date closed' column because the complaint is not yet resolved so i dont want it to be copied there, i want it only in the resolved sheet.

[URL]

View 1 Replies View Related

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

Combine Two Tables Which Change In Rows Depending On Input Of User Using VBA In Excel?

Apr 13, 2014

i have a macro which takes the results generated and puts them into a table and filters the data so that zeros does not show and arranges the table from largest to smallest. Now i have a problem where i need to select the power, fuel oil consumption, weight and area from one table and the other power, fuel oil consumption, weight and area from the other table and combine them together so that i can have all possible combinations of the data, but i don't want the zeros to show in the combinations. i need the combined data to show on a separate sheet. The data of table 1 varies with rows as shown:

The Data of Table 2 varies with rows as shown:

I would like to achieve a result like this in the following columns and rows without having to input them manually:

View 1 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

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

Drop Down Menu: Add Another Selection To The Menu List

Oct 18, 2008

I have a column with various drop down menu boxes and I need to add another selection to the menu list. My problem is, it's been so long since I did the drop downs, I have forgotten how to do it..

View 3 Replies View Related

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 View Related

How To Combine Cells With Similar Value

Jan 11, 2012

How to combine cells with a similar value inside them into a single cell. Here is what my data looks like.

10'X14'{&}SNM8981-1014{&}16
2'6"X10'{&}SNM8981-2610{&}9
4'X6'{&}SNM8981-46{&}6

[Code]....

For example, I need to have every cell with SNM9012 to combine into the same cell. If I could figure this out it would save me hours vs pasting the similar lines into textmate and removing the enters.

View 1 Replies View Related

Finding Duplicate And Or Similar Info Across Columns And Highlight (names And Addresses)

Jan 29, 2014

Magazine subscription list. How to highlight the customers that are already in the sheet if enter them again (renewal). Our list is like so....

ColA ColB ColC ColD ColE ColF
First Last 123 Ave City State Zip

Is there a way to highlight the row if the info on ColA, ColB, ColE, and ColF all match? Sometimes the Street info is abbreviated or entered PO Box instread of P.O. Box and they wind up on the list a second time.

View 5 Replies View Related

Combine Similar Products And Put Into Correct Columns

Jun 21, 2007

Try this on for size...

On the MSP sheet is a list of products with a weeknumber and quantity.

I need to combine products that match in the same week and add their quantities.

Then I need to put the quantities into the VOLUME worksheet.

Any products that arent listed need to be added on the bottom.

View 14 Replies View Related

Add To Dropdown Validation List Or Similar?

Jan 29, 2012

Is it possible to part fill a cell with some prepared text from a list or similar, but still allow the user to finish off the sentence?

Using a drop down list in A2, I want to have a drop down list in B2 so the user can select from that list, (B2 list is specific to A2 drop down list)

I want the user to be able to add to that selected entry when they have picked it from the list in B2

IE: from the drop down list in B2 = "To be or not ......" I want the user to be able to finish the quote

View 2 Replies View Related

Combine Workbook Info All Into One Sheet??

Jun 16, 2006

I have 3 commission workbooks all with about 20-30 worksheets in them with each one listing the sales rep and a history of commissions owed/paid. I want to create a single workbook/worksheet where I have listed all the sales rep and the amount of commission they are currently owed without have to copy/paste or type it all in one at a time. How would I go about this??

View 8 Replies View Related

Excel 2007 :: How To Combine Info From Columns Into 1 List

Oct 4, 2011

is there a way to combine the info from several columns into 1 list?

All of my columns have information in rows 1-20, but I want it all to automatically combine into a list in column B on a new sheet.

This is Excel 2007

View 9 Replies View Related

Automatically Run Through Dropdown Menu?

Jul 7, 2014

I've got a workbook with multiple worksheets related to several subsidiary companies for each state & territory, resulting in 450+ worksheets in the workbook. I created a summary sheet with a dropdown menu for each state/territory that pulls in the relevant data using "=indirect". For example, selecting CA from the dropdown menu populates the combined revenue, expenses, etc., for all subsidiaries in CA. However, I've got 50 states plus some territories. I'd like the revenue, expenses, etc. for every dropdown option. Ideally, a separate sheet (or whatever) that lists all 50 states and the revenue, expenses, etc., for each one below (or across).

Is there any way to do this automatically so I don't have to select every single option and copy and paste the numbers into a different worksheet?

View 1 Replies View Related

Visible Dropdown Menu

May 5, 2014

How can I write my code so that the drop down box always is visible ( like a combobox)? This code is correct and makes a drop-down list but I want it visible at all the time.

[Code] ....

View 10 Replies View Related

How To Create Dropdown Menu

Feb 12, 2013

i looking for a drop down menu ..! like year , month so that no change that area

View 2 Replies View Related

Addition/Subtraction With Menu Selection

Jan 8, 2009

Included is an example of a spreadsheet I am working on. There are multiple choices within several different drop-down menu's. As of right now I have the 1st menu as the stage of completion of a car. Within the next few menu's are options.

If welded chassis is chosen, none of these options are included. However if roller or turn-key are chosen then some of these options are included. But then there are also upgrades to these parts that are included as well. Is there a way to make 1 option included when a roller is chosen, but then if you want the 2nd option in the menu, you click on it and it automatically updates the price next to it, therefore subtracting the cost of option 1 from the cost of option 2?

View 2 Replies View Related

Dropdown List Created From 2 Columns Of Info?

Mar 24, 2014

I have a list of names in column B, I can easily put this into a list

I also have a different list of names in Column C

These two list are feeding from sharepoint and are updated regularly

What I want to do is create a drop down list that will list all the names in Column B and Column C, while keeping the initial lists in there separate columns

I have been trying to find a formula to lookup both columns and return all the names into another column (E) using the formula below

=IFERROR(INDEX($B$2:$C$600,MOD(ROWS(E$2:E2)-1,ROWS($B$2:$C$600))+1,INT((ROWS(E$2:E2)-1)/ROWS($B$2:$C$600))+1),"")

the plan been to just put column E into my drop down list, but this formula is returning alot of blanks between Column B + C in the list (there might be 100 names in column B and only 30 in column C)

To try remove the blanks I tried another formula pulling the info into Column F,

=IFERROR(INDEX($E$2:$E$5000,AGGREGATE(15,6,(ROW($E$2:$E$5000)-ROW($E$2)+1)/($E$2:$E$5000<>""),ROWS(F$2:F2))),"")

But while this did remove the blanks (about 500 blanks) it left me with about 70 "0" errors.

View 3 Replies View Related







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