based

Hi Everyone, Below i have a code which copies based on cell values(Highlighted) but instead of cell values, can we copy through cell name (Cell names which would be only in "Column C") FolderName = Worksheets("copy").Cells(2, "K").Value & "\" If FolderName <> "\" Then FileName =...

Hi, I have used the formula below to apply conditional formatting to the cells in my worksheet. The conditional formatting is based on the result of inputting a value in the column heading and a value in the row headings. The problem I have is that all results are the same colour. I need the...

I have a Toggle Button, linked to C1, which returns a TRUE/FALSE. What I want to do is change the font formatting of a <Text Range>, based upon the result in C1 If C1=FALSE, then <Text Range> displays in the default font (Arial, 10), but If C1=TRUE, the <Text Range> displays in (Times Roman, 12)...

Hi, can anyone advise what type of formula would be best if I wanted to create a dashboard that listed the last 10 transactions based on multiple criteria? In my case it would based on the account status, i.e., Approved, Declined, Pending and the second criteria would be the submitting broker...

Hi, I need to add up one column if the percentage in another is below a certain percentage. I am able to use the formula =sumif(A1:A10,"<"& A12,B1:b10)*A12 Column B has percentages calculated cell A12 is the percentage (that changes every month) Because the percentage is not an even number say...

Hello, I'm looking for 2 formulas or a macros that do the following. The first formula; In column D1 will give a date based on the data corresponding in the cell range if the name corresponds in column B and is within columns A1:A6. I'm not sure how to say find the date in column A and grab...

Hi Everyone, I wish to Auto insert a text based number into a worksheet using vba... The text based numbers appear like this "BCPSC01", i have tried a few different methods but no success so far, i know this is possible to do. the numbers will continue to run consecutively. Thankyou in advance...

I would like to create a formula to automatically add the total hours per labeled time block based on the text above it. For example, I would like the formula to add the value in F26 based on the text in E24. to Does anyone know if this is possible, and if so what formula should I use? Please help!

Hi all, Is there any way to automate the copying and pasting of selected powerpoint slides via macro/vba? I have a master deck of 100 slides, however only selected slides are required to be paste into a new clean deck. Is there any way to copy the slides based on an array search on specific key...

Hi! I would like to create a point systems where I assign different points based on yes or no answers through a dropdown, i.e. Question 1: Yes = 2 No = 0 Question 2: Yes = -1 No = 0 etc... How can I do that? Thanks in advance! :)

Hello, I have a group of employees that have results for various metrics. I want to assign a Score for each of these metrics based on specific values that their result is between. For example, one metric might be quality, and I might have scores 1-5 where 5 is anything greater than 98%, 4 is...

I have 150 sheets inside 1 workbook, they need to be ordered exactly as listed in a column on a separate sheet. Example (SheetA, SheetB, SheetC, ect) These sheets have been renamed, and every macro I've found online is re-ordering based on the "Sheets Property (Name)" not by the actual naming...

Hello all, I am trying to create a macro that will perform some very basic formatting. Essentially, I have a dynamic list of records that I want to display under relevant headers. I'm using a counta formula to determine how many records exist under each category. I then need the macro to insert...

Hi All, Need some help please, I have the following formula thatworks as it should so no problem there however I’m trying to amend it or add a secondformula to the front of it so that the formula returns a value of zero based onspecific text in the cell C2 (house). The working formula as it is...

I have 100,000 records in a table (data) in sheet 1 as per below based on "Success" or "Fail" Table (data) Event Result MB65 Success B65 (AI) Success MF6.1.1.1.3 Fail MF6.1.1.1.3.1 Fail MF6.1.1.1 Fail I need to colour a row based on another table (_MF6) which...

Hi, I have a total amount that is calculated based on multiple inputs. Is there a way to store the latest amount in another worksheet matching the ID for that record? Thank you

I have an excel spreadsheet which I am trying to improve. One of the columns is based on whether a shift was a morning shift (AM) or an afternoon shift (PM). currently it is using a data validation and I have to pick from a drop down list. Is there a formula that automatically inputs either AM...

Morning! An easy one this morning (based on how clever everyone round here appears to be).... I have a spread sheet with various calculations in it. What I would like is for a cell to simply blank that cell if another cell on that row has a specific value in it. Example. The Column with the...

i have a column which is text, either Win or Lose. i wanted to see the streak, how can i make a spark chart based on these 2 text values? thanks

Hello, I have 7 different sheets that I want the combo drop down box to open based on the number in cell C50 in a separate control sheet. I have the following code written although keep getting an error "Compile error: Block If without End If" any help is greatly appreciated! Sub...