Design Quandary

[Lena Scull-Anderson]

I recently began working for a photo gallery that sells 200+ limited edition (25, 95, or 500) images. We need to improve tracking of the prints as they are purchased.

Currently there is a simply a list of images with a few notes per item on each row. It is not consistent and has been poorly maintained.

My first attempt was to create an index with all the titles hyperlinked to (sigh) an individual worksheet for each image. You guessed it...waaaaaaay too long to save/close.

All I can see at this point is one huge worksheet or 200+ small workbooks, both using hypes.

Any suggestions? Thanks,

Lena

I'm not a power user...I just smell that way.

[etaf]

sounds like you probably need to use access as a database

however, you could in theory just have a list on one sheet
then you could always use filter to find the details

[Xx7]

I would have one main workbook (attached) and link each title to their own separate workbook. You need a macro to loop the folder and populate the hyperlinks.