conditions met

I've got a sub routine that works to apply a filter to conditions in column I. I need to add another condition that would only apply to the list set if a date condition is met. Need the date checked for today in Column L before applying . Sub AF() Dim RX As Object, d As Object Dim a As...

Hello Everyone! I ran into an issue with macros and I could use some guidance! I attach a sample excel file for ease of reference. I need to write a VBA code which needs to: 1) Check if a condition is met ("Other" or "Building") -> Column D If "Other", then multiply OMV (Column C) x 0.30% If...

Does anyone know if its possible to run a macro that checks if certain conditions are met and if they are not, it incrementally increases another cell. Condition 1: W15>$W$12 Condition 2: X15<=$X$12 If the above two conditions are not met, then increase the cell value of AD15 by 1 otherwise...

Hi, I am very new to VBA and would be happy if someone was to refer me to another post where this was answered or where I can get more information so I can learn more however I have the following scenario that I am hoping to solve. I have two worksheets Invoice Summary and Outstanding...

Hi everyone, I have a list of data, that goes like this: Day Month Department Worker Sales 1 1.2015 Department 3 A 5 2 1.2015 Department 4 B 8 3 1.2015 Department 7 D 12 4 1.2015 Department 7 A 33 5 1.2015 Department 3 V 19 6 1.2015 Department 1 G 81 7 1.2015 Department 2 H 14 8 1.2015...

Hello, I have trouble constructing macro that would automatically check filled rows from the sheet and delete the dummy rows that copied file generates. Dummy rows are recognized by the facts that they don't have data in column A, BUT they have data on column C. So the macro would have to...

Hi, I am new to VBA and I would appreciate any help on this. My question is how can I write a routine to add rows in one Sheet if a condition which involves a different Sheet is met (excel 2007). In Sheet 1 is a list of ("liquid") names (cells C4:C26) which will need to be expanded should the...

I ran into a problem i couldn't fix using formulas. I'm needing a pro. so i have two excel sheets... (Horse Race with point system situation) • 1 sheet shows manual data. Includes: Names, ID of the person, their horse name, date they raced and Points they received for that race. • sheet 2 will...