assign

I am working with Form buttons and assigning macros to the buttons. When I first create a button, I can easily assign a macro by selecting Assign Macro from the shortcut menu. If I want to change the macro assigned to a button, or assign it after I have renamed the button, I cannot for the life...

Hey guys, I'm importing a sheet and doing a vlookup to assign values as vlookup works, however, if the vlookup is finding values to assign, I need to duplicate the row to which the value must be assigned to as many times as what there are rows for those values. Would anyone know how to do this...

Hello,</SPAN></SPAN> In the column "D" I got the numbers disordered, they can be from 0 to 3000 max. </SPAN></SPAN> I need to assign them in column "E" in blocks of 10 (1-10, 11-20...etc.) starting from lower to higher as per example shown below.</SPAN></SPAN> <COLGROUP><COL...

I want to assign a category to a table so that I can eventually create a pivot table. I need to do a partial match to get my category values. "num" i want to match to "number 111" and "numeric 321" and then assign both of those as category1. "form" i want to match to "Form 1" and "formula" as...

Hello everybody! (HI DR. NICK!) I'm after a semi-intelligent automated solution to a manual task one of our directors does, he goes through a list of 1,000 clients each week and assigns a brand to them based off a bunch of variables and calculations he performs -imperfectly- on the spot. On...

I have a cell containing today's date and formatted as 14 mars 2019. When assigning this value to a variable, it returns as 3/14/19. How do I get excel to assign the proper value? DateToday = Cells(4, 4).Value

I have a large dataset (almost 300K rows) with multiple years of information (2003-2016). I'm trying to assign size into a Small, Medium, and Large category by year. My first attempt was to determine the quartiles then manually assign the size to a category but I'm sure there is a more efficient...

Hi, I'm trying to create a dropdown that show a text value e.g. High but has a value associated to it so I can calculate it. https://we.tl/t-GCnCPTCPcA Thanks Matt

Is there a way in a new column to group people in groups of 9? The first 9 people would be in group 1, next 9 people would be in group 2, etc? <tbody> Person 1 1 Person 2 1 Person 3 1 Person 4 1 Person 5 1 Person 6 1 Person 7 1 Person 8 1 Person 9 1 Person 10 2...

Is there a way to assign a date to when a sheet updates information from another sheet?

Hi All, I have a sheet where i have a column with mix of Letters & numbers. in another column I want to assign a number to the letter (in this instance it is an "R" & i want to give this a value of 1) & i want to increase the values of the occupied cells by one. So i want to change a 1 to a two...

I have a csv export (which I have no control over) that has 5 columns. I need to look at the text in column A to decide which one of 5 mills that is to be assigned to. The columns have text strings such as “210060T25X1” In this case I need to assign “5X1” to mill 5. Once I assign a row to a...

Hi All, I have repeated text values in column A, I want a formula that should give the first set of same text values 1, the second group 2 and so on. For example; column a first five cell contain Apple so the formula in the corresponding cell will assign number 1,1,1,1,1 and to the second set...

Hello experts, as I did not find solution anywhere and dont know how to solve it myself, I would like to ask you for help :-( I have sheet (for example sheet1), on that sheet I have Frame(Active X controls), inside this frame is button and I dont know, how to assign macro to this button...

I have some code where I assign values to variables: 'assign values to variables Combo = Worksheets("Home").Range("Y5") LastRow = Worksheets(Combo).Cells(Rows.Count, "A").End(xlUp).Row + 1 'number of first empty row in column A of Combo...

Hi All, I am sure this is fundamental but I just don't understand why. I have a userform with a combobox and a listbox. I can add items to the listbox no problem but I wanted to be able to delete from the listbox. If I assign the following macro to a button then it works fine. However, when I...

I have a lookup table that looks like the table below. It is truncated and masked to simplify the problem, but the logic will be the same. <tbody> ID CODE REASSIGN(CODE) W12-05 AA ZZ W12-05 BB ZZ W14-01 CC CC W14-03 AA AA W15-01 DD DD W15-01 DD DD </tbody> ID and CODE are...

Hi, I've been working on a formula for this for a while but haven't been able to crack it, any help appreciated. The data I have is peoples ages, and I want a formula to be able to take the age and automatically assign it to the correct age band. So I need to combine the following into one...

What I am trying to do is assign all cells in a range a hyperlink defined by the content of each cell in the range, i.e the hyperlink of A1 is the value of A1. Public Sub Test() Dim a1 As Range Dim b1 As Range Set a1 = Range(Sheets("sheet1").Cells(i, 2), Sheets("sheet1").Cells(i, 5)) For i = 1...

I am trying to assign a variable to a range define using the cells command. what I have is this: Dim a1 As Range Set a1 = Range(Sheets("sheet1").Cells(i, 2), Cells(i, 5)) It does not seem to work. Thank you