if condition

Hi, I have the code below which works well. It checks to see if Cell "A1" is not empty if it is not empty then it runs the code only in the cells are blank in column A. I would like to change the code so that it automatically checks each cell in column A, if has data then it runs the code...

Hello, I need your, help actually i'm using this code to allow the user to extract data from a unopened excel file, The macro will open a window to allow the user to select the file that he wants to copy data on the actual workbook : Sub Extract() Dim Wrkb_Org As Workbook 'Variable to link...

Hello I have a code, with a loop (for...next to check lines) to check value on cell (line 1) and the next cell (line 2) to assemble them or not : Sub loop_check() Dim lastline As Long Dim i As Long lastline = Sheets("Data_Sheet").Range("A" & Rows.Count).End(xlUp).Row For i = 2 To...

1) The Values need to Match cell C1& B2 value like that cell value need to check. Condition like as below cells cell c1& b2 cell c2& b3 cell c3& b4 cell c4& b5 like this matching up to 100 After that I need total count of match value. The same way need to match reaming values...

I have data in Sheet1 in Column A & B. In Column A I have Data, based on the Column A Data there are data in Column B, I want that in Column C those data of Column B should place in a cell by sepearated by a Comma...

Hi all, am a beginner at VBA and would like to seek help regarding working this out. Have tried looking at certain threads but I am unable to find something similar to what I want to perform. Currently, I have two separate workbooks as below: 'Customer Info' Workbook, 'Customer' sheet...

Hi! I have column which has several termination dates and what I need to do is to group those dates into years as showing below: - Less than 1 year - 1 year - 2-3 year - More than 3 years What is the best formula to use? Thanks!

Hello everyone, I have a macros which loops through multiple workbooks (csv files) in a folder C:\VBA\, and makes changes to numerical values of each file, as a result of changes the value of the certain cells in the column “M” becomes (while the code is still processing CSV file) equal to BUY...

Hello People, Can someone help me with below requirement. I have a cell address stored under address1. now I want a code which loops through entire column of "address1" and if a number zero is found then it has to check the value of its immediate left cell and 1. if it is NA then zero should...

Hello there, I need a contiditon that checks whether an array Ary1 is empty in VBA. Can you help me with that? Thank you and best regrads, Kristina

Hello, I have two arrays Arr1 and Arr2 that both include a list of words. I need a code that compares every element of Arr1 with every element of Arr2. If at least one match was found I wan't to add more code. So it would look like this: If Arr1=Arr2 Then ... The comparing part is not working...

Good morning Mr. Excel community, I have a questions and wondering if you can help! <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}tr...

Hello everyone, First of all I´d like to thank all participants on this website, which help me a lot to improve my VBA skills. I hope to get help with my issue :smile: Don´t get shocked about my long text, the main work is done and works. So, Two workbooks 1 =...

Dear Experts, I need your help regarding timeline, i have below data from style to last date and i want to calculate day wise quantities according to below criteria. 1.5 Change over days are constant and days required are calculated =4000/800 >> 5 +C/O days >> 6.5 days. 1st Day Plan: 25% of...

Hi Community, I have a VBA macro for a log record that copies information from a submission form and pastes it in a Log Record data file based on a IF condition. THe condition is partially working where if the condition is true then the data is copied to the log record, But when i try and...

Dear Experts, I need a if formula that solve my problem with conditional Formatting. Like, School scores grading on below Illustration</SPAN>: i) less then 33% Grade Result F and showing in red ii) 34% to 40% Grade Result E and showing in yellow iii) 40% to 50% Grade Result D and showing in...

I have to change the name as per the group in 'Type' column. it is working fine if it is represented as single name, but not with multiple names. Eg., For Apple, Orange, Watermelon, it should come as Medium, Soft Formula used in 'Type' Column -...

I have set up a sheet with automatic numbering based on formula based on “flag” field. Flag “h” is for headings Flag “”m” and “s” are for Sl. No. field If flag is “m”, then the Sl. No corresponding to that item is incremented by 1 If flag is “s”, then the Sl. No is corresponding to that item...

Here is my question. I am looking for a value "Y" in Columns Y: AW and if Y then return " N " else "Y ". I got it to work in cell AX2 using formula IF(COUNTIF($Y2:AW2,"Y"),"N","Y"). Having trouble to dynamically update columns when new columns are added after AW . I need column Y (the...

Hello, My Question is need to display a text value "Started" & "Completed" cell a1 has start date Cell B1 has End Date display c1 "Started" or "Completed" based on the a1 and b1 dates.. a1 = 10th may (10-05-17) b1= 20th may(20-05-17) I have one more cell also , total number of...