adjust my existing macro

I don't know how to adjust my existing code to get it to do what I'm looking for. I'd love the help. I am attaching 3 excel files.

lctest-2A.xls = the source data
lctest-2B.xls = the source data after running my macro on it
lctest-2C.xls = the a snippet of the source data after I have manually edited it to show you how I want the macro to operate

the current macro basically looks through column K to find a $... each $ is used as a delimiter. The fields that are created as a result of being split off from column K are then moved to their own rows. Once they are moved to their own rows, data from field A is copied down, Column B is filled with "See also " then the data from column k of the "source row" AND the date which is found in the last 4 characters of column f of the "source row."

the macro I am looking for will have an identical result with the major exception that instead of splitting column K at each & and then moving all of the newly created fields to their own rows, the source row will be kept in tact. So, basically Column K of the source row will contain multiple family names, but the macro will still create new rows with duplicates of the all of the family names (no duplicate of the first listed family name should be created).

This has been difficult for me to explain, so I understand if it is difficult to understand. Please ask questions if you need to. I am attaching the files to give you a visual aid... i figure it will be very helpful.

Here's the current code..

Please Login or Register  to view this content.

Pete

Originally Posted by shg

See attached. Running the macro copies the data from input to output, and then processes.

Thank you thank you thank you.

As far as I can tell this is perfect... i will find out for sure as I work with this data over the next few days.

Thank you!!