condition

Hey! Through a macro I managed to adjust a report and automatically import it to Sheet1 starting in cell A2. A1:E1 are static column headers in each sheet. The .xlsm should be used as kind of "tool" to generate weekly reports. Now I want to include another thing: Loop through the rows of...

Hi all, Hope someone can help me figure out why i am not getting the right outcome from the formula. I am trying to obtain some kind of summary, based on a vlookup for a person. So the idea is that by lookup the person name, then i will get 3 columns, providing different details connected to...

Hi All, I am working on a work order tool where I have in column (P) a formula that pops up different phases/stages. Now I am trying to start a macro automatically when the stage changes to "Gereed". I have tried a couple of things like worksheet_change and worksheet_calculate, but so far no...

Hello, I have a sheet of fictional data here: duplicates. Below is a screenshot for convenience. I'd like to list, in the duplicate column, duplicates of values in the id column, with one condition: that the corresponding row in the complete column must contain a 1, not a 0. Furthermore, I'd...

Hi Gurus, I have a table of values that I would like repeat in a new column only if certain condition is met. In this case, Column 1 has the values, Column 2 has the condition On=1, Off=Blank. Id like column 3 to have values equal to column 1 if column 2 is blank and while column 2 is on=value...

Hey there, I have a workbook that contains two works sheets, let's say Sheet1 and Sheet2. What I want is that for the cells in Sheet2 Column A, if the cell value equals to the Sheet1 Cell D5, then delete the entire row. Can you help to let me know how to make it with VBA? Thanks!

Hi everyone. Thanks in advance for any help you might provide. I'm looking to automate the creation of a PDF report which is based on an Excel file that I created. This Excel file (source file) generates figures which I intend to copy into another file (destination file) based on a condition...

Hey there, I have two sheets on hand, and need to sum the multiple results in condition at the third sheet. Are there anyone can tell me the formula that can achieve it? Thanks! Here's what I have: Sheet 1 Sheet 2 And here's what I want: Sheet 3

I have a Macro that converts the table back to Range. The problem occurs if there is no table name in Sheet3. I need the macro to skip this step then and continue Sub ConvertTableToRange5() Dim rList As Range Dim ws As Worksheet ' Source - delete table Name...

Hi, Required a formula help to subtract a values existing final cell value F3 & F4 with final cell C3 & C4 values like (F3-C3=Value & F4-C4=value). Condition here is C3 and C4 values are always same do not have any changes are moving forward but in final cell value F3 and F4 it is not fixed...

I have a problem I'm trying to solve. hopefully I explain this right. I'm trying do find a formula to insert 3 missing columns of data from another data set that has those columns. the data with the missing columns has over 600 rows. and duplicate values.. the data that has the columns i need...

I have sheet with some data where B column has some ID's out of which few are duplicates. This data is from 3 sources which are S1, S2, S3. data source is present in "F" column. Can someone help me with a VBA code that finds the duplicates from column "B" and then out of the dupicates find if...

0 i have 10 cars that need to fit in a car transporter truck. I have a limit on the length of the truck, which can take 5 cars in upper level and the rest 5 in ground level. i need a formula that will take the 10 car lengths and give me all possible 5 car combinations that dont exceed the truck...

Hi, I required a help in formula where as a item code AI2 (Cell no 4 & 5)does not have any allowable rate , but in that item code has incurred value for Operatives and Equipment (Highlighted Cells). In this case i required a formula for AI2 should return as a Allowable value = Incurred value...

Hi All, I am very new to Power BI and need help in following... I am running a query based on answer in this thread to copy rows based on a condition... let CN = [#"Column4"] in if Text.Length(CN)=11 and Value.Is(Text.Start(CN,4),type text) and...

@ How to change "H2" cell color change After "FALSE" ????????????????????????????????????????????????????????????????????????????????????? (No VBA only for condition formatting)

Hello VBA experts, I have a spreadsheet that I would like to add a command button to that would populate an email to the corresponding email address, but only if a condition is met (an upcoming due date). I have tried several versions of code, but none have worked so far and I'm also a beginner...

Hello. I have this VBA code that identifies route codes in one sheet in a workbook (pickorder). Then in another workbook (CX) it identifies those same route codes and gets the value (times) in 1 row below and pastes it into column A in the first workbook (pickorder). The code works really well...

Hello, Would like assistance to run a query in Access for the table below, where the ID is a text format. Date ID Value 4/15/2020 ABA 2.00 4/15/2020 NHB 1.00 4/19/2020 BBB 0.222 4/20/2020 RRRf 1.55 5/1/2020 NNN 9.55 5/2/2020 JUY 2.22 5/2/2020 YYY 2.22...

Workbook A,sheet 1 Supplier Amount Owner status Date AVT 500 John 4/22/2020 ABC 1000 Peter 4/21/2020 NAC 600 John 4/22/2020 BAT 10001 Andrea 4/23/2020 Workbook B, sheet 1 Condition should match Supplier, Amount, Date, If all matches in sheet 1 of workbook B with Workbook A...