Formula To Pull Out Data From A List To Create Class Lists?
May 16, 2014
if there was a way to automatically add each student to a class list as their information is inputted. What i mean is, after input Sally Student in the main enrollment list she would automatically go to the class list for the class she has chosen.
I have attached a sample workbook with my desired results. Basically what i want to do is make this easier for those in charge to get the class lists from the main list without having to copy and past all the time.
The class lists are in the tabs in the workbook.
View 5 Replies
ADVERTISEMENT
Dec 16, 2013
I am creating a class list from a list of all students and classes. Names of students are in column A, their class name is in column B. In another sheet I would like to show a list of names from one particular class, say "Y8/En1".
Using a filter on the original list isn't an option as I will need it to pull/show other things eventually.
View 7 Replies
View Related
Jul 13, 2012
I have a sheet with data that is associated with a month or season. I need to create a drop down list or check boxes on another sheet that will allow me to select the data associated with the month or season that is chosen.
For instance, on Sheet1, I have Summer-12 as the label in cell A1, and the data associated with it in cell A3:AH15. Winter-12 is in cell A18 and the data associated with it is in B20:31.
This goes on for 3 years of data.
I need a drop down list or check boxes on sheet2 where I can select one or multiple seasons and then the associated data for those seasons appear in order.
View 9 Replies
View Related
Mar 13, 2008
Any way to create a list in a column from other lists in other columns?
View 9 Replies
View Related
Sep 5, 2012
I need to create a list of all available variations from 2 lists. Example, I have a list of data that has 50 entries in it, and another list that has 300. I need to create a list of all options to import into a system that would include all 1500 options if you were to make a list of all possible combinations of the 2 lists of data...
EG. list 1 = 1, 2, 3, 4, 5 and list 2 = a b c d e
Final list would be
1a
2a
3a
4a
5a
1b
2b
3b
4b
5b
1c
2c
3c
4c
5c
etc...
View 1 Replies
View Related
Oct 3, 2007
I have a number of text columns, side by side in a worksheet, containing names. I wish to combine these columns into one new column, removing any duplicates, to create a single list of names. Is there a simple way to do this?
View 3 Replies
View Related
Nov 1, 2013
I am trying to create a Macro to pull from a list and then update the charts and print. I have a list that has over 100 clients. I believe I need to loop but I am not familiar with VBAs at all. Below is what I am trying to accomplish.
Sub Update()
'
' Update Macro
'
'
Selection.Copy
ActiveSheet.Next.Select
Range("B2").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Calculate
[Code] ......
View 3 Replies
View Related
Jun 6, 2013
I'm using Excel 2010. I have a workbook that has six or seven worksheets in it. Each worksheet has a header row, and then lists of clients at the clinic where I work. The columns are last name, first name, medicaid #, social security #, DOB. We use these lists every month to verify that each client has Medicaid for the month. Therefore, there are also columns with names like April, May, June where we mark yes or no for each client. Some of the worksheets also have information about the clients' guardian, phone number, etc., but not every worksheet has those. (I can't show you the worksheets b/c of federal privacy laws, of course.)
I really, really want a worksheet that's a master list of the data from each of the existing worksheets, and I'd like to keep it synced to the source worksheets. I'd love it if I could also add a column telling me which of the source worksheets the data originally came from.
I've tried a few things to make it happen, but nothing has worked.
I've tried using the Consolidate function built into Excel as well, but that only works with numbers, not text, and it wants to manipulate the numbers instead of just copying them over.
I've found several macros online that should have worked (including one from this site) but that I wasn't able to install to my worksheet. I followed all the steps for installation, and throught it worked, but when I went back to the Excel file to run the macro, the list of available macros remained emptpy.
Is it possible that corporate IT has disabled the ability to install macros? Is there somewhere in Options were I need to go to turn Macros on?
View 5 Replies
View Related
Dec 5, 2007
I am trying to create a formula to pull the person's name and the avg number of cartons sorted for the month from this spreadsheet.
I've attached a sample of the spreadsheet I created, you will see at the bottom I would like to see the person that had the highest avg for the month and the person with the lowest avg for the month.
This is just a simple spreadsheet to track productivity of my sortation employees.
View 9 Replies
View Related
Dec 30, 2009
I'm having difficulty creating an array formula. In a multi-column sheet, I am looking at a column with classes and a column with a date (in the format 7-Oct-09). I need to list the number of a specific class for a particular month (any day). I have tried the following which gives only the number of classes:
=COUNTIF(A4:A2500,"AA")+COUNTIF(H4:H2500,"10/??/09") and
=SUM((A4:A2500="AA")*(H4:H2500="??-Oct-??")) which gives me 0. Maybe an array formula is not the way to do this.
View 9 Replies
View Related
Jan 20, 2014
I need to consolidate these two lists of data into one list.
First set is just a basic list of individuals with their data.
Second set is multiple entries for those same individuals. Each entry shows a subscription to a programme. The final single sheet should have one row per individual which shows all of the programmes they are subscribed to.
See attached, example sheet.
The real list is 3000 IDs, so need some kind of formula to do this.
View 4 Replies
View Related
Jul 6, 2014
I'm trying to compile a spread sheet that will pull the play by play logs from the NHL website.
The logs are listed in order.
Game 1 is [URL]... Game 2 is [URL]... etc etc
I am trying to put them all on one spreadsheet. (or to do it in batches of 100, or 50 or whatever the size of the file allows)
View 1 Replies
View Related
Jun 4, 2014
I have a list of names in column A these names repeat themselves a lot and I don't know how many there are.
now I want to make a list of the names in column c starting at C2 that looks down row A finds names and puts them in column C one after the other.
View 3 Replies
View Related
Oct 11, 2008
I'm attaching a copy for verification. On the invoice sheet once the place and # in class are entered it needs to pull the amount it will payout (based on the place and the # in class). No matter what I do I can't seem to get the formula to work.
View 2 Replies
View Related
Nov 10, 2008
I cant seem to find the correct syntax for creating 14 validation lists using array members as the source of the named ranged. The validation lists are stored on a different worksheet, the Named Ranges are created fine, as are the ranges that are having the validation applied. The Syntax I am having a problem with is
Public Sub assignDVList(WSD As Worksheet, sListName As String)
Dim DVListName As String
DVListName = "DV" & sListName
Application.Goto Reference:=sListName
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=" & DVListName
It is the Formula1:="=" & DVListName that is creating the headache. The sub is called as the array moves through the columns, using the header row as the Name for the Named Range, and the data Validation worksheet uses the same naming except it has DV in front.
View 4 Replies
View Related
Mar 28, 2014
Is it possible to have a formula that generate a Unique list (List 1 and List 2) of Missing values in List 2 by comparing two lists? Something like this
List 1 List 2 Missing in List 2
1 1 3
3 4 6
5 5
6 6
View 3 Replies
View Related
Aug 28, 2007
I have a question regarding the data validation lists. What i have is 4 different lists
Department
Assays
Instrument
Manufacturer
What I want to do is...once a user chooses a department, he gets a list of assays done in the chosen dept. and also a list of instrument used by the dept and a list of manufacturers
I used the examples shown here
http://www.contextures.com/xlDataVal13.html
http://www.contextures.com/xlDataVal02.html
and was able to succeed in creating dependent lists to some extent...I am attaching whatever I have able to accomplish so far, which is able to pull up the assay list based on the dept. ...but am confused as to how to get the Instrument and Manufacturer list at the same time .....please choose 'Chem 2" from the dept list to see what I have managed to do so far
View 11 Replies
View Related
Sep 28, 2007
I have on a sheet:
4 data validation lists that contain the exact same values.
would like to have:
One validation list box that is dependant on all 4 vd lists.
I posted a thread on dv and came to the conclusion that it is not possible to use INDIRECT() as it only allows for one cell reference and not four.
Is there another way to do this?
Glove Man, I tried your suggestion but couldn't get it work.
View 9 Replies
View Related
Jan 12, 2010
Is there a way to use Data Validation that will pull data from a source list and also be able to type in additional data or just new data in same cell?
View 3 Replies
View Related
Jan 4, 2013
I have an (organization) work book that contains departments in different tab with each department having its own tab. In each tab is the employee name, dept manager, dept number and emp number. In the CoverSheet (main sheet) I want to put the department numbers in a drop down menu.Upon selection of a department number i want to Look in the whole workbook to see where the department number is, pull up the department head and all the employees in that department with their employee numbers
The reason for this is that I want to be able to add a button to delete/edit to be able to edit employee details centrally from this particular (CoverSheet) sheet and update the relevant sheet.
Also put in an input box to add employees and update the relevant tab (department)
View 7 Replies
View Related
Jul 19, 2014
I am doing a spreadsheet where I have 1 main sheet and 2 sheets with data.On the main sheet I have a drop down list to select either one of the 2 sheets and upon selecting,all the data from that selected sheet will be displayed on the main sheet.
What i do not understand is the code given below
data:=IF($C$7='A2'!$A$2,INDEX('A2'!$A$6:$B$20,ROW( $A3),COLUMN(B$1)),
INDEX('A1'!$A$6:$B$20,ROW($A3),C OLUMN(B$1)))
How do i attach spreadsheet in this forums btw?
View 7 Replies
View Related
Aug 21, 2014
Is there a simple way via VBA to alter the layout of data from a mixed up two column list into multiple headed lists on another worksheet (within the same workbook)?
The attachment should better demonstrate what I mean. Sheet1 has example data of how it is and Sheet2 shows how I would like it.
The data will be dynamic in the sense the numbers of unique values in column A will change (only increase, never decrease), as will the number of unique values in column B.
View 2 Replies
View Related
Sep 29, 2010
I'm not including my spreadsheet because it has company information however, I will try to articulate my request as best I can. I currently have an Excel spreadsheet with about 20 worksheets, I would like to be able to click on the first worksheet, create a "Drop Down box" or "Data Validation" box or whatever I need to do to be able to view information in a range of cells on ANOTHER worksheet within the same workbook.
I've tried Data Validation, Drop Down Boxes, Define name ranges, all to NO avail. I'm missing a step somewhere, because I'm still not able to view the information on the first worksheet.
View 3 Replies
View Related
May 20, 2009
I have a range called List that has 3 columns of data:
Corporate Human Resources Services PMA
Corporate Procurement Director
Ops Central Customer Services Lost Property Office
Ops Travel Information Travel Info Call Ctr
Ops Travel Information Centres Travel Info Centres
I have 3 columns on the entry sheet called Business Unit (Col A), Department(Col B) and Sub-Department (Col C). I want to limit the choice in column B to based on the selection in Column A in the form of a drop-down list e.g choosing Corporate gives a list of Human Resources Services; Procurement.
I am using the list option for field validation and the following formula in cell B2: =INDIRECT(VLOOKUP(A2,List,2,0)). I'm not sure what I'm doing wrong as I don't get a list of options just a blank cell. Do I need to use a different formula other than VLOOKUP..?
View 3 Replies
View Related
Mar 17, 2007
I Attached a sheet for what i'm asking about ,, i sent it before but the sheet showing it more clearly
View 10 Replies
View Related
Jan 4, 2013
I've attached a spreadsheet showing the effect I'm trying to achieve. A list (which changes weekly) contains employee details and length of service. Based on the length of service I need to build a new list grouping the employees based on the service length.
list-test.xlsx
View 6 Replies
View Related
Jan 26, 2009
I need to create a macro that will scan a spreadsheet for the number of sheets and then pull data from the same places on each sheet in order to create a summary sheet. Let me try to explain a little better.
The spreadsheet I'm working with has a separate sheet for each new deal our company makes. Each of these sheets is in the same format - we use a template and fill in the data based on that whenever a new deal emerges. The sheets contain basic info about the deal in the first few rows and columns, then some narratives with dates describing the progress of the deal, and then a list of issues and whether or not they have been resolved. The problem is, each of these sheets contains too much info for a quick, high-level overview with the bosses so they've asked me to create something that will pull the basic info, the most recent narrative, and any unresolved issues from each sheet. This way, each time there's an overview scheduled with the bosses, the macro can be run and it will create a new sheet with data from each sheet in the workbook.
View 9 Replies
View Related
Apr 23, 2014
I am trying to have my spreadsheet pull data from one tab and cell if they match another.
Tab "Ag Orders" column H, I enter data in lets say cell H37. Whatever I enter, if it matches tab "reference List" C:C, then "ag orders" column G (specifically G37) should enter the data in "reference List" D:D
So since in H37 I entered 34000 - 314620, G37 should pull in Farm Operations since on the referene list tab that string of numbers (C11 matches up with D11)
a little confusing but I hope it makes sense.
13-14 budget-AG.xlsm
This isn't the exact formula I used but something like it and it wasn't working. It wouldn't match the data up correctly on a few of the department names
=IFERROR(LOOKUP(H35,("11000 - 311010","11000 - 311020","11000 - 311510","11000 - 311610","11000 - 312010","17800 - 311010","17800 - 311510","17800 - 312010","34000 - 314610","34000 - 314620","34000 - 314640","34000 - 314660","34000 - 314680","34000 - 314690","81008 - 840008","81009 - 840009","13863 - 312040","13864 - 312050","71060 - 521620"),
[Code] ..........
View 1 Replies
View Related
Jun 14, 2014
Looking for formula to extract data from the raw data table list to a new table list when an option is selected from the dropdown list.
Sample data attached and desired outcome in green color.
Outcome
Product 3
ProductTargetOff TargetTarget Range
January364980
February135732
March162167
April
May
June
July
August
September
October
November
December
View 3 Replies
View Related
Jul 7, 2014
I am trying to use the indirect formula to pull in data from a cell in a different worksheet using the tab name as my reference. For example:
I have my tab name in cell A2, then I am using this formula to pull the information from cell g29 on the tab listed in A2, but its not working:
=INDIRECT(A2&”!”&”g29″)
Also, my tab name in cell a2 is a date, does that make any difference? I've tried a couple variations on the indirect formula and have gone from the #REF! error to the #NAME? error.
View 2 Replies
View Related
