loop and copy

  1. D

    Copy text from webpages - loop?

    Hi All, I'm a VBA beginner I would like to copy text from a webpage that is not in a table. The text is basically a daily post from this calendar year. The individual page URLs have the date in the URL. For example, these would be the pages from the first 4 days of March...
  2. F

    Loop through Subfolders: Copy/Paste Cell Data

    Can someone get me pointed in the right direction on creating vba to loop through folders and subfolders to copy/paste data from a specific cell in multi-worksheet workbooks? The cell is in the same place in all workbooks and is a named range/cell (jobnumber). The workbooks have a standard...
  3. D

    VBA Loop Visible Cells Column, Copy left 7 digits

    Hi, I'm pretty new to VBA and desperately need help! I have to loop through a column of data, select only the visible cells in that column, extract the left seven characters then paste them into an external workbook I've already created. This data will be pasted on sheet2 of the external...
  4. A

    loop backwards for searching a string

    Hi, I want to run the loop backwards in order to search a string. The requirement is as below: <tbody> A B C A1 game A2 ZOK name A3 pen A4 mobile A5 KUY copy A6 shirt A7 rat A8 mat A9 hat </tbody> I want to copy the rows from one sheet to another based on the...
  5. E

    Cells not copied in multiple loop sub

    Hi, I am trying to loop to check email addresses in column 1 of sheet4 against those of sheet2 in col 6. If found I need to copy corresponding info from sheet2 to sheet4 and then I am done with that email address from sheet4 and need to attempt the next one from sheet4. If not found continue...
  6. T

    Increment in Loop Help

    What would be a good way to increment each of my ranges for example I need x to copy Range B11:to G20 and paste it to C10 for the second loop. Each Variable has different increments. Any Help is appreciated cause I'm horrible with Visual Basic. Sub Macro5() ' ' Macro5 Macro ' Dim i As...
  7. D

    Copy, paste, loop

    <TABLE style="WIDTH: 748pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=995><COLGROUP><COL style="WIDTH: 27pt; mso-width-source: userset; mso-width-alt: 1316" width=36><COL style="WIDTH: 218pt; mso-width-source: userset; mso-width-alt: 10605" width=290><COL...
  8. L

    Check value/paste value

    Hello! I'm a little bit frustrated because this macro is not working. Good thing is that I'm not receiving an error message but it is not working. I need to change the cell value of the information of Sheet 1 to the cell value of a conversion table at Sheet 2. Sub ChangeName() Dim h As...
  9. B

    Copying and pasting sets of 20 rows

    Hello, Kind of new to macros. My problem: I have a long list of data (say 14000 rows with data from A:E). There are 20 sites reporting data for 700 measures. (For whatever reason the data is sent to me in list format). I am not sure of the best way to proceed but I am thinking that a VB...
  10. R

    Loop through select rows and start at next column until empty column

    I have a macro that I need to loop through all of my data until there is an empty row or it hits row 9 (whichever comes first) in the first column and then start over in the next row until it reaches an empty cell in row 1. The reason that I can't have it just go through 9 is because I dont want...
  11. P

    Stuck in loop Tyring to paste multiple named ranges to a different sheet.

    Hi Guys, I'm pasting values from one sheet to another based on multiple named ranges. Woks great when pasting one column but when i add multiple ranges, UFFF!... Read below... General Overview: I have a sample workbook attached, there are (2) sheets of importance. First is the sheet...
  12. P

    Copying data using a loop

    I have data in one tab ("Country") organized by columns: Col A Col B Col C Col D Col E Col F Italy Euro Prod1 Cost Date ROW Italy Euro Prod2 Cost Date ROW Spain Euro Prod1 Cost Date ROW Italy Euro Prod3 Cost Date ROW I want to loop through the range...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top