Excluding Selections: Added To The 20 Items And Not To The 3 Items
If i select 3 items from a list 20 items to be show on the cube this is fine and works however if i then add another item to the list i now have 21 items and for some reason it also adds itself to my 3 selected items to become 4 items. Is there anyway I can get it to be added to the 20 items and not to the 3 items..
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Excluding Specific Items When Dragging Down
Im using the following formula to update our prices in our stock list. =VLOOKUP(C1,'Most Recent Prices 2009'!A:G,6,0) Column C = Unique part number. Problem: I have a tab of 100 or so prices that I don't want to be updated. How can I exclude these pieces of equipment when I drag down the above formula. Assume that these pieces of equipment are in a tab called 'keep' and their unique part numbers are in Column A.
View Replies!
View Related
Allow Items To Be Added To "cell" Shortcut Menu
I am using the following code to add an item to the right click " cell" shortcut menu. I placed it in a Worksheet_Activate module in ThisWorkbook. I'm pretty sure the code is correct but it seems something is preventing the code from executing properly because no item is added to the menu. Is there some setting in a workbook that might prevent changes to the right click menu from being made? How can I get this code to execute properly? 'Set NewItem = CommandBars("Cell").Controls.Add 'With NewItem ' .Caption = "MACRO1" ' .OnAction = "MACRO1" ' .BeginGroup = True 'End With
View Replies!
View Related
Sum Up The Same Items
I have an Excel spread sheet as shown below. Sometimes, there are two rows (could be more )with the same items-for example, such as Inventories, but different values. How can I sum those rows with the same items and put it in a different column, and in the same time also copy over the single item to the same column? ....
View Replies!
View Related
Calculated Items
I have a pivot table with a calculated item. The problem is that it shows data for all rows EVEN when there is no data there. So the pivot table is a lot longer that it needs to be. How do I get the pivot table to show only rows with data in it? Also, all of the fields DO NOT have checks beside "Show Items With No Data".
View Replies!
View Related
Matching Items
getting correct formula and normally there are people much smarter then I in the discussion group. What I have is a workbook with 4 worksheets and on on of the worksheets I have a layout like this. (sheet 1) A B C 1 Name Origin Driver # 2 Mrs Soandso 125 anywhere 3 Mr. Someone 327 anywhere Drver numbers are blank On another worksheet(sheet 3) I have a list of subscriptions (I.e drivers numbers already filled in) I have this set up as a list. A B C 1 Name Origin Driver # 2 Mrs Soandso 125 anywhere 37 3 Mr. Someone 327 anywhere 39 What I am looking for is a way to pull the drivers numbers from sheet3 into sheet1. so basically in sheet 1 if a1 and b1 match the name + origin in sheet 3 it will pull the driver number from that row into c1 sheet1 . If nothing matches then it should leave it blank. The data in sheet 1 changes everyday for me as I get a manifest on who to deliver wheels on wheels to, my problem is while I know all the correct drivers go to what people, I can never have a day off as someone filling in for me has to go through 400 addresses and look each one up and put coresponding drivers number into it.
View Replies!
View Related
Adding Items To Combobox
In my excel sheet, from B2 to B20 i have datas like, aaa bbb ccc aaa ccc ddd rrr ttt bbb rrr ttt I want to add this to my combobox1 with out repeation as, 'aaa' should be listed in combobox once. What is the macro for this or we can do it in Combobox properties itself?
View Replies!
View Related
Sum 1 Or More Items In A Cell
I have a monthly calendar on each sheet for employees, attached is a copy of one of the sheets. I can have up to 2 combinations of text in a cell, i.e., 'V' or 'T' in this example, followed by a number, that can range from 1-12, i.e., V12T4. What I am trying to do is add up the total 'T' and 'V' time for the month for each employee. Hopefully between what I have written and my attached sheet, will explain what I am trying to do. I know how to write the =Sum(If for using only 1 item in a cell, but not 2.
View Replies!
View Related
Sumif With Multiple Items
I am using a sumif formula where if column b is a certain number then it will add up the value in column e. This works fine, however now I wish to add another filter, which is only for it to add the values in column E if the value is b is correct (as above) and also if column c has a value of 100.
View Replies!
View Related
Deselect Items In Listbox
I can't seem to get my listbox to deselect an item. When the user clicks on a day of the week in the listbox, they are given a yes/no option to print the sheets for the day selected. If they select no and change their mind, they cannot click on the same day of the week without first cancelling the listbox and re-opening it. Private Sub UserForm_Initialize() Dim myarray As Variant myarray = Split("Monday|Tuesday|Wednesday|Thursday|Friday|Saturday|Sunday", "|") ListBox1.List = myarray End Sub Private Sub ListBox1_Click() Call PrintRoutine(ListBox1.Value) End Sub....................
View Replies!
View Related
Copy Unique Items
How to make it copy over A, B, and C not just A and B? I tried adjusting some of the ranges, but I get a Run time Error 104. Also, what is the (Rows.Count, 3) doing? Sub CopyUnique() Dim LR&, LR2& Application.ScreenUpdating = False With Sheets("AY") .Range("A1:B1").EntireColumn.Insert LR& = .Cells(Rows.Count, 3).End(xlUp).Row .Range("C1:D" & LR&).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("A1:B" & LR&), Unique:=True LR2& = .Cells(Rows.Count, 1).End(xlUp).Row .Range("A1:B" & LR2&).Copy Sheets("ORG").Range("A1") Sheets("ORG").Columns("B:B").Columns.AutoFit .Columns("A:B").Delete Shift:=xlToLeft Application.CutCopyMode = False End With Application.ScreenUpdating = True End Sub
View Replies!
View Related
Formula To Match 2 Items
I want to match let's say "Elbow" with "Yes" so that when I select the word "Elbow" from a list the word "No" appears on another cell. There are 54 words to match. This is what I'm currently using, however, I could only get to 29 items and I need to match 54. =CHOOSE(MATCH($J$2:$J$100,{"Abdomen","Acetabulum","Acromioclavicular Joint","Ankle","Arm","Back","Carpus","Cervical","Chest","Clavicle","Coccyx","Elbow Joint","Femur Bone","Fibula","Fingers","Foot","Forearm","Glenohumeral Joints","Hand","Head","Hip","Humerus","Ilium","Ischium"," Joint","Leg","Lower Leg","Lumbar","Metacarpus","Metatarsus","Neck","Patella","Pelvis","Pubis","Radius","Ribs","Sacrum"," Scapula","Shoulder","Spine","Spine - Lumbosacral","Spine - Thoracic","Spine - Thoracolumbar","Sternoclavicular Joints","Sternum","Tarsus","Thigh","Thoracic/Dorsal","Tibia","Toes","Ulna","Upper Leg","Upper Arm","Wrist Joint"},0),"No","No","Yes","Yes","Yes","No","Yes","No","No","Yes","No","Yes","Yes","Yes","Yes","Yes" ,"Yes","Yes","Yes","No","Yes","Yes","No","No","Yes","Yes","Yes","No","Yes")
View Replies!
View Related
Listing Items In List Once
Is there a way than I can take a list of data and create a new list but only listing each value once if there is a duplicate value within that list? Original List ========= Apple Pear Orange Orange Pear Apple Peach Plum Pear New List ====== Apple Pear Orange Plum Peach
View Replies!
View Related
Counting/Summing Items
I have a separate sheet with the followingvery simplified as I probably have over 300 lines of dates and dollars) Date Dollars 2/3/2009 $25 5/3/2009 $30 5/4/2009 $50 7/4/2009 $100 8/7/2009 $25 On another sheet, I want to count the number of items by month submitted and sum the $ amount. January $0 Febuary $25 March $0 April $0 May $80 June $0 July $100 August $25 Through December Pivot table would be best if possible....but any function that would work would be fine.
View Replies!
View Related
Replace Column Items
I have a form that will open a workbook and then run a function to replace items in a column based on the column name. The problem is that it only replaces some of the items. Here is my click event that calls the function
View Replies!
View Related
Canceling Items From A Sheet
In sheet one, down column A, I have a list of numbers 1-100. What I want to do is have those numbers be removed from sheet 1 when entered in column A in sheet two. For example, in sheet 2, A1, number 53 is entered. I would like number 53 removed on sheet 1.
View Replies!
View Related
Subtotaling And Ranking Items
Looking for a way to generate the 'Top X' table listed below using formulas (not autofilters) to filter through and subtotal/rank the data. As you can see, the user will select the region, quarter, and year, and the result should be a ranking of Top X Branches for the specified time period....
View Replies!
View Related
Adding Array Items
I have two large spreadsheets that are arrays. Column A contains 40 items in both files. Columns B through X contain unique names. The arrays are filled with dollar amounts. Is there some formula or function in Excel whereby I can easily combine both spreadsheets, essentially adding the dollar amounts for each corresponding cell?
View Replies!
View Related
Too Many Items For Pivot Table
I have a database table with selling prices. I want to get a count of number of customers by sales price range. For example: Price Count $0-$5 # $5-$10 # $10-$15 # Total My nose says this is what a pivot table should do but there are too many sales prices and the pivot table craps out. How do I get them into ranges as above and then count them?
View Replies!
View Related
Count Items In Autofilter
I have a two massive spread sheets in which I am comparing items from one with the other and changing in one if the other doesn't match the first. I already have reduced the processing time from 6 hours to about 2 minutes by rewriting the macro to use autofilter to make the changes. The problem I have now is that I need to keep some metrics on the changes i.e. when I apply an autofilter, I need to be able to assign a variable to the number of items actually shown after autofiltering so I can add it to a variable that is keeping track of total number of changes. I know that outside of VBA, in regular excel use, the status bar displays # of total# found during autofilter, so is there a way to tap into the program and pull that number during execution of a macro?
View Replies!
View Related
Add Unique Items
I have a code which works perfectly and adds the dates from Column A to UserForm1 ComboBox2. In column B, I have textdata - UserForm1 ComboBox5. I'd like to transform the code to add only the dates which correspond (cascading) to 1.1 textdata in ComboBox5 (Column B) and 1.2 dates in ComboBox2 (Column A). Code: ...
View Replies!
View Related
Select Only Certain Add.items
Could the code be modified that if BSPT were selected only certain thread sizes would be shown in the combobox as the sizes below. 1/16" 1/8" 1/4" 3/8" 1/2" 3/4" 1" 1 1/4" 1 1/2" 2" 2 1/2" 3" 4" 5" 6" If NPT were selected have only the thread pitches to be shown in the Combobox below 27 18 14 11.5 8 can be selected If BSP were selected different thread pitches to be shown in the Combobox below. 28 19 14 11 Private Sub UserForm_Initialize() With ComboBox1 .AddItem "SELECT THREAD TYPE" .AddItem "NPT" .AddItem "NPTF" .AddItem "BSPT" .AddItem "NPS" .AddItem "BSP" End With
View Replies!
View Related
Multiple Items To Lookup
I have a list of products with parts for each. I made a drop down of each product and what I want to happen is after I select the product it will autopopulate all the part info for that specific product. Each part has a description, sku, quantity and price. There are up to 10 parts per product so I dont know how to do this. Normally I would use vlookup or something to that degree but I dont know how to display a bunch of information.
View Replies!
View Related
Count Different Items Within One Column
1. I need to count how many different items within one column, these are formatted as Text. cells G63:G1600 Sample text: F41D6 F44DD FABHD FAXHD FDTGD FFDGD FFTED FGDFD................... 2. I need to count how many dates fall during the week using the ending dates. Weeks ending 1/06/07, 01/13/07,etc L2:L53, the dates to count are L63:1600. Sample Text: 09/05/07 09/21/07 09/07/07 09/17/07 09/21/07 09/05/07 10/03/07 09/13/07 09/12/07 09/18/07 09/18/07.............
View Replies!
View Related
List Of Items In A Column
I have a list of items in a column. I would like to have a userform pop up with a list box (?) of all the items and I want to be able to select multiple items to perform an action on the row corresponding to the selected item. I am thinking of other examples I have seen where there are two list boxes (?) and then arrow buttons between them. When you click the arrow the item moves from one list box to the other to see which have been selected. I have never used list boxes before so if you have a link to some sample code that would be useful.
View Replies!
View Related
Add Same Items To 10 Different Combobox
The below code shows the way I add items to 10 different comboboxes. However, the items to be added are actual the same. Is there a way I can simiply it? I am worry that by the end of day, i might have up to 50-60 comboboxes and the code will be a relativity long and not efficient. Taking into consideration the the comboboxes will be labelled as Jieyi_task_ComboBox1...to 10 jane_task_ComboBox1...to 10 Kenny_task_ComboBox1.. to 10
View Replies!
View Related
Count Number Of Items With A And B
I have a workbook (attached). I want to count the number of times North AND Win, North AND Lose etc. Can anyone provide me a way of doing this. I dont want to have to use B2&C2 for example. I know I could do this and then use an IF statement (I think).
View Replies!
View Related
List Unique Items ...
I have a list of >50 contract numbers listed in cells A1:A350, with several of the numbers listed more than once. What I would like to do is, on a separate worksheet, list each contract number only once, in column A.
View Replies!
View Related
Alphabetize Combobox Items
I have a significant number of comboboxes on a multipage userform. Almost all of them are populated dynamically (it takes the user choice from one combobox, looks for that value on the spreadsheet and if it finds it, it takes whats in the next column and adds it to another combobox). My problem is that all the items in these other comboboxes are not in alphabetical order. I'd like to find some code that will work for all my comboboxes so that I don't have to have the same code over and over again for each field. I found the code below and that works to alphabetize the dropdown, but I still have to use it over and over again and change it for each fieldname (in red). I tried to use a variant and just make the value the same as each fieldname before it calls the sub and whats in red below was just my variable but that just crashes my excel.
View Replies!
View Related
Separating Items With Comma
i have many many cells that have text like the following: A,B,C,D,E,etc... what i would like is to have it show like the following instead (within the same cell): A B C D etc... i know i can do this using ALT+Enter to make the separation manually....but there are many many cells....can this be done automatically? also, it is possible that some cells would have only 1 item so in that case, it should be left alone....
View Replies!
View Related
List Items Filtered
I have a list 10 of names in Column A. ( On sheet 1 ) I then filter column A to show only three specific names, or four names etc. . . On Sheet 2, in cell A1, I would like to list the three filtered names from column A on sheet1 e.g. if the three names showing in column A ( Sheet 1) are: john, mary, jane . . . then on sheet 2 cell A1, I would like to see: "john, mary, jane"
View Replies!
View Related
Vb - Count Spreadsheet Items
I am working with VB 6.0. So far I have been able to create my recordset, opened excel spreadsheet and imported data to the spreadsheet using the recordset. The spreadsheet has five fields and each field has multiple items as in the example below. Name:Pass#:Amount: John:22222:500.00 John:22222:500.00 John:22222:500.00 John:22222:500.00 ------------------ ------------------ Jane:52522:300.00 Jane:52522:300.00 Jane:52522:300.00 Jane:52522:300.00 ------------------ ------------------ What code can I use to count all the occurences of "John", "Jane" in the spreadsheet?
View Replies!
View Related
Lookup Up Items On Another Sheet.
I have a long list written twice in 2 worksheets worksheet A has a list with some of the numbers repeated. worksheet B has the same list (none repeated) and another list with new numbers beside it. What I need is to take the new numbers from worksheet B and put them next to their correlating number in worksheet A. With many of the numbers being repeated I need something to identify and repeat the new #. I'd copy and paste and drag etc. but there's about 21,000 numbers to go through.
View Replies!
View Related
Sorting Items In A Table
I've got this table that I want to sort. I've got it formatted as a table in Excel 07. ABDescription 11Sunbake 24Make Sandcastle 35Apply Sunscreen 46Sip Coconut Mocktail 52Play with kids 66Seashells 72Starfish 83Swim 91Snorkel 2Surf 3Boogieboarding 4Eat Icecream 1Play beach volleyball I'd like to sort the table where all the 1's are together and in line with column A ie......
View Replies!
View Related
Count Of Items In List
I'm new to the forum - I've done a search but cannot find the answer to my problem. I work in a hospital and have a list of consultants who refer for a particular type of scan over a period of time. Each time the consultant refers their name is added to a list so I get a list like this: Dr Smith Dr Smith Dr Jones Dr Smith Dr Paeker Dr Paeker Dr Jones etc...
View Replies!
View Related
Add Items To A Listview
I want to add colour background to every other line in a Listbox (like the old computer paper green/white lines) but we know this can not be done, so everyone who knows says use Listview instead. Try as I might I can not seem to add items to the Listview control though. This has got be one of the dumbest questions, but how the heck do you add items, its so easy with Listbox. As an aside I wonder why no bright spark has not written a control that replaces Listbox with extra features yet.
View Replies!
View Related
Count Of Associated Items In PivotTable
I need to make a pivot table with data from 2 columns. The data has columns named Unit Type and Name. There are 9 different unit types and over a hundred different names. I need to find a way to make a table that counts however many times the name VACANT shows up for each unit type. Is this possible using a pivot table?
View Replies!
View Related
Hiding Pivot Items
I would like to program to hide pivot items given certain conditions. For example, automatically show items between range 10 to 20, hide all others. Secondly, I would like to show the top and bottom 10. The autoshow function can only list top 10 or bottom 10. I need to do both at the same time.
View Replies!
View Related
Items From Sheet In Combobox
C Attached file. I want the items that appear in B9:B5000, automaticaly in Combobox_Category. How can I do this, so that every item stays unique. example B9 = fat cow and B10= fat cow, fat cow will only appear 1 time in the combobox lista and not twice, how can I organise the combobox list Alphab?
View Replies!
View Related
|
TRACKER
