+ Reply to Thread
Results 1 to 1 of 1

populating data from another sheet using a checkbox.

  1. #1
    Registered User
    Join Date
    08-07-2009
    Location
    Honolulu, HI
    MS-Off Ver
    Excel 2003
    Posts
    16

    populating data from another sheet using a checkbox.

    Hi!, I have a question, i'd like to know how I could go about populating data from a another sheet based on if a checkbox is checked.

    I have attached a spreadsheet explaining my goal.

    I don't care if it's a formula or a macro that accomplishes it. I currently have a spreadsheet macro that crunches the numbers for me, i'd just like to be able to add a checkbox that says if this box is ticked, then copy all the contents of sheet2!a1:z1 to sheet1, then if checkbox 2 is also checked, copy sheet2!a1:z1 to sheet1 then the line copy sheet3!a1:z1 to sheet1 starting the next line after the contents from sheet 2 was filled in.

    It sounds confusing but my spreadsheet has a scenario to examine.

    If you can help please let me know!

    Thank you Excel Guru's!
    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