blank rows

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

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

Hi All, I have trouble in organizing few data. I have data in single column which is unevenly pasted in different rows, below is the example. <TABLE style="WIDTH: 412pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=549><COLGROUP><COL style="WIDTH: 412pt...

Hi - I am trying to run a very simply query that graps three columns of data from one worksheet and posts it to another in the same Workbook. This works fine. I then try to add a sort into the query so that the data is sorted by the third column. This works - but the returned data has several...

Dear Excel Experts, Forgive me if this has already been asked, but I've searched for a solution for my problem without much success. Everyday at work, I have to do a data sort by three categories. After that, I have to manually put in extra blank rows to separate one specific column. Is...

I created a pivot table that generated around 35,000 pivot table rows. I then greatly reduced the data and refreshed the pivot table so that it only generated around 200 rows. However, it looks like the 34,800 unused rows below the pivot table are still somehow allocated by the pivot table...

Some of today's earlier posts discussed this, but I wasn't able to apply them successfully to my issue. I have an area for comments in a sheet titled "Arbitration" (list in cells AB2:AB15--cell 2 merged with 3, 4 with 5...14 with 15). On another sheet titled "T.O.C." I have cells C6:C12...

Hey, I have a sheet with a blank row between entries, but many of the entries are the same (Customer/Destination/etc). I would like these entries to autocomplete as if they weren't separated. eg. Entry1 | Entry2 | Entry3 | Entry2 Where "Entry2" should autocomplete...

How can I remove multiple blank Rows after importing data without choosing 2000 different blank rows individually?

I have a 2d range which has some blank rows in it. I would like to be able to take the non-blank rows and consolidate them as a contiguous block in another range without disturbing the original table. Any ideas, anyone?

My main sheet has the results of a competition in rows 1-100. 75% of the results won't count for the jumpoff ( its a horsey competition) and I want to automatically copy the successful details to another sheet. I've worked out how to to omit the unsuccessful results by using an IF statement ( IF...