loop until vba

  1. S

    Need VB code

    Hi. I have zero knowledge of excel VBA. I am working on a project. From a seperate program i am able to export reports into an excel spreadsheet. I want to copy and paste the spreadsheet into another excel workbook that has a Macro waiting to be used. The report results are always the same...
  2. R

    Loop A Macro

    Dear All, I have an excel data with date, source and SR number. In some cells of date and source is blank, in these case I need to copy the data of above cells and also needs to repeat the same until the SR number becomes blank. Table given below. Thanks in advance. <tbody> Date Source SR_No...
  3. J

    Loop with VBA and Last Value

    Hi all, I have two lists of data. One list is like this in a column: 1 2 3 4 5 6 7 8 9 10 The second list is like this: 1 2 3 How can I use the loop until function which will find the last value in the first list (10) and continue the list in the second column until the last value found in...
  4. B

    Highlighting entire row of Cells having 2 ranges of criteria

    I've been taking a course on VBA and understand it when he explains it but I've been struggling on my own. I just got a job that has me going through huge data sets and I want to be able to highlight data in 2 rows for the first and last name. So far here's the data that I have that will run...
  5. sitewolf

    For Next Loop using UsedRange

    For lead = 1 To 20 CurrentFile = ActiveCell Workbooks.Open Filename:=CurrentFile ActiveWindow.Caption = "Graboid" I have a file I use to grab information off a website I subscribe to. I get daily emails containing a list, then I use that list to extract additional information for...
  6. S

    VBA Loop Until Help

    I have data on one spreadsheet which gets added to each month 'Raw Data'. On a different tab within the same workbook 'Formatted Data' - i have formulae in row 2, from column A-O. Note: the formulae is different in each cell. It pulls different data from the 'Raw Data' based on criteria in...
  7. C

    Looping Until the adjacent column has a certain value in it. Please help

    I'm in the process of creating a macro, but there is a step which I'm stuck at. I have a macro that contains large lists column A:Stock symbol, column B: ex-dividend date of each symbol, column C: dividend, column D:today's date, column E: matches between column's B and D (Date only)...

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