rows below

  1. R

    TEXTSPLIT into Rows but Maintain Grouping

    This is harder to explain than show. I have metadata being imported into an Excel spreadsheet that defines a single item (an image title) on a given row, but much of the metadata is in separate columns with each column cell containing data that is separated by delimiters (;). These are all...
  2. N

    Selecting all rows with a certain text within a certain range

    Hello, I am creating a userform where depending on which option selected in the combobox different ranges should be selected. The ranges are taken from a long list with columns from A to E. A is filled with dates. It looks something like this: If i am choosing option "Hello" in the combobox...
  3. T

    Convert concatenated cell into multiple rows, whilst repeating non-concatenated adjacent cells

    Hi all, I've got a massive sales order report where all multiple row data (products, quantity, prices) belonging to the same order have been concatenated in a single cell (rather than a nice, structured 1/row that I could pivot easily). Can you please help with converting all the concatenated...
  4. M

    Add multiple blank rows to the bottom of an Excel table

    I've searched everywhere to an answer to my question but every answer has conditions, such as every other row, or when a condition exists or using a msgbox. I want to add 5 blank rows to the end of my Excel table with no other requirements. My table is named Backhaul_Table. That's it. I know...
  5. J

    Insert New Row Below, Not Above

    I have written the following code to insert a new row so that an entry isn't overwritten: Range("B2").EntireRow.Insert The new row is inserted ABOVE the previous post. I would like to have the new row inserted BELOW the previous post. Thank you!
  6. H

    VBA script to delete rows

    Hello, I have a list of about 300,000 company names with 1,000 of them being usable. The usable company names have content in column C. I essentially need to delete any row that does not have content in column C, but I need to keep five rows above and five rows below any company with criteria...

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