+ Reply to Thread
Results 1 to 3 of 3

questions about a table im making

  1. #1
    Registered User
    Join Date
    08-02-2013
    Location
    MIami
    MS-Off Ver
    Excel 2007
    Posts
    8

    questions about a table im making

    Hi, im making a table for a shipping company, making the table itself was easy, but I want to do something a little extra.
    The table headers are as follows:
    Port of Loading City Carrier 20' 40' 40'hc Security for 20' security for 40' security for 40'hc ....
    Miami Buenos Aires Sas express 5 10 15 2 4 6


    The 20's and beyond have values, the problem i have is that
    the customer would pick for example that they want a shipment of
    20' crate, so in the table they can pick the 20' and the table would calculate
    the price for the values that correspond with the 20', or better yet, you can
    click the values that are part of the order, and the ones that are picked
    are valued together so that the customer can have an estimate of the cost.
    I dont know if this is very helpful or not, but I wanted to do this extra thing
    and im hoping you guys can help me

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: questions about a table im making

    I would reformat the first table to use a pivot table and slicers but it wouldbt be hard to create a little dashboard for this.
    Either way posting a text description of your data set is always garbage. You are much more likely to get help if you post a sample of your data set if it is large, and of course desensitized of private information.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: questions about a table im making

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. pivot table questions
    By JR in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2006, 01:45 PM
  2. Pivot Table Questions
    By William Elerding in forum Excel General
    Replies: 3
    Last Post: 10-15-2005, 04:05 PM
  3. pivot table questions
    By Gary Keramidas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2005, 04:05 AM
  4. [SOLVED] Pivot Table questions
    By Dave in forum Excel General
    Replies: 0
    Last Post: 08-22-2005, 07:05 PM
  5. Making progress with array functions, another two questions
    By Don Taylor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-04-2005, 05:06 PM

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