| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically populate spreadsheets in a workbook
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto populate unused rows from workbook to workbook | Excel Worksheet Functions | |||
| compare 2 spreadsheets and automatically populate fields | Excel Discussion (Misc queries) | |||
| Dynamically populate a Date pulldown menu? | Excel Discussion (Misc queries) | |||
| Populate workbook dynamically?? | Excel Programming | |||
| run vba code dynamically of another add-in workbook | Excel Programming | |||
Threaded Mode
