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!
Bookmarks