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

 

[Sawright]

That is correct, Just add number too it. Also not sure if I screwed-up, but it only seems to work once, the second time I ran it it with different choices it created sheet but blank.

OH, sorry go Enjoy your Christmas! I appreciate it

 

[skorpionkz]

-Not sure you could insert project name at top also of instead of listed in header.

Not sure what you mean.

Could you please send the picture for the header?

 

[skorpionkz]

Guys I stack in this code

I have prepared all project generator, but I can't figure out how can I copy picture from one header to another (or inserted picture from cell to the header in each new sheet created if this is easier)

If any one know the way how to do it please advice

Regards,
Andrzej

 

[Sawright]

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

The header like in "checklist" When information copied the header didn't get copied.

 

[skorpionkz]

Check this one. The only thing I was not able to add is the Logo in the header

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

 

[Sawright]

What if logo was just at top of page instead of in the header, would that make a difference? I appreciate it

Thanks


Andy

 

[skorpionkz]

will try

 

[skorpionkz]

Try this one:

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

 

[Sawright]

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!

 

[Sawright]

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