Help in creating a function or macro to run on data

[Sawright]

I need help badly

I'm trying to create a checklist that is specific and develops the populates the checklist based on decisions the user chooses on the first sheet "Choose" For simplicity lets say on sheet label "choose" I have in column 'A' the following: Apple, Pear, Watermelon and next to each of them in column 'B' I have a box for them to place an "X" There is a separate sheet labeled the same for each "Apple, Pear, Watermelon" Each of those sheets contain data in cells from A1:D20

So a user goes to sheet "Choose" and places an X in box next to Apple and Watermelon Then hits control 'R' Or whatever function:

I then need it to go to the "Apple" sheet and copy A1:D20 data and paste it on a new sheet labeled "Checklist" Then paste the same for "Watermelon" on the same sheet "Checklist" under the Apple information without any spaces or rows between them.

Is this possible?


Thanks so very much

 

[skorpionkz]

WOW you are awesome!! That is great If I want to add more sheets of information where do I add them just add a sheet and a line on choose page.

Thanks so Much!

Check the link. there is now Module 2 which will add ActiveX CheckBox for the new products. Just add new products you need and activate this Module. Then add new sheet with information about the product.

When you creat checklist project and date covered by logo If its centered over Column it works

I aligned the Project name and Date to the right, this should sort the problem.

https://www.dropbox.com/s/ozfupn1sjgnr0m3/Huck%20JHA.xlsm

 

[skorpionkz]

I aligned the Project name and Date to the right, this should sort the problem.

Also the Logo will fit between columns A-D

 

[skorpionkz]

I aligned the Project name and Date to the right, this should sort the problem.

Also the Logo will fit between columns A-D

 

[Sawright]

Very NIce Thanks again for all your help!!!