+ Reply to Thread
Results 1 to 2 of 2

Table Question

  1. #1
    Registered User
    Join Date
    07-15-2013
    Location
    Diamond Bar
    MS-Off Ver
    Excel 2010
    Posts
    1

    Red face Table Question

    Hello!
    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!

    excel.png

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Table Question

    Hello
    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.
    DBY

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Chart Question and table question
    By nmss18 in forum Excel General
    Replies: 5
    Last Post: 03-17-2009, 08:52 AM
  2. Table Question
    By BrettOlbrys in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-09-2009, 05:08 PM
  3. Table Question
    By Wozniak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-02-2007, 12:55 PM
  4. [SOLVED] Table question
    By Adam Kroger in forum Excel General
    Replies: 5
    Last Post: 11-22-2005, 02:25 AM
  5. [SOLVED] Pvt Table Question
    By lj@spu.edu in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1