Hi archllama,

It is really irrelevant how long your original catalogue sheet is. The
bigger the database, the better the single datasheet structure works
over alternatives. Yours is tiny. I'm not sure you understand that
you CAN very simply see, and adjust, everything relating to a single
bag on a single sheet when you use the single datasheet structure - e.g
through filter drop down boxes. Everything else DOES become invisible.
Virtually no time to set this up. And you CAN "quickly switch to a page
that we might have corrections to enter on" by simply changing your
filter selection from the drop-down box.

Good luck whichever way you choose.


archllama Wrote:
Although I appreciate the suggestion, I don't think putting the
information on a single worksheet will make the information easier to
view and analyzefor our purposes, especially since the original arti
act catalog sheet is 189 lines long. It would be much simpler for
everyone if a single worksheet could equal a bag, because if we try to
stick all the FS#'s on one page, the information actually would become
unwieldy and we would lose the ability to quickly switch to a page that
we might have corrections to enter on.



--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531346