formatting

THANK YOU SO MUCH FOR ANY TIME AND EFFORT IN HELPING ME SAVE MANY MAN HOURS AT WORK!!!! I just need to take a large data set from the first format below to the second. The changes include: 1. New column 2. Each row from the original data set that begins with cell A containing "RE: $...

Hi all, Thank you in advance. I'm very new to VBA/macros and I think I have a relatively easy task to complete, but I can't seem to figure it out. I received a bunch of UTMs for salmon redds, but in the wrong format and need to use a batch converter to change them to Lat/Longs in order to import...

I'm building Pie Charts for a client at work and they are asking me to try and remove the Gray Line that goes through the middle of my Pie Charts. I've included the data set for reference. As you can see, only the 'Lab' User Group has any value in the SF column. Despite only the 'Lab' User...

Hello all, I am trying to figure out how to separate some values on my spreadsheet, and I can't seem to think of any effective way to write some vba code to do this automatically. In Column A (starting from row 2 until the end of data), I have some values. "Secured", "Unsecured", "7A"... They...

I have been trying to concatenate cells from a different master sheet into one cell for a label. the problem is that some parts of the text are bold (for allergens) and when I finish it erases all the formatting from original cell. I've tried several different macros and nothing works. Please...

Hey guys. I've attached a portion of a spreadsheet I'm hoping to get help on. In cell E6 I would enter the time a particular incident was created. I'm looking to use conditional formatting to turn that cell red if the incident runs longer than 9 hours. Cell A3 has the =NOW() formula in it...

Hello everyone I'm a VBA novice who has muddled through a piece of code and got it working. However it's very long (and slow!) and i'm looking for some advice on how to make it more elegant (and efficient!) in order to speed up my procedure. Am i using an efficient way to loop through the...

Good afternoon, I have some data already in a combo chart, a mixture of stacked columns and a line. The data for the line predominantly goes up in order, e.g. 1,2,3,4,5 However their may be some instances where the data will decrease, e.g. 1,2,3,2,1 I would like the line for the data where...

Hi Guys, I am building a risk assessment form and need some help from the experts :D First would like the table to automatically add number in sequence if the cell risk is not blank as per table below. The same applies for mitigation and additional mitigation but with difference that...

In the following I have some code I need modified to see if I can do the following: 1) Only have this work when selecting a cell inside a couple sets of ranges. Ranges are E9:DA56 and E59:DA106 where I would like it to be active. 2) Only highlight or outline the cells above the...

I am losing my mind over this. I am very well acquainted with Excel; however, this super basic formula is killing me. Have I completely lost it?! We get a task on certain dates (DATE) and depending on the task, it may either have a 75-day suspense or 180-day suspense (STANDARD). To find out...

Good morning. Quick question - doubt I will get the answer that I want, but this forum has proven me wrong in the past. I am currently working on a project with 2 display / hud worksheets, 2 data worksheets, and 6 - 7 client worksheets. I want to find a way, without putting a "identifier" cell...

I have a workbook with multiple sheets (a new sheet is created every day). Column A of each sheet has product codes that are highlighted red yellow green or no formatting. I'm trying to create a worksheet that will show me the counts of each unique code. Can anyone help? Thank you!

Hi all I have a workbook with 2 different worksheets. In the first worksheet you type in different information. When clicking on the other worksheet the data from the first worksheet is then copied and pasted into shapes in the second worksheet. I have a challenge of keeping the source...

Does anyone have a solution to formatting mm:ss without the AM/PM after it. I'm creating a spreadsheet where I need to put time as an input, say for a race where something like 10:30 would be 10 minutes and 30 seconds. There are then some calculations done on the time which says if time is below...

Hi all, I am having issues with the following formula: =COUNTIFS('Raw Data - Travel'!D2:D350,">"&'Total Summary Data - Travel'!B3,'Raw Data - Travel'!D2:D350,"<"&'Total Summary Data - Travel'!C3) Cells B3 & C3 are start and end dates. D2:D350 contains dates. The formula works perfectly...

Hi guys, Been stuck on this for days now so I'm resorting to asking for assistance on this one. I'm trying to filter between two dates in dd/mm/yyyy format ( my PC is formatted this way too in regional settings), but after I run the code, the date "custom filter" has mixed up the days and...

Hi, I have a structured table with a certain table style: All of the cells in them are also formatted as "Normal". However my "Normal" is slightly different. It has cell background as white (not no-color), and has alignment OFF. Furthermore, in column Good Listings I have some Conditional...

I don't know how to best deal with getting my example onto this post, so forgive the copy pasta. Below is an example of how my company's system exports reports in Excel (there is no CSV, or un-formatted option for export). So, the employee's name is sort of randomly inserted at the top of...

I have formatted cells using conditional formatting based on a given value in my workbook being equal to either "EUR" or "USD". The custom format it should get when "EUR" is: "€"#.##0,00 (see screenshot 1). It shows the correct format (see below image), however when you would paste this cell...