multiple loops

  1. A

    VBA - How to complete one loop before beginning another

    I have a code that searches Sheet1 ("Location") for certain criteria and populates Sheet2 ("Supply Usage Form") with that data. This works fine, after looping through all the rows on Sheet1, I need the code to loop through all the newly added data in Sheet2 for duplicates, combine the rows and...
  2. L

    Moving Data From One Worksheet to Another Worksheet using VBA

    Hello - I'm attempting to convert column data to row data. I currently have 16 columns and I would like to shrink this down to 6 columns. I have about 20 hours experience working with VBA and I'm stuck. Any guidance would be most appreciated. The current headers and layout is as follows...
  3. E

    Multiple loops in one macro

    Can you have multiple loops in one macro that does different things. If so, how can you end one loop to start the other loop.. I tried using the work loop but it gives me an error.
  4. J

    Create as many levels of a loop as there are dimensions of a string

    *Edit* sorry the title should have been: Create as many levels of a loop as there are dimensions of an array Sorry for the confusion! --- Hi, This is somewhat difficult to explain, but please look at the following UDF: Public Function ConcSep_Array(InArray() As Variant, Optional Sep As...

Watch MrExcel Video

This Week's Hot Topics

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
Top