Sounds like you want to do it yourself so I won't do it for you. The best way
is to do it through a macro and the best place to look is here. You will just
need to break it down into sections. A user form might be the easiest and
most user friendly with drop-down boxes. Next you just need to know how to
change sheets through code, how to find the last used row. If you have any
questions just post or send a message. I suggest the userform as it will make
your coding MUCH easier.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"peashoe" wrote:

If I have workbook A that has Sheet 1, Sheet 2, Sheet 3, whe
- Sheet 1 has a list of information like:
ISBN, Title, Unit Cost, SAS (Y/N), LOB (Y/N)


Is it possible to do the following:
- If a user adds Y to the SAS (Y/N) column, I need it to populate
Sheet 2 with ISBN, Title, Unit Cost for that row
- If a user adds Y to the LOB (Y/N) column, I need it to populate
Sheet 3 with ISBN, Title, Unit Cost for that row

I just need to know if it's possible and if so - would I be using
Macros or VB? and can anyone recommend any good books or online books
that would be able to help me?

Thanks in advance
Lisa