Form One Unique List
Mar 10, 2008
I have two groups of data listed in one sheet. I have supplier names down the side and locations across the top, with data filling the respective cells. Refer excel file attached. At the moment I am manually merging the two lists to form one. I am copying both rows of headings and creating one unique row heading list, deleting any duplicates, then cutting and pasting the data under the respective heading. Because I am going to have to do this every month when new data comes in, I want to know whether their is a way to create a macro to automate this process...
View 2 Replies
ADVERTISEMENT
Jan 24, 2008
I am trying to create a form with a combobox drop down menu. The list I need displayed is in cells C4:C20 but I only want to show unique values not all of them.
View 9 Replies
View Related
Jan 24, 2007
I have created the attached file and would like to do the following using user forms:
1) From the sheet 'Courses', select a course on schedule it on a date - No problems, done this using form 'Schedule Course'
2) I would then like to assign people to courses scheduled using 'Attendees' form - this is where I am stuck and will appreciate some help. Problems faced are:
I need to schedule the same type of course more than once however I want the user to have only one selection from the drop down list (Spin should appear only once even though I have 4-5 scheduled) - he should then be able to select one of the dates for when the course has been scheduled
View 9 Replies
View Related
Oct 22, 2009
Each product is represented by a serial number (column A).
The can be sorted on column A from smallest to largest prior to calculating results if that helps.
The repair list contains 1 entry per spare part used, so the same serial number may occur several times.
Furthermore, a product may have been repaired on several instances - so the serial numbers can span several dates (column B).
The solution i am looking for should return the number of unique repair dates per serial number. That way i can see, how many times each product has been repaired. Results can be displayed in an individual column.
Sample list:
Serial........Repair date
207742052008-09-04
207755082008-12-17
207755212008-12-31
207755212009-01-22
207755212009-01-22
207755212009-01-22
207755212009-02-13
207755212009-07-24
207755362009-05-20................................
View 8 Replies
View Related
Jul 30, 2009
I have a data table that repeats as follows:
CITI
SCB
SCB
SCB
SCB
SCB
SCB
SCB
RBC
RBC
RBC
RBC
From the data above I need to make a new unqie list that would grab all unique entries.
CITI
SCB
RBC
I am trying to use the following guide:
http://blogs.techrepublic.com.com/howdoi/?p=111
Get stuck on "Listing A:
View 9 Replies
View Related
Mar 18, 2010
Is it possible to produce one unique list from two, and preferably in alphabetical order, without resorting to VBA? i.e. a formula solution.
I've attached a sample.
View 7 Replies
View Related
Apr 13, 2006
I need to have a end user form that pulls information from a database and simplifies work for our substitue coordinator. Please be advised I have been working on this and can not get the desired results. I need a form that displays the current date and 5 columns of data the Data needs to be in seperate cells for example cell A1 titled TEACHERS and then the sub coordinator could start typing the name of the teacher in a2 and a predefined database of teachers name, class they teach, etc. MATH, ENGLISH and planning period would be pooled and automaticly fill the cell.
I also would need a second cell say cell B to be call Substitutes and b2- b100 to pull data from a database of substitute names and display their information.
View 9 Replies
View Related
Apr 18, 2013
I have my dummy data, and I have (what I think) is how I want the data to be shown. My friend uses Google Sheets, but I prefer Excel. I am trying to convert the code because I am a stickler for excel. Typically I can convert codes some easily, but this is way beyond me.
For Column A: I want to create a list on sheet 'Setup!' based on ids!D2:D="yes". If that list has duplicate entries, I would like only the first entry to show up, but for the next entries I would like the cell to be blank. (this is important for the next step) For Column C: I want to have the corresponding dates go with the name entry. For Column D: I want to have the notes go with the corresponding date entry. (I believe I can manipulate Column C's code to do Column D myself).
I am also going to upload a data sheet, and an expected results sheet.
unique list.xlsx
View 1 Replies
View Related
May 28, 2014
The function below should return the value in a cell IF the string in the cell two cells to the left of it is "Nemo" Omitting the part highlighted in blue, my function returns a list of unique values...but when it's included, nothing is returned at all. Perhaps, there is an error in the syntax that I'm overlooking?
Function listUnique(rng As Range) As Variant
Dim row As Range
Dim elements() As String
[Code]....
View 2 Replies
View Related
Oct 28, 2011
I'm looking for a way to get a unique list from a column to a data validation drop down list. Any fancy formula or vba script to create a UDF which. Does this?
View 5 Replies
View Related
May 23, 2009
I've searched the forum and believe this thread to be the closest to what im looking for, but its doesnt completely apply: matrix to list conversion. I have an attachment to support my questions (see attached). I have a matrix of words (strings) that contain repeating and non-repeating contents. The matrix also has spaces which are of no value. Essentially, the VBA needs to ' analyze' this matrix and create a consolidated frequency list (as shown in the file).
The matrices are HUGE and therefore some of the clumsy VBA i am using is turning out to be a bit inefficient. The file also contains formulas and such that I cannot use AutoFilter nor can I use Insert or Delete rows...so the VBA shouldnt use those either.
View 6 Replies
View Related
Dec 16, 2009
I wrote a macro which creates desired output based on one default variables. But I want to change it to take user selected assumptions and perform the macro for each user selected variables.
I am confused with user forms and controls and what to use.
Can anyone give the code to how to add a list box to a userform and then add items to the listbox, and run macro based on thegiven input in the list box?
View 14 Replies
View Related
Jun 16, 2009
I have a dynamic list of names from B2:B500. I want to write a macro that finds all the unique entries from that list and pastes it to AD3:AD501 everytime the macro is run. What would be the code for this procedure.
View 9 Replies
View Related
Nov 28, 2007
I have a list of data which looks like this
Column B
Name
---------
Jones, Bob
Jones, Bob
Jones, Bob
Smith, Mike
Smith, Mike
Smith, Mike
Calai, Dave
Calai, Dave
Calai, Dave
Etc...
What I want to do is take the entire list and create a distinct list that I can use in a named range then use a validation list to have a drop down within a different tab.
View 9 Replies
View Related
Sep 30, 2008
I have a form that is built based on the number a person enters. For Example - if the person enters the number 2 then 2 ComboBoxes are entered on the form.
The problem that I am having is that the list is not showing when the form is loaded. In the Project Screen all is OK until the final step when the form is Shown.
View 7 Replies
View Related
Feb 26, 2013
Imagine this..
In Column A I have 500 email addresses.
In Column B I have 2000 email addresses.
Now in Column C, I want to have all the email addresses in Column B MINUS all the email addresses in Column A.
IE: So basically if Column B had 300 of the same email addresses in Column A, then Column C will have 1,700 email addresses (2,000 - 3000) = 1,7000.
View 1 Replies
View Related
Jul 1, 2008
Im designing a form which will be a few list boxes that input data into specific cells in another sheet.
I would like the list boxes to change depending on selection.
eg: if there is a certain value selected in the first list, then only the relevant values will appear in the second box.
so if there are values Potato, Banana and Apple in list one, and list two contains values White, Yellow and Red.
if banana is clicked in list 1 then only yellow will appear in box 2 as a selection.
View 10 Replies
View Related
Apr 17, 2009
I want is to enter a name and e-mail list through the form. The name is then entered into a column ‘E’ and copied into column ‘A” that automatically alphabetizes the list for a dropdown list and a column reference is entered in the next column ‘B’ using vlookup so the column references remain with the proper name.
Ideally when a new name is entered in column ‘E’, column ‘F’ is updated to the next column references, the name is copied to column ‘A’ and the lookup formula in column ‘B’ is copied down.
View 7 Replies
View Related
May 14, 2009
Working on a user form... I have a combo box, with a list of the items available.... then I have a text box that inputs the quantity. Is there a way that I can put a list underneath in such a way that every time I select a item, put the quantity in the text box, it will list down in that list?
In other words... If I have 5 products for the same order I would pick one, qty and click add, then another one, qty, and add... so on. That way I would be able to see all of the items that I have picked.
View 5 Replies
View Related
Feb 20, 2012
I created a nice list box where the user can select any members of a ListBox1, and put them into a ListBox2. This happens in a Form I created, UserForm1.
Now I can't figure out how to get this ListBox2.list from Userform1 into my code in Module1! Any reference to ListBox2 in Module1 results in an error like "Run-time error '424': Object required.
View 9 Replies
View Related
Nov 8, 2012
I figure the before/after image would be best to describe what I need. I have various sections of data saved in this one spreadsheet which a program reads from for comparisons.
Right now they are in a list form like this:
Now the end result I want to look like this. Basically take the items in the column, and add the items selected next to it, one in each column not including itself of course.
These are basically the comparables, example this list would be "car manufacturers", and below that in cell A7 I might have another list started that has to do with "motorcycle manufacturers" etc
The end result would give a row of all possible combinations. The app we use pulls from the rows so it needs to have all of the items that are comparable in there and I can't seem to find a way in which to do this.
Hopefully this is understandable when you see what I manually did (unfortunately I need to do this for about 4000 entries, a few hundred groups of different characteristics).
View 1 Replies
View Related
May 17, 2008
I would like to create a form to select some columns from a list of columns.
This could make it simpler for an end-user to chose which columns they want to see in my application.
(see my previous question: [url]
Ideally, I would prefer to do that just like rows can be selected in an Excel list.
However, I doubt this could be done.
So, to be practical, I would put a button on my sheet.
When the user clicks the button, a form would appear and show the current list of columns.
The user would mark or unmark to define his view and click ok to get the sheet with only the columns he wants.
The number of column in the table can change.
When the form loads it must determine what are the columns to include in the list (headers).
What I really don't know is which controls I should use on the form?
Are there some list control with tick marks available, for example?
Or, I might dream of a mark-enables combo box or list box, as can be seen often on the web.
View 9 Replies
View Related
Nov 27, 2013
I've got noticed "Sub or Function not defined". Here's the code:
VB:
Private Sub UserForm_Initialize()
' Abul Jibrin // November 2013
'------------------------
Dim Item As Range, UniqItem, n As Long
Set Tbl = Sheets("Sheet1").Cells(1, 2).CurrentRegion
Set Cabang = Tbl.Offset(2, 2).Resize(Tbl.Rows.Count - 2, 1)
[Code] ....
Note: I found that code :
Add item in combobox isn't using hardcoded but taking UniqueValue in column Item (which means using softcoded)
Unfortunately my friend's passed away so I can't continue asking him. I was trying to study his formula on my own but it still doesn't work at all
Here's the file : LIST OF UNIQUE VALUE.xlsm
View 9 Replies
View Related
May 28, 2008
I have a list of values in column A. How can I put a list of all the unique values contained in column A in a list format in column C?
I would prefer to use VBA code as to automate the process.
View 9 Replies
View Related
Jan 6, 2014
I want to link a table to a form. Only, I noticed that when setting the input range in the form I'm unable to use OFFSET OR a table name. How can I link the form to a list which is going to expand?
Attached is an example. Two sheets. One for the list. One for the form. The list will keep getting added to.
Unrelated-but perhaps useful - Is it possible to link one cell to a list in another sheet so a user can type in a word and it will offer autocomplete options in excel 2007 ?
linklistoform.xlsx
View 1 Replies
View Related
Jun 4, 2008
I am designing (badly!) an excel file that is intended to be as user friendly as possible. I would like to add in a navigation feature using a list box or other appropriate control form that will take the user to the correct tab in the workbook depending on which item they choose from the list.
My aim is too hide all the tabs at the bottom whilst not crowding my page with multiple command buttons, and still be able to navigate easily through the workbook.
View 12 Replies
View Related
Oct 19, 2009
The list boxes on my Form all have a dark blue backround which makes it hard to tell when the box has been selected for data entry. Could someone tell me what item in the "properties" window controls this function.
View 14 Replies
View Related
Feb 8, 2010
The text box where the end user types in the data - I want to make this have a drop down list like when using data validation but dont have a clue how to.
View 5 Replies
View Related
Feb 17, 2010
In the attached example I can't add more than one name at a time without closing the user form. I can edit the list and click the "Save Changes" button and the changes happen. But using the "Add Name" button I can not add more than one name without closing the form, it just overwrites the previous name unless I close the form.
View 2 Replies
View Related
Jun 13, 2008
how to store the variables selected in a list box for future use in the macro?
I've got code as follows:
This is in my main module
'These set up the global variables
Public SelectedRegion As Variant 'I've also used string
Public NewTabName As Variant 'I've also used string
'This links the list box to the values in a hidden tab named "Regions" and shows the form
WSForm.RgList.RowSource = "Regions!A1:A10"
WSForm.Show
This is in my coding for the form itself (list box & buttons)
'Code for my "Cancel" button
Private Sub cmdCancel_Click()
Unload Me
End Sub
View 9 Replies
View Related
