Is there a way to? If B2 thru B8 is complete with all information then Delete info and send to Sheet 2. With B2 thru B8 now empty then more everything up. Keeping everything together. Same thing with rest of info. For example if B18 thru B24 is Incomplete and B10 thru B16 is complete then Delete and send to Sheet2 then move everything up. By putting the code in a command button? Once clicked will update form? But don't know how to write the code. Please see attached file. 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 [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
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
