Sorry for the multiple post, trying to send an attachment, not sure how to go about this. I have a strange sort question. In column B there is information every 7 rows. Then you skip 1 row (Blank) Then there is the same information but with different dates in the next 7 rows and so on. Is it possible once there is information in All seven rows to delete that information and move everything thats below it up. Keeping everything together. Without cut, copy and pasting. I know some VB. Thanks in advance. Bob and Richard
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
John Lathe.xls
Description: MS-Excel spreadsheet
