+ Reply to Thread
Results 1 to 3 of 3

Create a table with hidden items

  1. #1
    Registered User
    Join Date
    05-16-2020
    Location
    venezuela
    MS-Off Ver
    2013
    Posts
    1

    Create a table with hidden items

    Hello Guys

    I am not an expert with Excel and I need help doing this:

    It is something basic and I think is possible. I want to create a table with two columns and diferents rows where the first colomn and the first row is going to have a text "Enter your house name" and the second column first row its going to be the place where my users is going to enter the house name and depending of the name is going to appear information like house color, numbers of the rooms in the house, numbers of bathrooms in the house; etc

    It is something basic and I know that with microsoft access is possible but I don't know if I can with excel. Someone can help me?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,675

    Re: Create a table with hidden items

    Welcome to the forum.

    You have posted in the Access forum but are asking about Excel - shall I move this for you?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    1,284

    Re: Create a table with hidden items

    If it is going to be more than one entry you are better advised to have the data in a tabular format.
    i.e. the subject/question as the header of each column.
    Capture.JPG

+ 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. Create a table/pivot table using different items items from a column
    By stevetton in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-28-2016, 10:30 PM
  2. Macro to create Pivot table with details hidden(Grouped) at first.
    By ronanm in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-30-2011, 07:22 AM
  3. Create Pivot Table in Hidden Sheet
    By pmguerra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2009, 07:04 AM
  4. Replies: 1
    Last Post: 04-05-2006, 11:25 AM
  5. showing hidden items of a pivot table in a cell
    By macca666 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2005, 05:02 AM
  6. [SOLVED] Pivot Table unable to Include Hidden Items In Subtotals
    By TC319 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-24-2005, 05:06 PM

Tags for this Thread

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