I have a single list of data that I am trying to convert into multiple lists. Here is a sample of what I have:
COL-A COL-B
1 Animals
2 Dogs
3 Bulldogs
4 Missy
4 Rex
4 Fred
3 Terriers...............
Hard to describe, but the 1 should have the 2's under it. Each 2 should have the 3's. Each 3 should have the 4's, etc... I am not sure how to put tables into this so I will try to draw a few.
The order of the columns do not matter. If anyone has any ideas how I could do this that would be great. The data is on seperate sheets. I would love to be able to do it with INDEX and MATCH
criteria, but a VBA solution would be acceptable.
I am trying to get the data that is produced on 15 sheets copied into column A as a continuous list (concatenated?) in a sheet called "Keywords". I have tabs labeled Output-1 through to Output-15 comprising of column A in each ( No headers ). Each tab/column will have similar data but of variable size, some may even have no data at all. (the data is updated/pulled into each column using a different formula on each row)
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.
I am trying to setup a file that has three tabs - LIST, COLOR AND PLANT.
I want to be able to select a color or colors (red, blue, yellow, green) and a plant or plants (tree, shrub, flower, grass) using radio buttons, maybe?
If i chose red and blue for a color and chose tree, shrub and grass for plants, i would like to populate the LIST tab with these items.
I'd also like to give an associated value to each color and plant. for example, for the colors, i could choose values between 1, 2 and 3. if i chose red 1, it would add "red 1" to the LIST. if i wanted to later change it to 3, i could do that on the COLOR tab and the LIST tab would update automatically.
I am trying to automatically construct a unique consolidated lists from several other lists. I want this to be formulated in such a way that the mother list is uptodate and reflect all changes made to the subsidiary lists. I have attached an example of what I am trying to achieve.
I have a long list of 2 columns containing data as follows: country1 date1-1 country1 date1-2 country1 date1-3 country2 date2-1 country2 date2-2 country3 date3-1 country4 date4-1 country4 date4-2 country4 date4-3
which I would need to move to get one column per country with the top cell the country name and below each name all the related dates, e.g. country1 country2 country3 country4 date1-1 date2-1 date3-1 date4-1 etc. date2-1 date2-2 date3-1
I have searched and found almost similar questions and tried to apply it to this case, but not being versed in VBA it was a failure on my part
I typically use the following formula to create a list with no blanks, when I have a single column of data. Is there a way to do the same thing when you have multiple columns of data (side by side to make it simple) and you want to create a master list that gets rid of the blanks, and keeps them in the order they appear (by column)?
[Code] .....
For example, if I had data (with some blank cells randomly placed) in columns AM and AN, and I wanted a singe master list in one column of all non-blank cells in column AL, followed by column AM, etc.? Is there a formula to do this, or must I resort to a macro?
Col L John Doe New York Past Locations Previous Jobs Male Previous Schools
In Sheet 2, I have another list where the user will manually enter sub elements for some of the elements of Sheet1. It looks like this...
Column A |Column B |Column C Past Locations|Previous Jobs|Previous Schools
Below that last row of headers, the user will make inputs. the list for each column should be able to run down to say 100. The inputs may look like this....
AZ |Plumber |XYZ Elementary MD |Waiter |ABC High School IL CA
Now, the problem is I need to combine these two into a single column in Sheet 3 in a special way. The output would look like this.
John Doe New York Past Locations AZ MD
[Code] .....
Notice that I am taking the list in Sheet 1 as is, until i run into a value that is the header in Sheet 2, in which case I take all the contents of that header column until I am done, and then go back to sheet one, and repeat the process. I need the output in one column in Sheet 3; i don't need any special formatting.
Find Multiple instances of Numeric Criterion in Row & Return To a Single Column.
I have a Dynamic Named Range "Data" spanning 10 Columns and many Rows. Each Row may contain duplicates of the Numeric Criterion.
I would like to find ALL instances of a specific Numeric Criterion across each single Row in the Dynamic Range "Data" and have the Results returned to a New Sheet in a single column.
NEW Sheet: The Numeric Criterion is housed in G5. The matched criterion should be returned to the New Sheet starting at G7. Duplicate instances in the same Row should ALL be returned to the same cell in Column G on the New Sheet.
Sample Data Layout: Columns I J K L M N O P Q R Row No.76 1 0 1 1 0 1 1 1 0 1 Row No.77 2 2 3 2 1 2 2 0 0 0 Row No.78 3 3 3 3 3 0 3 0 3 0
Scenario: Looking for Numeric Criterion 1 (one).
Expected Results - New Sheet: Row No.7 Column G (Cell G7) 1111111 Row No.8 Column G (Cell G8) 1
In Row 76 of the Sample Data ALL seven Numeric Criterion of 1 (one) should be returned to the same cell G7. In Row 77 of the Sample Data there is only one Numeric Criterion of 1 and it should be returned to cell G8.
Excel 2003. I have created an Excel purchase order form that has several drop-down lists that work just fine. However, I have yet to figure out how to change the font size and be able to use such things as BOLD, etc...even when I format the source data list. I can format everything else in the form...except how the drop-down list data is displayed.
Is there a way to create a drop down list from a comma delimited list in a single cell? For example, col A is Name & Col B is the delimited list - Blue,Red,Green (list can be different for each name). Would like a drop down list in col C that allows you to pick one of the values from Col B.
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...
I have been having alot of trouble and have read alot. I can't seem to figure out the problem. I am currently working on an excel sheet that will select a name from the first drop down list. Based on that name five other list will be generated just on the first selection.
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.
i have consolidates five paired lists on same worksheet into a new list? Each pair of columns (First Column (Acct #) and Second Column (Day N Count)) contains numbers and the range of data in each column and/or row will be unknown each week, so need the formula to auto adjust. New list should have this format:......
I have a set of unique customer names in a column A, say A1 to A200 in my data sheet. These customers have route numbers assigned to them (defined by the client) column B - B1 to B200. The route no.s are 1,2,3,4,5,6,7, & 8. The column lists can be of varying lengths but no more than 500 rows. I want to relate the routes to 8 separate sheets in the workbook. In each sheet I want to extract a column of customers based on the route number. So if the first customer in column A is route '1' (column B) it populates the first entry in sheet 'Route 1' with the customer name as so on for the rest of the sheets.
i want to extract the date from the two lists mentioned above in on list start from c2 taking in consideration the dates to be in sorting from A-Z when it extracted in the one list
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?
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
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
I have Columns A:D with a heading at the top. the user can then type organisation names under the correct column. There is a maximum of 30 entries (rows 2:32).
Problem One: Column E is a hidden column and I need cells E2 and downwards to be a list which gets populated by ALL the organisation names inserted into $A$2:$D$32. I don't want there to be any blank cells until the last entry in column E (if that makes sense). how to populate this list?
Problem Two: At another part of the worksheet, I have five cell where the user has to select from a list. The five cells correspond to the lists in columns A:E. Is there any way to avoid having blank options in a list using data validation (say if the user has not entered 30 organisations into one of the columns)?
I have worked on the excel sheet Test.xls(Attached) to create a simple uniform order form. Unfortunately, I am not able to get through the 3rd column. Let me explain. 3 Columns references below 3 steps
1. I selected the first dropdown item and selected the item
2. Corresponding value is shown based on the first choice.
3. This value or drop-down is not shown.
In my main "LISTS" sheet, I have items that include one of the item for example... Blue Socks & Shoes with characters "&" and spaces.
All this could be solved if I maintain the following idea.
1. Have the main list without spaces.
2. The corresponding heading is related to the items in the main list (without spaces).
3. Enter the Headings for the sublists and sub-sub lists without any spaces.
Great..I am getting lost with this..Can anyone help me.
You will get more clearer once you see the attachment.
I work for a printing company that prints labels. We have 6 printing presses, lets call them A,B,C,D,E & F. Certain labels can only be printed on printing press F.
From our business system I can run a report in excel format giving details of all the labels that we have sold in the present month. I need split that report into 2 separate excel spreadsheets; 1 showing everything that was printed on presses A to E and the other showing everything printed on press F.
I also have another excel spreadsheet which gives a complete list of all the labels that have to be printed on press F.
Every label that we print has a part code and both spreadsheets show this part code so that would be the linking factor between the 2 sheets.
