if loops

  1. S

    VBA IF then Loop help needed copy value to another sheet

    I am not familiar with VBA if then loops so I don't really know where I would begin to write what I need. here's the scenario: In sheet (1) If cell values in column (F) = 1 then, in that same row, copy cell value in column (A) and find the next empty cell and paste in sheet (2) column(B) the...
  2. R

    Data Validation Box Pops Up when cell meets certain criteria

    Right now I have cell E4 filled with: =IF(D4='Training Data'!$A$2,'Training Data'!$B$2,IF(D4='Training Data'!$A$3,'Training Data'!$B$3,IF(D4='Training Data'!$A$4,'Training Data'!$B$4,IF(D4='Training Data'!$A$5,'Training Data'!$B$5,IF(D4='Training Data'!$A$6,'Training Data'!$B$6,IF(D4='Training...
  3. B

    VBA IF Loop Help

    I'm having a bit of trouble with a macro. The code is supposed to first check to see if a certain parameter called 'Setup' is True or False and then checks each sheet for the value of R43 if 'Setup' is True or R44 if 'Setup' is False. If the value in R43 or R44 is True the code highlights a cell...
  4. B

    Fibonacci sequence help in VBA!!!

    Ask the user to enter a number. Generate the Fibonacci sequence from 0 to that number.
  5. D

    IF Loop formatting

    I need to write some kind of loop to check a cell for its contents and if the cell is empty then take the text from the cell to its left and insert to the most recent cell with a value. That is screen shot sample of my worksheet. So for example, cell B3 is empty therefore I want the contents...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top