Copy selected data, paste on sheet2, then create a pdf.

[tobiashu]

Hello all,

I would appreciate some help with creating 2 pcs of macros with tha following function:

1, Sheet Equipment List, when rows are selected by checking the check-box in column B(Add to Pick List) and then the button "Add To Pick List" is being clicked, the selected rows column C to I should be copied and pasted on sheet Pick List starting on row 10 from column B to H.

2, Sheet Pick List, when the button "Create an Order" is being clicked following things should happen:

a, A pdf are created with the name (data copied from heading) "Project Location, Project Number, Name, Date.pdf". If it´s possible I want to
choose a location in the code where the file is to be saved, if not possible, a FileDialogFolderPicker. And if the pdf is created without the three
buttons in the heading that would be nice but not important.
b, Sheet Equipment List, update selected rows to "On Project" in column M(Status)
c, Sheet Equipment List, update selected rows with info from heading on sheet Pick List, Date to On Project Date, Name to Responsible, Project
Number to Project Number and Project Location to Project Location.
d, Sheet Equipment List, uncheck the check-boxes in column B(Add to Pick List)
e, Sheet Pick List, clear pick list from row 10..

Take care..

[sintek]

I changed your setup slightly...Got rid of sloppy Check Boxes...
Replaced with code to click selected row in Col B...A Tick appears and one can then filter...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[tobiashu]

Hi Sintek,

Everything is now working as I want it to, your main code did the trick, a nice way to end the week

Thanks and enjoy your weekend..

/Tobias

[sintek]

Pleasure Tobias...Thanks for rep +

[tobiashu]

Hi Sintek,

I´ve actually have one more problem with this one..

When I put in a project number like 4:88 and then run macro "PickList_Rektangelrundadehörn1_Click2" I get run fault, can you please help me out? It looks like : is the problem..

Thanks
Tobias

[sintek]

That is because you are making use of an illegal character in save path : cannot be used...
https://www.mtu.edu/umc/services/dig...racters-avoid/

[tobiashu]

Hi again,

Thanks, I should know that, removed -> all good.

Cheers
Tobias