Dynamically populate spreadsheets in a workbook

[peashoe]

If I have workbook A that has Sheet 1, Sheet 2, Sheet 3, where:
- 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

 

[Guest]

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.

 

[Dan R.]

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

 

[Guest]

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 (e-mail address removed)

--
regards,
Tom Ogilvy


..

 

[peashoe]

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