+ Reply to Thread
Results 1 to 6 of 6

Using tick boxes to create a "quote" on another worksheet

  1. #1
    Registered User
    Join Date
    08-25-2015
    Location
    Australia
    MS-Off Ver
    2007
    Posts
    3

    Using tick boxes to create a "quote" on another worksheet

    Please can someone help, I'm still learning. If i have a "main" sheet with all options listed with prices - by using tick boxes, it creates a quote out of the options 'ticked' onto another sheet by inserting the lines and pricing. Is it possible to do this?

    Any assistance will help.


    Thank you

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Using tick boxes to create a "quote" on another worksheet

    Would you only ever have one of each selected option copied over to the "quote" or could there be multiples of a given item?

    BSB

  3. #3
    Registered User
    Join Date
    08-25-2015
    Location
    Australia
    MS-Off Ver
    2007
    Posts
    3

    Re: Using tick boxes to create a "quote" on another worksheet

    Thanks for replying, just one of each item selected

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Using tick boxes to create a "quote" on another worksheet

    Attached is a VERY basic example of how this can be done.

    It uses a "helper column" (B) on the "Main" sheet to count which boxes are ticked (it actually counts the number of "True" in column C, but I've made the text there white to hide it).

    The item name and cost details are then fed into the "Quote" sheet using an INDEX/MATCH lookup formula, but this could also be done using VLOOKUP.

    Hope that's something like what you meant and at least points you in the right direction.

    BSB
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-25-2015
    Location
    Australia
    MS-Off Ver
    2007
    Posts
    3

    Re: Using tick boxes to create a "quote" on another worksheet

    Thank you that is awesome, and definitely points me in the right direction. I thought it may be way trickier than that and i was way over my head.

  6. #6
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Using tick boxes to create a "quote" on another worksheet

    There are ways of doing it that are slightly trickier. They would negate the need for helper columns, but there's no point in overcomplicating something if it means you won't understand how it works when it comes to maintaining it.

    Shout if you need more help with this.

    BSB.

+ 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. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  2. Replies: 4
    Last Post: 02-20-2014, 02:24 PM
  3. Select/Delete worksheet "Text Boxes" using VBA
    By ConneXionLost in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-12-2012, 06:55 PM
  4. Replies: 1
    Last Post: 07-10-2012, 12:36 PM
  5. [SOLVED] create links to check boxes marked "good" fair"and "bad"
    By pjb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2006, 09:25 PM
  6. How do I create a "Yes / No tick box"?
    By noceps2 in forum Excel General
    Replies: 1
    Last Post: 03-04-2006, 01:56 PM
  7. [SOLVED] cells formatted to tick when text value "Y" if or null if "N"
    By Jay in forum Excel General
    Replies: 7
    Last Post: 01-13-2006, 05:20 AM

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