tony

Hi, Can you please help me with conditional formatting (highlight both cells) as with the below example to highlight the name "Mary" in the "NAME and "Qty" Columns on ranges A3:B7, C3:D7, E3:F7. I'm new here and its my first ever post,Thank You in advance. <tbody> SHIFT 1 SHIFT 2 SHIFT 3...

Hi, I am trying to obtain an average from multiple criteria using AVERAGEIFS function. The issue is I want to be able to specify the average range in a dynamic way based on column header name. I used index/match to specify the column name using header name for AVERAGEIF and it works like a...

Hi I have an excel query and i can not figure it out: I have a list of names in column A and Dates along in Row 1. And under the dates by the names are zeros or BH (Bank Holiday), W (worked), H (Hol) & HF (Half Day Hol) I am trying to get results by looking at the name i want to know when...

Hi everyone, I have a userform that pops up when you click on column C any row, but it shows up in the middle of the page can i tell it to show next to the cell ? Thanks Tony

Hi everyone, hopefully sile question but I've noticed when i get hepl some times i get this "Eviron("USERPROFILE")" and sometimes "Environ$("UserProfile")" is there a difference? why the "$" and the capitals? just wondering if one is better Thanks Tony

Hi Everyone, I'm confused? when i record a macro if i create a conditional format it records this for me, but when i go into edit existing ones it does not record this. is there a way to get all my conditional formats out into either a sheet or a VBA somehow? thanks Tony

Hi Everyone, Ok so please help with this formula if you can? I have names in column B I need to change the way they are recorded for our new system. In colunm "B" I have names that are all set up as either sir name and first name or sirname and initial. I need to reove the space between...

Hi Everyone, Ok brains gone dead pleae help. Column P has formulas in rows 2:2000 many formulas return a "" or a zero. but I want the last row number that has something in it. I say something as it can be a negative or positive or a text. please help if you can Thanks Tony

Hi Everyone, I have a file with lots of sheets, I want a macro that if any changes are made to the document it will insert the date into Sheet "Conrol" Range("D1") please help if you can Thanks Tony

Hi Everyone, for some reason pulling a blank on this. Two cells D3 & G3 I want to see the difference if its more than 1p (0.01) but show 0 id not please help Thanks Tony

HI Everyone, I need a macro that can do this, When run, Go To Every Visable Sheet, Look for The Name "Tony Smith" in Row 8, (there will be only 1) then delete the entire Column if the sheet does not have that name go to next sheet Please help if you can Tony

<tbody> A B C D E F G H 1 Name Start End Kyle 12/18/2017 2 Kyle 1/1/2018 1/16/2018 Kyle 4/10/2018 3 Tony 3/1/2018 3/22/2018 Tony 11/6/2017 4 Joyce 3/15/2018 4/12/2018 Tony 11/8/2017 5 Tony 3/1/2018 6 Tony 3/5/2018 7...

Hi Everyone Ok so I need to remove the name from a cell with other data in it. so lets say data is in A2 here are some examples of what it can look like what I have: The result I want WEb Site - Sales - Tony Tony Web - enquiry - Tony-Snith Tony-Snith...

Hi Everyone, I need a macro that can copy the activesheet and the sheet to the right of it and create a new workbook Please help if you can thanks Tony

Hello guys, Can anyone think of a way to add a value to every Nth cell that has a repeating value? Example: <tbody></tbody> <colgroup><col style="width:48pt" width="64"> </colgroup><tbody> Bob Bob Bob Bob Bob Bob Bob Bob...

Hi Everyone, I need a formula to combine the data from B2:B10 but include "|" between each value, but also cope if some cells don't have a value So =B2&"|"&B3&"|"&B4&"|"&B5&"|"&B6&"|"&B7&"|"&B8&"|"&B9&"|"&B10 would work but I need it to deal with empty cells? Tony

Hi Everyone, I need a macro that can look down column D and remove (just clear contents not delete cell or row) the repeated words so I only have one, the one I want is the first one. Any ideas??? Thanks Tony

Hi Everyone, I have a list of sheet names in sheet "Welcome" Range "C7:C200" I just want a macro that will hide all of them Thanks Tony

Hi Everyone, I want to add that column "A" must = "Active" for the column to not be hidden in this macro that works great. any ideas how I can do this? thanks Tony Heres my macro Sub Hide_Contr() Dim s As Range, c As Range Date1 = ThisWorkbook.Sheets("Date").Range("B2").Value LastRow3...

Hi Everyone, I need a formula / formula to split a cell into 3 besicly I want everything before ">" in first cell, Everything after ">" in second cell so if its "254.67>32.45" I get 254.67 and 32.45 please help Thanks Tony