Fall - Columns A-G
Spring - Columns I-O
Summer - Columns Q-W
Unduplicated - Columns Y-AD
I am needing to take each student in the Unduplicated section and see which terms they attended. If they attended a specific term, I need to grab a piece of data from that term and put it in over in the undulicated area.
The only way I could think to do this is with three separate searches. This is probably grossly inefficient and so far it has not worked at all. I have posted below the code I am currently using. Again this code is not workin at all.
If I'm using this function to find the specific text "EXPIRED" in the specified cells, how can I add additional cell ranges on the same sheet to this function?
i'm having in excel- I'm looking to populate rows in 2nd tab based on the data entered in the 1st tab. The rows to be populated in the 2nd tab resides in the 3rd tab. So a match has to be made on the data entered in the 1st tab. When a match is found on the 3rd tab then the corresponding rows from the 3rd tab should be listed on the 2nd tab.
I have 180,000 names in a spreadsheet with unique codes for each, I need to search for names and find their code numbers, how can I do this over a series of 8 columns.
Code Name code Name code Name Code Name
I'll need to search columns 2, 4, 6 and 8 for the name?
I have 12 columns of numeric data in cells AA80 through AL80. Beginning with the cell on the far right (AL80), return the value if >0. Otherwise, proceed to the cell to the immediate left (AK80) and return the value if >0, otherwise proceed to the next left cell...all the way to AA80. I tried this by nesting IF functions, but have too many IF functions to nest. Lintcoop posted a similar thread in 2008 but with text data.
I've got a spreadsheet which lists reference numbers and a value of each one on for two different weeks which looks like this (please ignore the ....'s - I was trying to illustrate the colums clearly but the spaces seem to get removed when I post this)
What I want to do is compare the value for week 1 and week 2 for each reference number. The problem is that not all the reference numbers for week 1 will be in week 2, and not all the reference numbers in week 2 will have appeared in week 1. I would like to know if there's a way that excel can identify a specific reference number, search for the values for this in week one and week two, and display any differences between these, (e.g. on the above spreadsheet I would like to identify that ref 123456 appears in both weeks and that the balance is the same, reference 147258 appears in both but the value is different, and that reference 113456 & reference 978645 do not appear in both weeks).
i have is that i want to use data from specific work sheets in another generic sheet, i have a list of names in the generic sheet and a lot of sheets titled by peoples names, i want excel to search for a sheet whose name corrisponds to the name in a cell on the generic sheet and copy from that individuals sheet a specific cell and put it in the generic sheet.
I am trying to search three columns on a worksheet, that contain a range of customers, product names and the amount of that product sold to the to the customer. On a separate worksheet I have created a table, which I hope will show the customer, the product and the amount sold. So basically I need either a formula or piece of code that can match the customer and product, along with the amount sold and display it in one table. The data is by nature not kept in alpha or numerical order and my problem lies in being able to search through each row and extrapolate the necessary figure.
I'm looking to do the following below: column A would have numbers, column B would have words and a few columns over i would have the total of each same word
column A column B 60house 120car 30misc 52.25food 83.33gashouse 180.25 120.25housecar 120 25miscmisc 55 105foodfood 157.25 50.5gasgas 133.83
I have two sets of data, and one colum in each set is titled ID numbers. I would like to search both those colums and combine the matching ID numbers in one row?
I have an excel spreadsheet where the columns have the 12 months of the year in Row 1. What I need is code that will find the month (from the column) which I select (via a listbox in a userform) and then go down that column and move the data that corresponds to that month to the userform.
So, If I select January from my userform, all data below January will then be moved to the userform and the same thing will occur with each month I select. I know how to move the data from the sheet to the userform, I just don't know how to match my data with the selected month.
I have a workbook whose worksheets use protection (don't want my calculations stomped on).
When the Protection is on, the search function does not work. You call it up, write what you are looking for, it accepts it, and then when you tell it to search it ignores you.
When you turn the protection off, the search function works just fine.
HOWEVER....Other workbooks I have with protection on its sheets do not share this problem, just this one workbook. And the problem is on all sheets in this workbook. The problem is not on any of the sheets in the other workbooks. I can't see anything different between them, but then I may not know what to look at.
I am fillin out a spread sheed with a num ber of codes. I want to create a excel formula that will look at the entire column and search for each of the codes. If I have forgotten to add one of the codes into the column I need the formula to let me know.
What I was thinking might work is this...
To look for one of the codes I would do this. =IF(MATCH("FLA",E5:E36,0)>0,TRUE,FALSE)
This works great if the Value is in there. If it is not in there I get #N/A instead of FALSE. Is there a way to get the MATCH to return another value if it is not found in the range?
Is there an easier way to look for multiple values? So far the only solution I have found is like this
For each value I need to look up I add another IF function. I have about 17 different values I need to look for. This makes for a ugly function but it seems to work.
I have been using the VLOOKUP function to search a table of data for a specific value in order to then give me the corresponding data associated with that value. I can do this and it works!!
However, as I am searching for names some people have more than one set of data and the VLOOKUP only finds either the first set of values (if the FALSE command is used for ‘range_lookup’) or the last set of values (if the TRUE command is used for ‘range_lookup’). I have attached a small example:
How can I get all values to be displayed?
I know that this may have been explained horrendously but I have written and re-written this several times and this is the best I can get!
i am trying to set up an interface through Excel for a database of record also held on excel. I have very very basic VB skills and have no idea what im doing lol but what i would like to do is have a search box and button, something similar as you would find on most websites. I would also like (if possible) for it to search up to 8 workbooks to look for a name or vaule.
I have a list of values in column A of sheet 2. What I would like Excel to do is search for each of these values on the whole of Sheet 1. Sheet 1 has around 20 columns of information and a dynamic number of rows.
In column B of Sheet 2, I’d like TRUE or FALSE displayed depending if the value is found on Sheet 1. For example
I am trying to create a sheet for invoicing. I have a sheet I want to use as a database. I want to search the database from the "invoice" sheet and fill the fields once i have found what I am looking for.
attached is a sample database I will use. I dont want to use the whole row, only selected colums. for example short_item description, item_number, Brand, SRP, ect. I want to search on the "invoice" sheet, for example, item description,and fill out the rest of the necessary fields in that row with data from my "database".
Concatenated cells. My issue is how do i search through a sheet with cell values that have been concatenated?
Lets take an example:
I would like to search for a string call sales in sheet1 which would display all the employees and schedules for that department (do note that employees can be part of not just one department). but my cell formatting is as follows:
Sheet 2, Column 1 Employee name
E.g. Row 2 Employee1
Sheet 2, Column 2 Department (cells concatenated)
E.g. Row 2 Sales, Marketing (Concatenated Cell)
Sheet 2, Column 3 Work schedule
E.g. Row 2 8 AM to 5 PM
So when you search for sales, it will display employee1 and work schedule.
I need to copy multiple rows in a spread sheet with a forloop. The problem is I only need a select few columns. A:C and F:H. When pasted into a new sheet I need to columns to come in A:F
I have a loop that does this already but it is huge and is slowing down my file. Here is part of it.
I want to search a longer text field for a shorter string that may be within it. However, I want to do this for multiple short strings.
For instance:
PhraseHidden word Please search the text for the hidden message: Blue The hidden word, Green, may be at any point And the word may be different lengths like Yellow
I have a table of the hidden words (Blue, Green, Yellow, Pink)
I know I could use search to find one word, but is there a way to look for multiple words, and return the value of which one it finds? I have many hidden words (and the list is dynamic) so I don't want to just split into multiple searches.
I need to do the following:I have multiple worksheets/ workbooks that hold user info such as address, country, first name,last name, ID,dob, gender, occupation etc I need to make a search dialog whereby the user is allowed to do this:
1-Search by ID by selecting thru the calendar tool OR
2- search by first and last name. When he clicks search, I need the particular worksheet holding the data to pop up and show the user the data that was requested for.All data in ID column is unique...but for first n last name, i have a few people who have identical names
i have a spreadsheet that i use for work which has 1 page that contains all the data for the workbook. on other pages i use this data, and tables, to pull information to those pages or other pages which complete my work in a more timely fashion.
that issue i'm having is when i try to look up specific values within the data page tables and there are multiple values.
i need a way to choose different values rather than the "first" value in the instance of a vlookup which only finds the first value.
in the pictures i have picture 1 (vlookup samples) has a section where i can type in the "office" code and it will auto pull "switch name" and "switch clli" via vloookup.
in picture 2 (switches sample) i have created a table, which is on another page as stated above, but if i try to search for the example "LSGT5" it only returns a switch name value of "LFTYINXFDS0" and there is also a value of "LFYTINXFDS1".
there are many more within the table(for this office code alone) but this is just an example of how i need a way to choose the proper one or somehow have a drop down without having to create a bunch of tables for each office itself.
I need to figure out a way to search for a string in column D and then paste the entire row that string is in to a new sheet. I'd like for this to continue until I paste all of the rows of that string into the next sheet. This is what I got so far, and when I run it, it says an error occurs and then it says either press enter or paste. After I hit enter, it pastes the first row to the next sheet, but that's it. Also should I be doing this with a button?
Code: Sub SearchForString() Dim LSearchRow As Integer Dim LCopyToRow As Integer
I'm trying to write a macro which will find members of an array on a sheet, highlight the column and then change the format of the column, what I have at the moment is:
I have a sheet named "original" with columns a, b, c. My code checks each cell in column C for a value and then copys columns A,B,C to a sheet named "Order". It works fine except I need it to start pasting the results in row 16 instead of row
Sub PLACEORDER() Dim lastrow_first As Long Dim lastrow_second As Long Dim x As Long lastrow_first = Sheets("ORIGINAL").Cells(Rows.Count, "C").End(xlUp).Row For x = 10 To lastrow_first If Sheets("ORIGINAL").Cells(x, 3) <> "" Or Not IsEmpty(Sheets("ORIGINAL").Cells(x, 3)) Then................
Use a referenced lookup value from sheet "A", to return values, from several columns in sheet "B"
Things to note:
a) The lookup values sometimes repeat. I need all the associated values with each repetition as well.
b) The lookup values in sheet "A" are a comprehensive list, sheet "B" also contains some of these values but not all. Essentially, what I need to do is find a way to lookup each value in an account numbers column in sheet "A", against a different account numbers column in sheet "B".
If that value occurs in sheet "B" I want it to return the values from Columns X, Y, Z, (I want these values returned in sheet "A".
If that value does not occur in sheet B, the corresponding cells should remain blank.
If the lookup value occurs multiple times, I need all the corresponding values from each of X, Y, Z columns.
