Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-12-2020, 12:53 PM
KJSK71 KJSK71 is offline Excel Help Please -- How can I auto populate all "Yes" inputs in another tab? Windows 10 Excel Help Please -- How can I auto populate all "Yes" inputs in another tab? Office 2019
Novice
Excel Help Please -- How can I auto populate all "Yes" inputs in another tab?
 
Join Date: Jan 2020
Posts: 2
KJSK71 is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 01-13-2020, 12:19 AM
ArviLaanemets ArviLaanemets is offline Excel Help Please -- How can I auto populate all "Yes" inputs in another tab? Windows 8 Excel Help Please -- How can I auto populate all "Yes" inputs in another tab? Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Excel Help Please -- How can I auto populate all "Yes" inputs in another tab? How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet? ADubin Excel Programming 3 02-08-2015 04:57 AM
Excel Help Please -- How can I auto populate all "Yes" inputs in another tab? [Excel 2007] Building Power Point Slides from data in an Excel Table bremen22 Excel Programming 1 08-07-2013 11:01 AM
Excel Help Please -- How can I auto populate all "Yes" inputs in another tab? Excel 2011 can't open old Excel 98 or Excel X files FLJohnson Excel 8 05-09-2012 11:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft