assign

  1. Z

    macros and slicers

    hello, i would like to know if i can assign a macro to excel slicer or not and if yes how. the reason is i need to change value based on selection of slicer like from quantity to amount or percentage.
  2. G

    Assign Procedure/s to VB editor toolbar commands

    Hello, Is that possible to assign macro procedure to a toolbar control (within the VB editor not on Worksheet)? https://i.imgur.com/pjbyXJe.jpg Thanks, Giorgi
  3. C

    Assigning work to people by day

    Good afternoon, I download a spreadsheet once a month that contains workorders for a given department. The workorders are divided up by responsibility and by the activity code. We then assign the correct employee and shift to the workorder (manually right now). In Power query I have the table...
  4. Y

    Randomly assign x number of students to x number of workshops where students do not meet the same co-student

    Dear all I'm familiar with basic Excel functions but when it somes to solving this specific need I dont have a clue of how to fix it. I have search the internet and I have found plenty of examples where I can assign people on a list to a number of groups. But I need a twist to that :-) I have...
  5. J

    Assign numerical points based on dropdown text values?

    Hi! I would like to create a point systems where I assign different points based on yes or no answers through a dropdown, i.e. Question 1: Yes = 2 No = 0 Question 2: Yes = -1 No = 0 etc... How can I do that? Thanks in advance! :)
  6. N

    Extracting/transposing data from a delimited text string

    Hi all - I have a delimited string of numbers/letters in one cell that I am trying to transpose into another set of cells(the string could be something like "A, B, 179, C") Normally I would just use the split function in VBA, break this into an array and assign each cell I want to insert into...
  7. R

    Letter in a Formula

    Hi, I copied a formula and transfer it to my worksheet. However, it returns an "N/A" unlike from where I copied it from is working. Below is the formula =(1+F7/k)^(k/p)-1 May I know how is it possible to use "k" and "p" in a formula? Do I need to assign a value to them?
  8. S

    VBA to change tab colour using the palette

    Hi folks, I'm trying to write a macro to allow users to change the colour of a selected tab on a protected worksheet. My plan: • Use an input box to get the tab name from the user and assign it to a variable • Present the user with the colour palette to select the colour (standard or custom) and...
  9. P

    Loop until empty

    Hello, I have a list in column A in an Excel workbook called "Pipe Sizes". I want workbook "template" to read A2 and assign "job no" to value in A2. Run "start" macro. At end of "start" macro, assign "job no" to value in A3 and run "start" macro. So on so forth until it hits an empty cell...
  10. C

    VBA Employee Time Punch

    Hi all, I am trying to develop a time punch userform where my people only need to click the buttons to log in and out. And I want to track it daily. My work is in progress. Please see attached 3 sheets. And now I am so stuck...
  11. I

    From Personal.xlsb, set .onaction macro to a macro in a worksheet in a differert workbook.

    From personal.xlsb, I am trying to create a button in the calling workbook and assign a macro that exists in one of the worksheet in the calling workbook. All of the combinations I have don't produce a macro that is correctly defined. I thought this was going to work since this is exactly how...
  12. K

    Beginner help - making class assignment

    Hi, I feel there should be a way to automate this, I'm just not seeing it. I have a list of participants, each have chosen 5 out of 8 possible classes. Classes are offered multiple times over 2 days, 4 classes at a time. I have the class times and schedule. My goal is to assign 'students' to...
  13. B

    Assign Code to Numbers

    I have an excel Sheet with Column A containing the ANSZIC Code - Ranging from 0 to 9999 There are millions of records and i wanna a assign a code to classify these Numbers as Follows Ex For Numbers FROM 0-529 it must be assigned A, and like wise <colgroup><col><col></colgroup><tbody> 0 – 529...
  14. E

    macro to copy sheet with button and macro

    Hi I have a macro that is used to loop and copy a worksheet to another new workbook and name it as a different name. The problem is that the worksheet I am copying contains "buttons" with "assign macro" inside. So when I copy to a new workbook and save it as a different name the macro is not...
  15. J

    Macro assigned to bottom

    Have a bottom in my workbook. I want to identify which macro has been assigned to the bottom. I right click it and say assign macro....however this is not the macro which is assigned to the buttom...
  16. A

    Random value assign with weightage

    I have a sample size of 30. I need an excel function in which I can assign " Random Values " (say a question has 4 options and need to assign 1 to 4 randomly) based on the weight to each individual from the sample. Means Option 1: 45% Option 2: 12% Option 3: 30%...
  17. T

    Assigning a Macro to a Control

    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...
  18. V

    Duplicate rows for vlookup multiple values

    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...
  19. M

    Assign numbers in block of 10 starting from lower to higher

    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...
  20. X

    Excel partial match from unequal columns and assign value to new column.

    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...

Some videos you may like

This Week's Hot Topics

Top