I am beginning to learn how to use Excel, so please be patient with me.
I have these two tables, like the picture shows.
I would like to know if anyone can tell me how to get the "food" items to generate in the second table without having to enter them manually?
For example, if I were to enter 3 food items out of 10 entries, on the second table, those food items would appear.
Any help would be greatly appreciated!
Re: Table Question
A Pivot table based on your original table would probably be the easiest option. You could then filter by whatever Category you wished and as your source is an Excel Table the Pivot would expand dynamically with it once refreshed.
Hope this helps.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By nmss18 in forum Excel General
Last Post: 03-17-2009, 08:52 AM
By BrettOlbrys in forum Excel Programming / VBA / Macros
Last Post: 02-09-2009, 05:08 PM
By Wozniak in forum Excel Formulas & Functions
Last Post: 03-02-2007, 12:55 PM
By Adam Kroger in forum Excel General
Last Post: 11-22-2005, 02:25 AM
By firstname.lastname@example.org in forum Excel General
Last Post: 08-04-2005, 09:05 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1