+ Reply to Thread
Results 1 to 4 of 4

how to use 'x' boxes and select values

  1. #1
    Registered User
    Join Date
    10-03-2011
    Location
    ashton-under-lyne, Tameside
    MS-Off Ver
    Excel 2003 pro
    Posts
    8

    how to use 'x' boxes and select values

    Hi

    I have used excel spreadsheets for very basic calculations (+,-,x and /, %ages etc) so I am new and would like to ask a beginers question:

    How do I use 'x' boxes to select values - for example, if I have a list of foods with nutritional data, rather than copying the rows of data into another sheet can I put a 'x' box beside it and select the data that way?

    also, I have foods listed from a to z and when i select a food i need the data to appear on another worksheet - how is this done? E.g. in my 'm' list i select mustard (by ticking the box) and need the data to apear on a food log which will be on a separate sheet - kcals, fat, carbs etc

    any help appreciated

    thanks in advance

    Andy

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: how to use 'x' boxes and select values

    Hi Andy and welcome to the forum,

    I believe you could simply put a column next to your food data and simply put an X in this column to show this food is part of the whole.

    What you really need to do is show us a sample workbook with your data. You then need to attach that sample file to a message so we can see what you already have.

    To attache a sample file, Click on "Go Advanced" below this message and then on the Paper Clip Icon above the advanced message area.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    10-03-2011
    Location
    ashton-under-lyne, Tameside
    MS-Off Ver
    Excel 2003 pro
    Posts
    8

    Re: how to use 'x' boxes and select values

    this is the attachment you asked for

    at the moment I have my foods listed a-z with nutritional data. the 'LOG' worksheet is where no. of calories is to apear, once i can do that i can calculate fat percentages etc

    in the a-z of foods i want to be able to select the data with a 'x' (in a box?)

    sorry - it's the last 5 columns i'm after in the a-z's. I haven't put the headings in yet! ie. kcals, carbs, fat etc
    Attached Files Attached Files
    Last edited by temple-Lobe; 10-03-2011 at 05:21 PM.

  4. #4
    Registered User
    Join Date
    10-03-2011
    Location
    ashton-under-lyne, Tameside
    MS-Off Ver
    Excel 2003 pro
    Posts
    8

    Re: how to use 'x' boxes and select values

    I've updated the workbook so it makes a little more sense - the nutritional data is now itemised by column
    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)

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