software

I just took on a client who sends me a multipage spreadsheet weekly with
movie times for his 10 theatres.
My guess is he just deletes the information from the previous weeks row
and adds a new row. His sheet really only needs about 16 columns and
maybe 20 rows. The sheets he sends have upwards of 1500 rows and
columns.
Many of the rows are in between the actual text rows as well.

I convert this to a webpage and post to his site. Problem is the sheets
are so large they take forever to clean up (in GoLive) and much too long
to do by hand.
Is there an easy way to delete all rows with no text in them?

thank you in advance for any help.--
george edgar------------------------------------------------------------------------
george edgar's Profile: www.excelforum.com/member.php...oamp;userid=34396
View this thread: www.excelforum.com/showthread...hreadid=541759
hi!

sort on any one of the Column..
goto the last row where your data ends...
select the remaining rows amp; delete them....
now save the workbook using SHIFT F12.!

-via135
george edgar Wrote:
gt; I just took on a client who sends me a multipage spreadsheet weekly with
gt; movie times for his 10 theatres.
gt; My guess is he just deletes the information from the previous weeks row
gt; and adds a new row. His sheet really only needs about 16 columns and
gt; maybe 20 rows. The sheets he sends have upwards of 1500 rows and
gt; columns.
gt; Many of the rows are in between the actual text rows as well.
gt;
gt; I convert this to a webpage and post to his site. Problem is the sheets
gt; are so large they take forever to clean up (in GoLive) and much too long
gt; to do by hand.
gt; Is there an easy way to delete all rows with no text in them?
gt;
gt; thank you in advance for any help.--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=541759
great... what about the 100's of rows that are quot;in betweenquot; the other
rows of useful content? On the spreadsheet they are barely visible,
but, once converted to html, you can see there are 60-100 lines in
between some of the rows.

thanks--
george edgar------------------------------------------------------------------------
george edgar's Profile: www.excelforum.com/member.php...oamp;userid=34396
View this thread: www.excelforum.com/showthread...hreadid=541759