greatly

Hi I'm a very new self teacher of VBA so this is probably a very easy problem to solve. I'm trying to write a code that will fill column B depending on the text in column A. For example: <tbody> This That When Why This That Where Who When Why </tbody> So if This is Found in Column...

Please can someone help...I want to be able to filter on a table and delete if the result is 'Yes' and then remove filters using VBA Ay help, will be greatly appreciated Thanks Rehmat

Hi guys, I would like to ask you a question. I would like to format the cell only in the intersections between rows and columns The cell that crosses the row with a value of 1 and the column with a value of 1 must be colored automatically. I made a screenshot for example Any tips/solution...

Is it possible to have a vba script to generate daily chart sheets (one day per chart sheet) from a worksheet data set? Any help would be greatly appreciated. Example data set <colgroup><col><col span="19"></colgroup><tbody> Date Time Lmax L1 L5 L10 L50 L90 L95 L99 Lmin Leq Relative...

Hi I am trying to write a query for the below link https://imgur.com/a/J55Z2xc Any help would be greatly appreciated Thanks

I am using conditional formatting on a pivot table. But when I open a dropdown box the conditional formating does not seemed to get applied to drop down. How do I do that? Any help is greatly appreciated.

In column (L) I would like to highlight the cells(L6) based on if the the cells in column (K6) >30. I will need to repeat this for all of the cells in my workbook. Any help would be greatly appreciated. I am drawing a blank. Thank you, Amanda <colgroup><col><col></colgroup><tbody> </tbody>

Hi Everyone! I'm attempting to calculate the below formula in VBA. However, it returns a type mistmatch error. Any help would be greatly appreciated =) dblMyVal = Evaluate("SUMPRODUCT(($H$2:$H$1000)*($A$2:$A$1000=A" & rw & ")*($B$2:$B$1000=B" & rw & ")*($D$2:$D$1000=D" & rw &...

Hi Everyone! I'm attempting to calculate the below formula in VBA. However, it returns a type mistmatch error. Any help would be greatly appreciated =) dblMyVal = Evaluate("SUMPRODUCT(($H$2:$H$1000)*($A$2:$A$1000=A" & rw & ")*($B$2:$B$1000=B" & rw & ")*($D$2:$D$1000=D" & rw &...

I have two sheets, one the master with a UPC number column and a Product ID column. The other has only the UPC and inventory information. Not all rows have a product ID in the first sheet. I would like to have a script or macro go down the 2nd sheet at each UPC and see in a product ID is in the...

Hey! I've seen this thread which seems to be what I'm after, but doesn't quite work for me... https://www.mrexcel.com/forum/excel-questions/593812-macro-autofilter-skip-if-blank.html When I use the answer here it skips even if there is a field present. Below is what I have, there are several...

Hi, I have the below formula and can’t figure out why it returnsa #N/a instead of the “Policy Not Found” The "Policy found" and “” are working fine the only problem iswith the false value coming up as #N/a instead of "Policy Not Found" Any help is greatly appreciated...

My update query keeps failing, please see below...Any help will be greatly appreciated...Thanks UPDATE TSMDistributionTableTemp SET TSMDistributionTableTemp.DistributionType = "*" & [DistributionType] WHERE (((Right([DisbursementType],1))="*"));

I have a formula that I cannot seem to get to work. I am sure it is something super simple and im overlooking something but I would greatly appreciate any help on this. QUERY(Data!A2:F,"where D=>'"&E1&"' and D=<'"&F1&"'") I am simply wanting to make sure the date in D is between a start of E1...

<tbody> 1 2 2 2 1 1 2 1 1 2 125000 150000 175000 200000 </tbody> I need a formula in A5,A6,A7 that will say if A1 =B3 AND A2 = B4 then give me B5, if they both don't match move over to column C and see if both those match, if so give me C5 and continuing on...

Hello I have distance in my data that I would like to categorise into radial areas (The cell containing the distance is AN2). For example 10 and under is Area 1, 10.1 to 15 is Area 2, 15.1 to 20 is Area 3, 20.1 to 25 is Area 4 and anything greater than 25 is Area 5. Any help would be greatly...

Here is the formula I'm trying to use: =IF((LEN(S4:S6)=0,""),(LEN(S4:S6)>0,AVERAGE(S4:S6))) Unfortunately, I am getting error message " There is a problem with this formula". Do you see anything that I need to change? Your advise will be greatly appreciated

Hello, I need help with VBA code inserting sum of cells in column R in to column T which are separated by two empty rows. values in column R starts at row 2. Here is an example: <colgroup><col><col></colgroup><tbody> Column R Column T 258.05 567.42 309.37 426.19 930.44...

Hello Experts, Is there a way to import UserForms (located in separate folder) when I open Excel file ? Workbook_Open method can help but I'm not sure as how to call the Forms from that. Your help is greatly appreciated ! Thanks.

A1 has a formula, B1 is empty. I would like C1 to stay empty if either one of A or B is empty, otherwise, A1 minus B1. Any help would be greatly appreciated.