|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Help Please -- How can I auto populate all "Yes" inputs in another tab?
I have 10 tabs in my Excel workbook, each with a different inventory category.
I want the first tab to automatically populate all the "yes" responses in a Yes/No column on the other tabs if I need to examine an item in that tab. How can I do that? So Tab 1 Is a Master Inventory Inspection List Tab 2 is Fruits (with multiple rows of differnt types of fruits) Tab 3 is Veggies (with multiple rows of different types of veggies) If an item on tab 2 or 3 is flagged "yes" in a yes/no column, I want to auto populate it in the master inventory tab so I quickly know which ones need my attention. Can someone help?? Thank you! |
#2
|
|||
|
|||
Your workbook design is counterproductive!
You need a main data input table, where you enter all inventory entries - with column for category. When list of categories is limited and fixed, you can define Category column cells as Data Validation List based on categories list. Otherwise it's better you have all Categories listed in separate table on separate worksheet, and create a Dynamic Named Range based on this table. Then you can define Category column cells in main table as Data Validation List based on this Named Range. (Using Data Validation List prevents errors when you enter category for entry.) Now you can use Autofilter on main table, to display only entries of certain category, or only entries with 'Yes' or 'No' as response or whatever combination of column values you ever want to define. You also can design various report sheets. E.g. a sheet, where you select category and response, and an ODBC query returns matching records from main table. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data? | Hoser | Word | 1 | 03-17-2017 03:47 PM |
Embeding Excel Docs in Word - Receiving Memory Error Message if Excel is open | kdash | Word | 0 | 05-06-2015 09:38 AM |
How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet? | ADubin | Excel Programming | 3 | 02-08-2015 04:57 AM |
[Excel 2007] Building Power Point Slides from data in an Excel Table | bremen22 | Excel Programming | 1 | 08-07-2013 11:01 AM |
Excel 2011 can't open old Excel 98 or Excel X files | FLJohnson | Excel | 8 | 05-09-2012 11:26 PM |