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

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

Lisa,

This is similar to what you're trying to do:
http://www.contextures.com/xlOrderForm01.html

Excel 2003 Power Programming with VBA
by John Walkenbach

--
Dan

This can be done using just formulas. It will be a lot easier than trying
to program to account for the user deleting rows, changing their mind marking
in a different column or marking in both columns by mistake (if that is a
mistake) and so forth.

The disadvantage of the formulas are that they will slow down calculations
if they have to address a lot of rows of data.

if you need a sample workbook contact me at

--
regards,
Tom Ogilvy


..



"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

John/Dan/Tom
Thank you so much for repliying - it's not that I "have" to do it
myself I just didn't want you to waste your time and efforts to find a
complete solution when I have no idea what the customer wants yet. I
looked at the example that Dan provided and it looks like it's at
least possible. Once I get all the requirements - you will definately
be hearing from me here :)

Thanks again!
Lisa