successful

Dears I need your help My data is as follow <tbody> Name Status Pro1 Successful Pro1 Failed Pro2 Failed Pro2 Failed Pro3 Successful Pro3 Successful Pro4 Successful </tbody> And what I want is retrieve the names without duplication and this criteria for the status <tbody> If...

<tbody> Colleague TEAM Course id 123 Course id 124 Course id 125 Course id 126 Course id 127 Course id 128 Colleague 1 TEAM A Successful Successful Successful Successful Successful Successful Colleague 2 TEAM B In Progress In Progress Not Registered Successful...

I have some sample data below and I want to write a code that will delete anything in a specific range of columns if it has a specific parameter in the AC column. For example, if "REMOVE" is in AC2 and AC3, I want to delete cells V2:AC3 and shift the remaining data up. The amount of rows...

Good afternoon! I'm attempting to create a formula that will tell me the location where specific data was found. The issue: There are 52 worksheets, and data can be found on more than 1 sheet. So far, I have been successful in Counting the number of times the specific data was found using...

I have a Excel workbook that I am 99% complete on. The steps it performs are: Opens PPT (successful) Creates Presentation in Normal View (Successful) Creates Slide (Successful) Copies Range from Active (1st) Sheet (successful) Pastes range from (1st) sheet to slide 1 (successful) Cycles to...

Hi there! I have created a login screen for users, and installed a VBA code to notify them of a successful or unsuccessful login (with the click of a button). From a successful login, I would like Access to default to a specified form to add new records. What code would I use? Do I enter the...

Hi All, I have been trying to fix the below syntax for hours but not successful at all. Could someone please help me? Midmonthworkday=application.Workday(Application.Date(Year(Date),Application.month(date),14),1) Your help is very much appreciated!!!

Hi! How would I use Vlookup, when referring to another sheet? I need a formula to show: - IF the serial number (E from sheet 1) is found in the sheet DUP (range - G1:J201) >>>> then return the right action (E.g. delete, Good, etc), depending on IF the ERASURE is blank, successful or failed...

Hi all! I'm having trouble figuring out how to differentiate duplicates serials, using cell formulas. Link to file: https://1drv.ms/x/s!ArRB1Ah3M1ZqgpkM7iAAPtt5I9FNvg - For all INSPECT items, (FOR A SERIAL) , a comment will be inserted in the ACTION 2 column ... following the below behaviour...

Good Afternoon All, Question? How can I fill in cells from a named group that is selected from either a drop list or combo box. Here is the code. I tried using the Macro record function but was not successful. I have 7 different names that can be selected from the list. Also there are 7...

If I have data like this, pre-pivoted: <tbody> ID Q1 Q2 Group 1 Explore Not at all 1 2 Personal Somewhat 1 3 Take Very 1 4 Obtain Very 1 5 Obtain Very 1 6 Take Not at all 1 7 Personal Sucessful 1 8 Improve Successful 1 9 Obtain Very successful 1 10 Obtain Not at all 2...

Hi! I'm not sure how to go about solving this - but I need to do an analysis using excel charts to assess if there is a trend between the performance of a list of managers handling their team of staff who are ranked either successful / unsuccessful vs the frequency of their attempts. So my...

I need a macro that will look at column A and if it's blank AND column B is NOT empty, then it will return value of "OFFICE". I need this to go to the last row. I tired to modify existing ones I found on the internet, but I was not successful. Thanks.

I need to add a set of instructions to my Microsoft Excel Workbook. I was going to try and do it by just adding text to cells but that is not very user friendly. I tried to embed a PDF file but was not successful. I would like some recommendations or suggestions for how you handle this task...

Hello All, Ive been trying a few things in other threads, but just cant seem to get this working. I have specific conditions that need to be counted per month. <tbody> ID Reason Timing Date <tbody> CRQ145074 </tbody> <tbody> Successful </tbody> <tbody> Standard </tbody>...

Hello, I am attempting to create a macro that deletes a wide range of data in a table and copies and pastes new information in to that area that is taken from a source file. However, I am having trouble adjusting both more and less data. I first figured out various test with the lastrow/Range...

Hi all, I'm just learning VBA, so I'm struggling with finding the column header "location" and then inserting a column to the right with a column header "radius." I would like to make this so that it loops through all of the worksheets in the workbook. 1-- Function loops through all...

Hi all, I was playing with VBA in MS Word. I have log files from a device and I want to insert a few TAB in each line in order to insert them to excel. Anyway, the whole thing was successful. However, I have a question. Take a look at the following picture. At the bottom lines, the last...