populate

How can one populate one listbox with the list from another listbox?

So I am trying get a range to populate based on the selection in a single cell. So in the pic below, i have two types of projects. Admine Projects and IT Projects. They have different cost categories listed in column A and B. Cell D2 is a data validation where you can select either "Admine...

I have an excel calendar (Sunday-B1 through Monday-H1). Each day has four horizontal cells in to allow for several entries. For example, Wednesday the 1st uses E2-E5, Thursday is F2-F5. The next Wednesday would be E6-E9 and so on. In those cells, I have names of meetings. What I would like to do...

i have a text file that contains a list of file paths, how possible is it to populate the listbox with the file paths in a reverse range and that the listbox will show only the file name while the path to the file may be hidden in another column, so that i can use workbooks.open listbox1.value...

Good Day I am using 2 User Access forms which are called User form and Userform 1 and Userform 4 and respectively. I have one List Box. I would like to certain information to appear on Useform4 from the List Box. Thanks

I'm trying to take a snapshot of 10,000 different stock quotes using my brokerage's RTD API, *but* they limit me to 500 concurrent requests at any one time. If I exceed that, then I get booted / the API connection gets blocked. So my inelegant-but-probably-simple-solution (that I need help...

Hello again and thanks to anyone who reads this. (Excel 2016) I have a simple userform with 2 combobox's and a command button. The Userform is called from a button on a spreadsheet. The issue is that the combobox's do not populate on the first call. I have to close the UF and then reopen it...

I need a formula for cell Q8 that looks at cell E8. If E8 ispopulated, place an x in cell Q8. If itmakes a difference, cell E8 has a formula that reads from another tab withinthe same spreadsheet. Thanks in advance

I'm creating a scoresheet and I have a cell that will total the score, but I have other cells that I want to list how many points were scored in each quarter. So in the table below, E3 will have the total score of the game. After the first quarter, I want E3 to populate A1 and then stay. After...

Hello. I'm not 100% sure if what I'm trying to achieve is possible in the way that I'm trying to do it, but any guidance on how to start would be much appreciated. Basically my goal is to create a workflow chart to standardize the tasks for specific processes. I have the column "Tasks" B:B...

Hi there I have some imput data sheets that will be filtered by country. Using what's filtered, I need to populate that info into other sheets. At the moment, I am using VBA to populate one column, then within that sheet, I am just doing vlookups but I wonder if there is a better way to do...

I'm going to try asking my question again as I can't come up with a faster solution for my code. Ill attach a sample of the excel sheet. <colgroup><col><col><col><col></colgroup><tbody> Period Backlog at the start of the month Volume Receive during the month Incident Completed during the month...

If G8 is populated with x, I need K8, O8, S8, W8 and AA8 each to populate with x. I also need to be able to drag the formula down to rows 9, 10, etc. Thank you in advance

Hi, Bit lost with this. I have a column L whose cells contain the dropdown options Almost Certain (5) Likely (4) Possible (3) Unlikely (2) Rare/Remote (1) Based on what is selected in column L, I want the corresponding cell dropdown list in column M to populate using following rules - If L...

Hi Everyone, I'm wondering if there is a way to populate a DLookup in a cell based on the population of another cell in the same row? For example, Cell D2 is populated with a Scan as text. When that happens I would like to populate cell H2 with the formula below and then repeat that in each row...

I have a Years of Service column calculating correctly, I also have another column that will populate each row with "10 YRS" "15 YRS" "20 YRS" and "25 YRS" if applicable by comparing 10years 0 months etc. A user wants the column to populate for the entire 12 months of the milestone anniversary...

Hi All, I have attached a link to the spreadsheet I am referring to:- https://www.dropbox.com/s/i5lvozes381hj18/Test%20Scan%20Mr.Excel.xlsm?dl=0 If the part from A1 "XPGLIDE" matches F3 then I want N3 to populate the same as A3, but the rest of K3 through to Z3 to return Zero. Similar if A1...

Is there a formula for extracting certain words/phrases in a cell no matter where they appear in the cell? For example, I need to know if the cell has Not Needed, Need Created, Not Created and populate the result in the cell when found. Any help would be appreciated

Hi All, I am by no means great with Excel, which is why I came to ask you fine people. I'm trying to create a reference tally sheet for my library so that we can stop using pen/paper. I've got the buttons to go up and down by increments of 1 on my first sheet, but I'm having trouble beyond...

Hello, I have a sheet that has a number of three column groupings. In each -- The first column is people's names. The second column is a range of numbers that also includes N/A (i.e. N/A, 1, 2, 3, 4... 20) The third column has another number. I have another sheet that has two columns: Name and...