In sheet 1 of the workbook, have table like below
In Sheet 1 of the another workbook B , in a same folder...
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
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...
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 would like to create a point systems where I assign different points based on yes or no answers through a dropdown, i.e.
Yes = 2
No = 0
Yes = -1
No = 0
How can I do that?
Thanks in advance! :)
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...
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
May I know how is it possible to use "k" and "p" in a formula? Do I need to assign a value to them?
I'm trying to write a macro to allow users to change the colour of a selected tab on a protected worksheet.
• 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...
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...
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...
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...
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...
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
0 – 529...
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...
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%...
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...
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...