1. M

    value mapping and assign names based on the cell value-vba

    In sheet 1 of the workbook, have table like below Class Creater Assigne Python Johny Sheela Cloud Dan Angela Microsoft Manny Andrea Embedded Mala scotty Pearl Dan Angela Flash Johny Sheela In Sheet 1 of the another workbook B , in a same folder...
  2. M

    cell value mapping to another cell from sheet in VBA

    Names Output Arul CS Mala CS Shan CS Selv SW Mani SW Muthu SW I need to find the count of Column A .Examples Column A have count of 6 in worksheet. I need to divide the count of column A and assisgn the work between two names based on the another sheet Assisgn CS SW...
  3. 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.
  4. 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)? Thanks, Giorgi
  5. 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...
  6. 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...
  7. 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! :)
  8. 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...
  9. 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?
  10. sparky2205

    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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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%...
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back