macro - if/then

I am new to macros and VBA, so please type slowly. I am trying to use a checkbox (true/false) as a trigger element to call one of two Macros (Hide and Unhide a column). When false, I want the column hidden. When true, I want the column unhidden. I will need a total of 9 checkboxes and columns...

Hello, I am a newbie to doing anything beyond the basics in Excel so you might have to very specific in explanations. unfortunately I do not know VB (some Javascript & bash) and afraid what I am looking for will require it. Thanks Environment: Excel 2013 Current Workbook layout: <tbody> A B...

Hi All, :confused:Im struggling with this, any ideas will be much appreciated. I have a table A1 to M500. I need to switch columns L and M values Then delebte columns B, C and I Then replace...

I am using the code below to find any cells in the designated range that have "yes" or "no". In doing so, i was wanting to supply some special formatting for each instance. Issue is I am receiving a "Compile Error: Next Without for Error". Could anyone tell me what I am doing wrong to...

I created a conditional format in my report to fill the cell in red when this formula = TRUE. <tbody> =AND(B16<>B17,B16<>"",B17<>"") How do I apply this into a macro? I am adding a validation button that will confirm that this AND formula has been corrected. People will see the red but...

Hello All, I am wanting to perform a simple macro, in my mind, of confirming if a set range of cells all = 0. My current macro is giving me errors. It is the following: Sub ValidateCheckData() Dim ValidationRange As Range Set ValidationRange = Range("H23:I27") If ValidationRange.Value <>...

Hi All, I Am reading and excel sheet using macro. I have Put a condition already if the code come across ani ISNummeric = false Skip it to next line. I wanna know if the code comes a line where Column A B and C is empty Code should end DO Not go Beyond that row. Below is the table as per table...

Hi All, I Am reading and excel sheet using macro. I have Put a condition already if the code come across ani ISNummeric = false Skip it to next line. I wanna know if the code comes a line where Column A B and C is empty Code should end DO Not go Beyond that row. Below is the table as per table...

Hi All, In an excel sheet after I select the empty cell I need to select from the next cell to it and start reading A B C 1 2 3 empty 3 4 2 4 5 If I put in the code below it goes fine but it goes to the empty cell then starts back again from B2 Public Sub proIterate()...

Hi All, I am new of this Forum. I have problem how to skip the row if "SEQ" column has any character instead of a number as below <colgroup><col span="3"><col><col><col><col><col><col span="3"><col><col><col><col><col><col></colgroup><tbody> SEQ INI BSB DEBIT BSB DEBIT ACC NO. CREDIT BSB...

Hello All, I am beginning our company's audit process for assets in currently in production. In doing so, I need the people on the floor to confirm 3 fields that I have supplied a data validation list that will allow: "","Yes","No". The predefined asset data is in columns I:V. What I am...

Hi all, I really new to macros and I'd like to ask for assistance in using macro in Excel. I'l like to be able to search all the columns of a worksheet using keywords from a column from another sheet. If it gets a hit from the list it would move the whole row to a new worksheet so that...

Hi, This is my 1st using this forum and also VBA. I am in the process of writing a VBA code to generate my finished month end reports by clicking a created macro button. In this process I have ran into a snag. The snag.... In column G, I have asset classes. There are 3 specific asset...

Hi all and good morning / afternoon; I am currently looking for a VBA code that will identify if all the required data is filled when pressing the "Confirm & Send" button. I need a code that shows up an error message if all the cells are NOT filled; and , on the other hand, automatically send...

Hi, I have a set of data, which I need to check for data within specified columns say Col. A, C, L. They need to fulfill the following criteria: If (cell value <> "100", "80", "NA"), then generate a log in a new sheet returning the Column header of where the error occurs, if all OK, proceed to...

What I want to do is: If the checkbox in cell X1 is true then copy cell X2 and then paste in Cell X3 but only if Cell X4 is equal to todays date. If it's not todays date then check cell Y4 for todays date. If not then check cell Z4... And so on until the cell with todays date is found. So if...

Hi! I am clueless about macros and would deeply appreciate your help. Is it possible to have a macro copy a row from one worksheet and paste it in a new row in another worksheet based on what value is in a cell of that row in a specific column? Let me give you an example of what I'm trying to...

Hello All, I have been attempting to find a macro that will look for duplicates in columns A and then copy the entire row for those entries into another spreadsheet. I have searched through the forum of past questions and nothing quite captures what I am looking to do. Can the geniuses of...

Okay, so at work... I spend hundreds of hours checking to see whether the name in one column of an excel sheet matches the name in the second column of the excel sheet. I'm starting to go insane and all I ever do with my life is check whether a name in the first column Matches the one in the...

Hello, I am looking for a macro that will Insert column to left of B and move indented data from A to new column (which will now be the new B) any help wouldbe great. Regards,