Definitely not what your original post asked for.

email me the workbook if you wish.

Change the AT and DOT to get my address.

I'll have a look at the layout and see what can be done.


Gord

On Tue, 19 Jun 2007 17:08:10 GMT, "SaraJane via OfficeKB.com" <u34526@uwe
wrote:

Thanks again for your input - I think I have done a poor job describing what
I need. I converted a PDF file to excel and there are hundreds of records
with lots of corresponding data. The data ranges from column A through
columns U. There are anywhere from 10 rows to 23 rows in each record. I want
to have each record span 24 rows. So for those records with only 10 rows I
want to add 14 rows at the bottom of the record (i.e.Record X ends on row 10
I want to insert 14 rows so that it will end on the standard of 24th rows or
row 34 and have data in columns A through U)

Gord Dibben wrote:
Just as an alternate method of deleting blanks.

Select column U and F5SpecialBlanksOK

EditDeleteShift cells up.

Gord

My mistake............left out the Shift:= xlUp

[quoted text clipped - 58 lines]
in column U and have there be 24 lines between entries. I need to insert the
lines just above the next entry.