vba if and

Hello, I am looking for a vba that will do the follow. If the cell a2 date value is not the date value of the cells below delete the row however if the cell is blank within the column do nothing and move on to the next cell. <tbody> a b 1 2 7/22/2019 21:04 3 7/22/2019 20:55 4...

Hello. I'm hoping you all can help me create a macro that will loop through multiple sheets to identify errors and log those on an ErrorLog worksheet. The excel file is a system generated report with 115 tabs. Column A = Descriptions and Column B = Values. If Column A is blank " " (there...

I'm trying to make an inventory model. let's see if I can explain it. This is "Sheet1" <tbody> Article Inventory stack Fork 500 2 Spoon 50 1 BBQ 300 1 Sallad 23 1 Computer 6 2 </tbody> I need a VBA macro that copies the first 2 columns IF 'Inventory' Collumn has a value of <= 50...

Hello, I have a table where users enter data. The final entry, in col M, is their name. I would like to create an VBA code that will display a msg box if the user enters their name in col M without having entered a date in col J. I've written the following if function which seems to do the...