man

Hi goodmorning, I hope you can help, I have tried conditional formatting but it doesn’twork in the way I want it to, I hope you can help me with the vba code for it. I have row Nthat if ‘Yes’ or ‘No’ is highlighted from a list then I want the column to begreen if yes and red if no. Then in RowB...

So I'm really new to VBA and have been looking everywhere for a solution to my problem. Here's what I've come up with this far. I'm sure there's a much easier way to do it, but since every section is for a different sheet and each sheet will be different on a day to day basis I don't see how...

I have the following VBA Code Snippet and I've trying to learn how to use the Cells object. How would I replace the Activecell object with the Cells object in the Do Loop? In this instance, the Active cell would be Cells(2,2). What confuses me is how to replace the activecell object with...

I have a table rows: salesman sales date (mm/dd/yyyy) for many years of sales I am trying to isolate total number of sales of each salesman by month and day (excluding year) excel dates are giving me fits example: salesman sales date man1 2 5/1/2018 man 2 3 5/2/2018...

Hello. In my case I have 2 rows and all columns are affected. The 2 rows are Row 2 and Row 3.What I want is that whenever cell A2 contains "MAN", then cell A3 changes to yellow. Then similarly, whenever cell B2 contains "MAN",then cell B3 changes to yellow. So the cells in row 3 will change...

Hi all, Apologies for just dropping in to ask a question but I'm not a programmer by trade and my knowledge of the fundamentals clearly isn't good enough! So I've got a table with the correct line manager for each person but the data that sits on the Exchange server is incorrect. I'm...

I have the below code in Sheet1; Cells(lastRow + 10, "R").FormulaR1C1 = "=R[-4]C+R[-4]C[-3]" How can I adjust this such that; - If cell F1 in the 'Man' worksheet = 1 then Cells(lastRow + 10, "R").FormulaR1C1 = "=R[-4]C+R[-4]C[-3]" - If cell F1 in the 'Man' worksheet <> 1 then...

Hi I have the code below where I am trying to count words located in column H, I used the code below but it doesn't count anything just comes up with (0), can you help me please with this? any help will be greatly appreciated. =COUNTIFS(Northants!H:H,"2 man ladder...

I need to extract names from a text string but they are variable in length. See example below: PETER PAN PO LLL555555D AUB-1111111 2/27/10 1079.65 1012348 SUPERHERO MAN GGG444444C AUB-0000000 8/02/10 108.00 704546 SUPERHERO WOMAN PO GSS011111F AUB-1111111 3/13/10 11.26 1028549 The names I am...

Hi guys, I have this book I'm working on called AZ Claim Database. Randomly (does not occur every save) it will tell me this: Sooo I press continue and rename it "AZ Claim Database 2"... This isn't making much sense to me. Does anyone have any clue as to why it would do this? It's...

I have a table like the below, trying to find top 5 attendances using LARGE then INDEX/MATCH The issue I have is that in GameWeek1, two teams have the same attendance therefore the INDEX/MATCH brings the first one back twice. For example, in G1:G5 I have the numbers 1 to 5. In H1:H5 I have...

Hi, I have a pivot table which gives me exactly what I need until being asked with summing up the Cost variable by the JD Variable. The table below, variable Total Job Cost, has been hard coded to hopefully help give an understanding of that it is I am after. Any idea how I can create this...

Need macro to copy these specific cells to new file. Every file in the folder has same sheets. Sheet name: "16 Man Bracket" Cells that need to be copied from "16 Man Bracket" are: AX20 thru AX25 Sheet name: "32 Man Bracket" Cells that need to be copied from "32 Man Bracket" are: BJ26 thru BJ31...

Hi all, I have a table containing receipt (Column A) amount (Column B) description (Column C). The most important thing is that the receipt multi receipt numbers but by description cloumn we can identyfy as if one receipt # used to purchase chair it won't be use to purchase chair again...

Hi guys, For the best part of 6 years I have toiled with updating 2 spreadsheets (one for manchester united football club's league games and one for their cup games). I receive scores from email and whatsapp from 26 members who predict the scores for each game and I manually input this into...

plese help me to solve this. <colgroup><col><col><col span="2"><col><col span="2"><col></colgroup><tbody> NAME : Bilal MONTH: Oct-17 DESIGNATION : General Helper WEEK NO: WEEK 40/ 41 / 42 /43 NO DATE...

Hi there! Trying to figure out how I'd go about writing an IF formula where I have the following information: Goal: assign a different range of values whether is man or woman. Man (%) Atlhetic <=3 Fitness...

Trying to use a list of 2 man golf teams then randomize four man teams (foursomes) without repeating a name nor using their two man team partner on the same foursome. The list of 2 man teams can decrease or increase. Can this be done with an Excel formula without using vba ?

I am struggling to work out an average in a table with two conditions, I have tried averageifs and sumproduct and failed, please help. E.g. I want to know the average of all Cat that are in the UK only, which would be 3.33, or how many Man in China which should average 2. Please help with a...

Hi Guys, Long-time excel user, first-time poster here. I've been working on creating a version of the game Bomberman for Excel and have reached the point where I'd like to get other people's opinions on the gameplay and gauge the overall interest level. Any...