looping through rows

  1. A

    Auto Create Charts from Different Rows in Excel

    Hello! I'm very new to VBA and have managed to create most of what I need; but am stuck on the hardest part IMO - Looping through the rows to create each chart. What I'm looking to achieve: Creating a chart for each row of data in my excel sheet. Each row of data has three years of monthly...
  2. Z

    Looping and sorting through blocks of rows

    Hello I am looking for a VBA solution I have a sheet with several thousand rows.The rows are split up into blocks of rows and seperated by an empty row.Each block of rows will vary with entries so these are random The sheet has 7 fields author,book_...
  3. DetroitDavid

    What's wrong with this code?

    Nubie here, trying to do something and it's not working, help is appreciated! On my sheet, E1 is a header. E2 to Ex (end of data) will have a single digit number 1-12 which I need to convert to a corresponding letter of the alphabet, A-L (1=A, 2=B, 3=C and so on). So if a 6 (currently...
  4. A

    VBA macro to extract data from one row to two rows

    Hi, I am trying to extract certain columns from a calculated row on a worksheet and generate two new rows derived from the original calculated row. Calculated data looks like this. <colgroup><col><col><col span="2"><col><col><col><col span="2"><col><col span="2"><col><col></colgroup><tbody>...
  5. A

    Macro needed to extract two rows from one row

    Hi, I have generated a row of calculated data and from that I want to split the data out into two other rows. Calculated data is displayed: aaa bbb cccc date figure 1 figure 2 xxxx yyyy I want to split it out like this aaa cccc date figure 1 xxxx bbb cccc date figure 2 yyyy This will...
  6. A

    Looping through rows and columns

    Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I’m sorry my question is a little difficult for me to describe, but here goes…<o:p></o:p> <o:p></o:p> <o:p></o:p> I need to loop through the rows in my sheet looking at the value in Column...
  7. R

    Looping through rows

    I have an Excel file with 2k+ rows. I need to create a macro that will loop through the worksheet keeping one record and delete 9. (Keep a sampling of 10%)

Some videos you may like

This Week's Hot Topics