I will be happy to help you with this. Do you have the file available that you could send (let me know if you need help uploading files on this site)
Ok go to http://www.wikisend.com/ and upload the file (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.
If the file has sensitive information let me know before you upload it
I got the file, thanks
Ok which column should determine if the row will be included in the new sheet.
So that means if there is ANY value in columns B thru J then that whole row will be copied, correct?
hmm. Looking at the current table all 20 rows will have to copied since there is no row that has ALL the cell in column B to J blank. Doesn't make sense.
I think you need to walk me through one example and tell what exactly needs to be copied
Where did you tell me all that before, or was I supposed to have guessed it? Why should it take 10 or so posts to get this crucial info.
.At this point you should consider accepting and I will continue with the work
No problem. Good luck