I am wanting to create a list where I can select multiple items within that list and then print only those selected items. I have created something similar thru data validation, but I can't get it to print.
In addition, I would like to be able to subdivide the list into multiple categories, then select items from these multiple categories and print them.
I have created a DAta Validation List and it only select one item. I want it to select as many items that is on the list but i can't get it to work for my main worksheet I am working on. I can't figure out why I can't get it to work for the work sheet "This Don't" but it works for the worksheet "This Works" why and how I can change it so both Reason (Column F and H can) select mutliple items on there. Data Sheet.xlsx
View 2 Replies View RelatedI watched a video on youtbe. And the women had three or four items in drop down box. She was using vba. When i emailed her to ask her how she did this, she kept telling me to go to her website and i was supose to figure it out on my own. I am trying to do a start up construction company. the link to her site is as follows Select Multiple Items from Excel Data Validation List - YouTube the idea of what i want to do, is how she clicks on a word and it follows in the coloumn to the right going down. This is what i need to know how to do. It is probably pretty elementary to many of you. But i build, i know how to read prints, to cut footprints for new homes etc. But when it comes to excel i am so green.
View 2 Replies View RelatedI'm trying to use a List Box to select multiple items on my Pivot Table but I can't seem to get it to work. Its the Report Filter part of the pivot table.
When the list Box is set to fmMultiSelectSingle it work and selects the indivdual items, but I need it set as fmMultiSelectMulti for if i'm also needed to select multiple items. (which doesn't seem to work!)
I have about 145+- employees and I made a simple spreadsheet that allows me make a timesheet for every employee. However, I do not want to sit here and select each employee's name and press print 145+ times. Is there another way to do this?
All I would like to do is press print or run a macro and 145 sheets pops out. I have to do this weekly and it would take me an hour to individually do this.
I've got a list of items (formatted alphanumeric) in column G starting at row 2. I would like a cell formula that would randomly select 30 items from this column and place them in column H starting at row 2. One caveat is that the list must remain static once created. If the Rand()function is used, it recalculates whenever the worksheet is updated so that might be a problem.
Cell formula to do this? A VBA solution would be OK as well.
I need to count the total number of times 4 different values appear in a column. This formula works for one value:
=COUNTIFS(Source!$C:$C,$B5,Source!$J:$J,$L$3,Source!$L:$L,$H$1)
Where H1 contains the word Assigned. I need to also find and add to count for matches in I1,J1 and K1 which contain New, Pending and Work in Progress respectively.
I have 2 sheets, 1 sheet has a list of materials that require Certifications. The 2nd sheet is actually a report of which materials is needed for the specific job at hand. Column C will be linked to check boxes on a different sheet in the future (thats why i used True/false instead of Yes/no). What i would like to happen is when a cell in Column C is TRUE the information in column B be sent to the Certifications sheet in a list from C8 to C34 with no spaces.
View 3 Replies View RelatedI am new to writing macros and am wondering what is the easiest way to create a drop down and select multiple items separated by comas. The people who are going to input data into this spreadsheet are field people and not technically savvy so need to design something that is just a matter of cliking on the drop down and selecting multiple items and they should show on the same cell separated by commas.
View 9 Replies View RelatedI am making a spreadsheet that allows users to select items from a validated data list. Each item in the list has a numeric value in an adjacent column. When the user is entering data they will select from a drop down of the data list in column "A" and I would like to have the numeric value that corresponds with their selection to then autofill in column "B". I have tried VLOOKUP and IF formulas but cannot seem to get anything to work.
View 9 Replies View RelatedI have a list box, that I have set MultiSelect to "1 - frMultiSelectMulti"
What I would like to be able to do is select multiple items and have those items appear in a single cell on my spreadsheet.
Maybe something like: WA, CA, OR Forms.ListBox.1 is the name of my object. Or do I need to use a different object type?
I'm trying to write a macro to select the multiple sets of the same data for several PIVOT tables. I've tried Slicers but it seems that this takes up too much processing power and always times out.
My workaround is to do a macro that picks out the said data, however when i do the below, plus another 4-500 lines i get told that there are too many line continuations
Code:
ActiveSheet.PivotTables("PivotTable6").PivotFields( _
"[Postal District].[Postal District].[Postal District]").VisibleItemsList = _
Array("[Postal District].[Postal District].&[AB11]", _
"[Postal District].[Postal District].&[AB12]", _
[Code] ...
What I'm looking to do is express all the postcodes in one line or at least multiple post codes in one go, this is what I've tried:
Code:
"[Postal District].[Postal District].&[AB12].&[AB13]"
and
Code:
"[Postal District].[Postal District].&[AB12,AB13]"
But to no avail.
I'm running a pretty huge database with Part Numbers across several Suppliers which fluctuate constantly.
For example: a HEXAGONAL BOLT may have a Part Number ABC123, but depending on the size of the bolt it could be a ABC123-001 ABC123-V28 ABC123-40mm (etc)
There's a lot of data (some of it sensitive) so I don't want the users to see everything - I'm creating a front-end sheet and am looking for a way for a user to type in the Part Number "ABC123" into cell A1, then the Pivot below to auto-update (with Part Number on the 'Report Filter') to show all variations of ABC123, including ABC123-1 ABC123-2 etc - i.e. not an exact match; everything that contains the characters in cell A1.
The relevant information has been ported in and password protected on a sepearate sheet within the workbook, so it's literally a code to make the cell value affect the filter.
I know how to use array formulae to create a unique list, i.e.{=INDEX($G$1:$G$760,SMALL(IF(ROW($G$1:$G$760)=MATCH($G$1:$G$760,$G$1:$G$760,0),ROW($G$1:$G$760)),ROW()))}
however this is giving all the unique items from column G and I only want the unique items that have a non-zero value in column H as well. This would be the sumif of all instances that would have to be zero. I've tried to crack it and I've tried to search for solutions but so far no joy.
changing two variables a various amount of times and running the same procedure and copying the resutls into another sheet. Seems like a perfect place for a macro. However, these variables can be chosen from a list that the user wants. So why not build in a listbox for each one. Now I have two listboxes one for variable A and one for variable B.
The procedure in theory goes something like this we change variable A from the base case and then run the procedure for variable B, get the results, then run the scenario again but changing only variable B abnd repeat. Then once, all of the variable B scenarios are done, I want to change the variable A and then repeat and so forth.
That is the background and my main problem at this point, is that have these values in two listboxes, I know how to do the for each loops and such, however, I do not know how to do them for values in the listbox.
How do I identify the values selected in the respective listboxes and then pull them so I only use them for the for each loop?
I want to do a function similar to a vlookup. I want to input a key
into a cell and have the relevant names listed. The problem I have is
the vlookup only shows one of the multiple names. Is there a way to
list all of the names?
Input Key: ____
KeyName
1414BRODRENE DAHL A/S
1880MAN FERROSTAAL AG
2356HEITON BUCKLEY LIMITED
2356HEITON BUCKLEY LIMITED1
2356HEITON BUCKLEY LIMITED2
2356HEITON BUCKLEY LIMITED3
3867STAVANGER RORHANDEL A/S
4367CLEANAWAY LTD
4618ALUKONIGSTAHL GMBH
4618ALUKONIGSTAHL GMBH1
4979MARMON/KEYSTONE ANBUMA N.V.
Ideal Output
Input Key 2356
HEITON BUCKLEY LIMITED //all brought up by a formula
HEITON BUCKLEY LIMITED1
HEITON BUCKLEY LIMITED2
HEITON BUCKLEY LIMITED3
In column A i have list with the names like this.
ROSEHILL 1
ROSEHILL 1
ROSEHILL 2
ROSEHILL 2
ROSEHILL 2
ROSEHILL 2
ROSEHILL 3
ROSEHILL 3
ROSEHILL 3
When i use the Vlookup to return the value in column M it does not work as you would expect, i have done some searches and found a few different formulas but can't get any to work, the data i am searching is listed on one sheet and the criteria and the formula is on another.
I tried this formula as an array but no joy.
=IFERROR(INDEX(Data!$A$2:$M$900, SMALL(IF($GO$4=Data!$A$2:$A$900,
ROW(Data!$A$2:$A$900)-ROW(Data!$A$2)+1), ROW(1:1))),"" )
Is it possible to restrict the values of cells in a particular column to entries defined in a list BUT to allow each cell in that column to display multiple items from the list (seperated by a comma for example). I've attached an example of what I would like to do -
In Sheet "2010 Data" I want to be able to select multiple values in column F....(the values are defined within the list named "Platforms" on the worksheet called "Lookups"
I have two worksheets: A and B.
Worksheet A:Contains 2 columns: Issue# (Col. A) and Program (Col. B).
Issue# contains a list of multiple issues. There are several instances in which the issue# is repeated.
Any particular Issue# field may have several issues in it, delimited by a comma.
Program is a program associated with the issue and this column also contains duplicates.
Worksheet B:Contains 1 column: Issue# (Col. A)
This is a unique list of issues#'s.
All Im looking to do is parse all Issue#'s from Worksheet B and have some way of knowing if that issue# is anywhere in Worksheet A. Most importantly, I need the "indicator" to be displayed on Worksheet A. This way I can see what program(s) is/are associated with the matching issues.
A couple other notes:All Issue#'s in Worksheet B are referenced at least once in the Worksheet A Issue# list
There are several issues in Worksheet A which are not referenced in the issue list on worksheet B (of which I dont care about)
I really hope that makes sense, but if not...
Here's the best example I could come up with: ....
I was wondering if there was a way to create a pop-up list to appear when a user selects a certain cell that would provide the user with a list of (in this particular case) inventory items. The user would select which items they require for the task at hand and the total $$cost of the items would appear in the cell once is is deselected.
View 4 Replies View RelatedI have print macros that print several different items from more than one workbook all at once. It works fine when printing to paper - you go to the printer and pick it all up in order. The problem is when I try to print it to a PDF - it prints each item to a separate file. The code below doesn't work - the second item printed just replaces the first item printed.
Sub PrintToPDF()
Dim strNewFileNameHere As String
strNewFileNameHere = "SomeFileName" & ".pdf"
ThisWorkbook. Sheets("Sheet1").PrintOut ActivePrinter:="Acrobat PDFWriter on LPT1:", PrintToFile:=True, PrToFileName:=strNewFileNameHere
ThisWorkbook.Sheets("Sheet2").PrintOut ActivePrinter:="Acrobat PDFWriter on LPT1:", PrintToFile:=True, PrToFileName:=strNewFileNameHere
End Sub
How can I call several different print macros and get them all to print to the same pdf?
I have a spreadsheet that lists a set of actions and the days they need to be completed.
The due dates are listed in column c and in column h I have a the user choosing "completed" from a drop down data validation.
I have a dashboard on a separate worksheet, showing if the item is complete and the due date.
Ideally I would like to display the dates on the dashboard in red if they are past due, and the box in column h was not marked complete.
I have been going through my books and trying to solve this, but I run into a different issues.
Even if for now If I can get the main worksheet to display the color conditional formatting that would work
I have a list of items and I would like to print each of their details without having to select each of them from the combo box and then press the print button for each of them...
Is there a way to do this automatically ?
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
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 4 Replies View RelatedI've got two listboxes
Listbox1 has
A
B
C
D
E
Listbox2 has
1
2
3
4
5
6
7
8
9
10
If someone clicks "A" in listbox1, I want to select "1" & "4" in listbox2.
If someone clicks "B" in listbox1, I want to select "2" & "3" in listbox2.
etc.
I have a column of DV lists. Is it possible for me to make excel, go through each DV list, and randomly select an item from each DV list?
View 1 Replies View RelatedI have 8 car models in column A of sheet1 and I have a list box control with every car model on sheet 1 as well. I would like code to select all the models from column a in the list box with code.
View 2 Replies View RelatedHow to select pivot items in a pivot field based on choices from a MULTICOLUMN listbox?
At present, all I know is how to deselect pivot field values
Range("A5").Select
With ActiveSheet.PivotTables("PivotTable4").PivotFields("MONTH")
.PivotItems("MAY").Visible = False
Because the pivot table automatically starts with all items selected?
I am trying to use the bellow code to set one pivot item (MyItem) to true and the rest to false... unsuccesfully
Code:
For Each pt In Sheets("Schedule Dashboard").PivotTables(PivotTable1)
If pt.PivotFields("District").PivotItems(MyItem).Visible = False Then
pt.PivotFields("District").PivotItems(MyItem).Visible = True
Else
pt.PivotFields("District").PivotItems.Visible = False
End If
Next pt