multiple value

I have ~50,000 usernames in Column A on Sheet1. Many of those usernames repeat. On Sheet2, I have the same usernames in Column A, followed by their employee IDs in Column B. But on Sheet2, there are no repeats. I want to copy over the IDs from Sheet2 into the corresponding place in Sheet1...

I have 7 sheets. On each sheet the user can select an item from a list and write a description in the column next to it. The item can be selected multiple times on the same sheet with a different description written in the column next to it. I need a summary page where it lists the entered...

<colgroup><col><col><col><col><col><col></colgroup><tbody> Hi, I am having a issue with Index/Match. I am trying to quality check some input. B/C is the correct data in my main sheet, but I need to verify that the input from another sheet is correct E/F. In column D i use the formula...

Hi! I have this code deleting all rows that do not contain the text "A#ABN" in column A. However, I also need to keep rows containing the value "A#UUW" also. Single delete works perfectly, but I struggle when adding more criteria. I´ve tried different versions of code two, but still noting:(...

Hi, I'm having some trouble trying to make something that will add a number for every 3 cells down a column. It would look something like this, but would continue for about 93000 cells so I really need a formula to do this. <tbody> 1 1 1 2 2 2 3 3 3 4 4 4 etc...

Hi mrexcel forum community, I'm a newcomer what comes to VBA and would greatly appreciate your tips and help on how to solve my problem. If I've understood correctly, goal seek with input from multiple values and worksheets require VBA code. The parameters: Cell C39 in Sheet 1 (value) Cell...

Hi everyone, Hope someone can help me with this ... I'm trying to work out how to do what is displayed in the image below. The table (cells C9:AB28) are all COUNTIFS based on data on a different worksheet (see the 2nd image below) in the same workbook and when the user clicks on one of the cells...

Hello all, I have a Gradebook where I enter the number of points a student earns per question on a test. The students names are in the first column and then their points follow. I have other columns such as total points, percentage, letter grade that follow but they are not part of my issue...

I'm having trouble figuring out how to pull together a top 5/bottom 5 list, given the way the data is provided. The source data is pulled from an existing macro, which I dare not alter, so that is unavoidable. Basically, I am trying to pull the names (column A) and sale amounts (column B)...

Data <TBODY> 10/01/12</SPAN> 2000</SPAN> 3000</SPAN> 4000</SPAN> 5000</SPAN> 6000</SPAN> 1A</SPAN> 1.00 </SPAN> 2A</SPAN> 2.00 </SPAN> 3A</SPAN> 3.00 </SPAN> 4A</SPAN> 4.00 </SPAN> 5A</SPAN> 5.00...

I have two sheets. First sheet (Data) contains data of all the SKUs that i carry in my store. Second sheet (Output) should organize by StyleID and output all Color and Default Image associated with StyleID. Multiple values of Color and Default Image need to be outputted as comma delimited...