lists

Hi there, I have a spreadsheet where multiple sheets are maintained by different users, however the layout of each is identical. I'd like to create a sheet which pulls all of the lists into one large list, without any blanks. I'd like this large list to always reflect the latest updates to...

Hi How many classes in excel vba? is there any site/doc that lists all these classes. Thank you.

Need help. I am trying to create a userform that has (Currently) four dropdown lists but I am having issues once I add the third and fourth list. In Excel I created a name for each list of items to be used i the dropdown lists (i.e. List Name - Eye for a list of eye colors and Name - Hair for...

Hi I know this has been covered a few times and people have posted replies, from which I copied and amended some code which first worked and now does not for some reason. Can anyone help? I have 4 column dependency lists with info in G4, H4, I4 and I4, If any changes are made to G4 I want all...

Hey guys, I'm not great at excel so maybe one of you can offer me a hand. So I have a list of items on a sheet in column A (about 20,000 of them). In column B I want to input the unit prices for each item, but I don't want to scroll down and find the item to input it. There's 2 possible...

I have cross posted this on excelforums.com. https://www.excelforum.com/excel-programming-vba-macros/1236590-loop-through-a-data-validations-list-and-for-each-loop-count-the-number-of-occurences.html I found this thread and I think this is what I need and if someone could help me adapt it...

Hi, I am looking to use VBA so that I can use autocomplete when using data validation lists, I came across this solution: http://www.contextures.com/xlDataVal10.html which works perfectly for normal validation lists. However when I change my list from a standard list to using an offset...

Hi - I have a list of all certain census tracts in one column/workbook. On another workbook I have another list of census tracts, some duplicates, that may or may not exist on the first list. I am trying to identify the ones that are on both lists. VLOOKUP/MATCH don't seem to work. Maybe because...

Hi all , following is the structure for combo box on webpage from which i want to select an element .The html structure follows like this (cant post original due to security issues) Div tag Ul tag Li tag Li tag Ul tag closed Div tag closed I have tried it by fetching all the ul tags in...

I'm trying to find a way to use excel to compare two excel exports from two different software programs to find out if both are the same. The order of the two lists are different and it takes too much time to go through them to tic off each one until I've reached the end. Any suggestions would...

Hi, I have 3 different lists that can vary in rows dependant on formulas an I am looking to have one list with the contents of the first list, then straight after that, the second list, the straight after the third list Each list has Column A, ID number Column B, Name Column E, ID number...

I have two similarly formatted lists on different worksheets in the same workbook. List A is my master list. List B, which changes weekly, has some values that exist on List A along with completely new values. Each list has about 2,300 rows. I must compare these two lists and find the new...

Hi, I have been working on a VBA code for the last week or so and can get about 5% away from the result that I require. I have 2 worksheets: Sheet1 - which has a list of data in E:E Sheet2 - which has a list of data in G2:G Both lists have matching values in the list. What I am trying to do...

I would like to combine several lists (each their own named range) into a master list. Each list has the same number of columns but vary in length - 4. The named range may also have some blank rows in them and I don't want to bring those over to the master list. Is it possible to do this...

Hi, I have a payroll spreadsheet and we have had instances where employees have not been processed for a week because they have been on holiday and so have not submitted a timesheet. I therefore want to put in some code to run when the workbook is shut to check if all the names in the 'Lists'...

Hi i have a userform with 3 drop down boxes, i want to colate the date from 2 different sheets i have used the code below but i keep getting an error, please can you help, the ComboBox1 and CARRBox the data is collected from the same sheet (IN DAY LISTS) but for MTBox the data is another sheet...

Hello, Sorry if this has been asked before - my forum search did not find it. Using Excel 2007, I have a worksheet with about 30 lists (30 columns). Each list is defined as: =Lists!$A$1:INDEX(Lists!$A:$A,COUNTA(Lists!$A:$A)) =Lists!$B$1:INDEX(Lists!$B:$B,COUNTA(Lists!$B:$B))...

Hello Everyone, I am having difficulty in identifying and highlighting exact number matches between two lists. If this questions has answered could someone point me to the appropriate forum post ? Thank you everyone for your time...

Hello, I need urgent help with Excel list. I am trying to create a plan for a prom. I have created a list of 3 venues that somebody can chose and then I want the price of each venue change when the selection on the list is changed. Please help!

Howdy Everyone So I am really scratching my head here, I have tried everything and just cannot get it right I have two large lists List1 and List2, can I compare a column in each list and if there is a match it should display a column from within list two? Thank you in advance