blank rows

  1. G

    Infinite blank rows keep coming back

    How can I delete blank rows in Excel. It keeps coming back to 1048576 rows when I have only have data down to line 548 Using CTRL + End brings me to R1048576 and Table range from A1 to R1000 I have done the following: 1- Selecting all cells from A1001 to R1048576 and delete the cells content +...
  2. T

    Insert Blank Rows Every Nth Lines (ie Breaks at 31, 61, 91, 121)

    I have yet to see a solid solution about this: I need help making a macro that can insert 6 blank rows, every 60 lines. I have tried the one developed by Kutools shown below, this code will insert 6 blank rows, count another 60 and then insert another 6. This causes my data to break at (61...
  3. X

    VBA Filter Blank Cells filters ALL cells in table

    I am using this line of code ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=1, Criteria1:="<>" Which according to all the forums should filter out all (and only) the blank values. On my sheet it filters ALL of the cells in the table so there are no rows showing, despite having ~50...
  4. F

    Sorting data between blank rows

    Hi, this might be a really simple but for the life of me I cannot figure it out. I have data between blank rows and I wish to sort the data between each blank rows A-Z. So each section of data between the blank rows to be individually sorted A-Z and BLANK ROW DATA DATA DATA BLANK ROW DATA...
  5. D

    Help to Auto Hide Blank Cells

    Hi All, Hopefully someone will be able to help with this. I have a workbook set up that contains a "master" worksheet where I am inputting sales orders. There are then other worksheets for each factory that we source products from. I have set it up to automatically pull the relevant data from...
  6. R

    Use VBA to paste 6 cells of data into blank rows on another sheet.

    I have a sheet ("Milestones") with 5400 rows of data across dozens of columns. I already have VBA code that will add 3 blank rows below each original row of data. Now I need to paste into 2J-4K, 6J-8K, etc., of the new blank rows in the Milestones sheet, 6 cells of data that reside in Sheet...
  7. D

    Inserting blank rows between data, but ignoring hidden rows

    Good morning forum, I am tiring to insert blank rows between a range of rows, but need it to skip over hidden rows. Below is what I have started with and the inserting is working fine. Thanks in advance. Sub Insert_BlankRows() Dim MyRange As Range Dim iCounter As Long Set MyRange...
  8. M

    Autosum every certain rows

    Hello everyone, I am looking for a way to run this macro on a determined starting point not only on "m3137" but for example if I am in "A3194". It may be worth to mention that I added blank rows to make navigation easier and to have a cell to do the sum. This is the code I used: Sub...
  9. 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...
  10. B

    Adding up to 10 rows of data, but automatically ignoring blank rows

    Hello all, I am new to this form and wish I had joined awhile back. If we were to rank my Excel skills by the United States Class system, I would probably be cresting Upper-Middle class; so very good, but not an expert yet. I have been working on a project for work that my coworkers are very...
  11. C

    Macro Help - Export Template Data with Multiple Sections into New Workbook

    Hi guys, I have a blank template that contains many rows for data. Whenever someone fills out the template, there can be any different number of rows filled out. I am trying to write a macro that, when clicked, will know which rows are filled out with data and which are not, taking only the...
  12. E

    VBA Code to Count and Total the Number of Blank Rows

    Hi. I'm looking for VBA code that counts and totals the number of nonblank rows between data in column F of my spreadsheet. The issue that I am having is that the number of rows is not consistent. For example, the data looks like this: F1 $1,200 F2 blank...
  13. J

    SUM Unbtil Next Number

    Hi Below is 2 data fields, the first data shows current data and subsequant, I did ask a earlier question about getting it show on the individual ID's which was answered ( thanks!) what I ned is for it to add up. SO for order 3 there was actual 3 items and the quantities were 123 each, I need on...
  14. Y

    Count If/ SumProduct is including blank rows

    Having trouble, I do not want the blank rows counted that do not have data yet, but the list constantly grows. I want it to give me a count of people who have a number in column R that is equal to or less then 199 and in Column S equal to or less than 82, but not count rows with no data. It...
  15. M

    Filter out blank rows in a table with VBA

    I have a workbook that is being used by novice excel users. There are three sheets where they enter information from three different sources to be compared. The columns are always the same but the number of rows is never the same. In a hidden sheet I have created links to combine all the...
  16. M

    Hierarchical data structure in pivot - blank rows

    Hi there So I have a dataset with a structure in style of: <code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif...
  17. C

    If value false, look in next cell

    Hi, I want a formula that will look in a table, and return a value if a condition is met, and if the condition is not met, searches for the next entry that fulfills the criteria. For example, if an entry is classed under "Pizza", I want it to pull through the details of the pizza, "Topping"...
  18. S

    Find a small amount of data amongst a lot of empty cells

    Hello everyone, One of my datasheets by necessity ends up as about 25,000 rows long, but only about 40 of those rows have data in. The rest of the rows are empty. If a row has data in, there will be data in every column on that row, for example if row 2 was not empty, there would be data in A...
  19. joshuafournier

    copying and having blank rows...

    Good Morning, i have 2 sheets one i copy data from "Log transfer" , and the other i copy data to "Log" in a table. since everyday someone will be transferring this data i was hoping to get rid of the blank rows. or atleast put the blank rows at the bottom. i have the rest of the sort how i...
  20. M

    VBA: deleting rows returned blank by a function

    Hello everyone, is there any possible way to set up a macro that will delete rows that were returned as blank from a function? I am putting together a book database and I want to have separate sheets for languages, genres etc. I decided to create a "General" sheet for all the info and then use...

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
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 "".
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