+ Reply to Thread
Results 1 to 3 of 3

Exporting an output cell into a table

  1. #1
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    Exporting an output cell into a table

    I'm currently working on a excel worksheet, and have been having issues trying to figure out how to export the output cells into a table format. I want to be able to have a table generated with all the possible variations that I've inputted. Is this possible or do I have to generate the table by hand? For example, I have a part with multiple options. I've created a chart that has each variable set up for a drop down list and the final cell with the part number (the output cell) changes based on what I've selected for the variables. Is there anyway to have that output cell generate a table that lists all the options?

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,077

    Re: Exporting an output cell into a table

    It would be easier to work out a solution if you could attach a sample of your workbook. Remember to remove/replace any sensitive data before uploading.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Exporting an output cell into a table

    Thank you for your reply. I've attached the tables I'm working with.
    Attached Files Attached Files

+ 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. [SOLVED] Output Text file is empty while exporting from excel table using macros
    By arry0207 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-08-2013, 08:08 AM
  2. [SOLVED] Comparing two cells for similarities and output a third cell (if C1 = B1, then output A1)
    By PERFECT777 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-26-2013, 12:37 AM
  3. Controlling output format when exporting to text
    By RonaldHollander in forum Excel General
    Replies: 2
    Last Post: 04-10-2013, 09:51 AM
  4. [SOLVED] Paste variable output (SQL Output) into a single cell.
    By fblaze in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2013, 06:24 AM
  5. [SOLVED] Exporting Access table to Specific file/cell
    By Kinez101 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-17-2012, 08:48 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