blank rows

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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"...
  16. 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...
  17. 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...
  18. 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...
  19. J

    Only delete rows when whole row is blank

    I have a real problem with a file I'm working on. It has invoice numbers in one column, followed by payment milestones. In the row underneath, there is an 'x' to mark if payment was made in a particular zone, e.g.: <TABLE style="WIDTH: 480pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0...
  20. S

    Last non-blank row in a column part 2

    Hi, Apologies if this has already been asked, but I'm after a reasonably concise (and non-VBA if possible) way of identifying the row number of the last non-blank row in a set of rows from a given position (like the line number of the last word in any given paragraph of text on page with 20...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top