+ Reply to Thread
Results 1 to 3 of 3

Make fields clickable to sum up data

  1. #1
    Registered User
    Join Date
    11-22-2011
    Location
    Kingston, Ontario
    MS-Off Ver
    Excel 2003
    Posts
    6

    Make fields clickable to sum up data

    I have an excel sheet that is used for pricing out new inventory. I want to be able to make all the fields clickable so that our sales guys can click on the options they want and have it sum up the cost in a box.

    I want the salesmen to be able to click "Coloumn A" or "Column I" and have it populate with a check mark. I then want the data that is in "Column G" and "Colum O" to be sum'd in a box at the bottom giving a total price.test.xls
    Thanks
    Matt

  2. #2
    Registered User
    Join Date
    11-22-2011
    Location
    Kingston, Ontario
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Make fields clickable to sum up data

    IS this even possible?

    ---------- Post added at 12:45 PM ---------- Previous post was at 12:35 PM ----------

    I have been able to put a box in each field that when clicked on puts a check mark in it. Now i need it when the box is checked to grab the data from another cell and sum all boxes that are checked into a cell at the bottom of the page.

  3. #3
    Forum Contributor
    Join Date
    07-05-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2016
    Posts
    165

    Re: Make fields clickable to sum up data

    Could you please post an updated sample.
    Click on the * icon if this post has been helpful.

+ 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