Need help with a formula/vba script

[Jerryb]

I have a worksheet that has 5 fields ie.
<caseno.><type><chap><partyinfo><date>


I need a formula/application that will copy and paste each record int
a sperate worksheet same fields except <party> I need <Firstname
<Lastname>and <address> <city> <state> <zip> <ssn> which come from th
first 4 records of the <party> field. and then loops to next recor
being the next caseno. and so on. I would really appreciate any help
Thank you

 

[Mark E. Philpot]

Please send a sample sheet of this project. I will create
a userform to do this deed. You can view some of my
handiwork at:
http://au.geocities.com/excelmarksway

listboxviewer.xls will show upto seven columns wide. Each
cell is placed into a text box then you can output this to
a separate sheet. It may not be what you want but it can
be modified to suit. Else I can do something else that
suits your needs.

regards
Mark E. Philpot
ps I am not an expert.