This forum has saved me before...but this next request may be unrealistic.
I have a 4-column
worksheet -- an index to a 19th century guardians' docket.
Column A is a name (ex. Linn, Noah C)
Column B is a descroption (ex. guardian)
Column C is a volume number (ex. 1)
Column D is a page number -- or a series of numbers (ex. 2, 4, 5)
Column D is the problem when there is more than
one page number. Ideally, there should be a unique record for every page number.
Thus, the entry:
Noah C guardian 1 158, 187
...should ideally be:
Linn, Noah C guardian 1
Linn, Noah C guardian 1 187
...so that I can save this file as a .cvs document and easily import it
into my database program that will let me retrieve each record and display an image of the real document...as long as a
single number occupies that field.
This, I have about 800 lines of a worksheet that look like this:
French, Alfred heir 1 16, 18
French, Susan heir 1 16, 18
French, Francis guard 1 16, 18, 40
etc.... Some records have as many as four or five different page numbers.
I have already found out how painful it is to have to insert new rows and then copy/paste relevant info, edit the
page field etc.
Is there any part of this process that begs for an automated solution? Even the automatic
insertion of rows after each record with multiple entries in the page field would be a timesaver, and I suppose I can manage
that by manually pointing and assigning a macro to insert rows and copy the preceding record. But I always dream of something
better, something more elegant...to solve my problem in one fell swoop.
Wanting to avoid carpal tunnel...
Thanks for your consideration.