Coloumn A = Book title
Row 1 = Dates
Range B2:Z10 = names (example: BH/Harvey 10 or AG/Cherry 7)
The names could be in the range approximaly 12 times
I am trying to extract a list of the name, date and book title.
Example.
BH/Harvey 10 Book title 1 01/01/01
BH/Harvey 10 Book title 2 05/02/01
BH/Harvey 10 Book title 3 16/03/01
Hope this explains what i'm after.
Thanks in advance for any help.
thanks.
Bookmarks