Command button to transfer multiple data to other sheets, saving in PDF, send email

Hi all,
I have attached the dummy sheet.
It is a bit complex ( for me) to achieve certain functions.
All is explained in the attached file.
Since I am learning, all seems too challenging for me or i am expecting too much. I dont know.
i have been on it for some time and can not find a solution.
I am very fortunate that so far I have been helped by many members and my words will fall short to thank them.
It may be bit similar to what I have been trying to achieve, however this is a different approach to it, hence a new thread now.
I am sure that there must be simple way of doing it.
( I can not figure out on how to attach tags.... basic though, but I will hopefully figure out in my next thread)

Please help me.

kind regards

Hi JB Sir,

Fantastic help from you. There is too much to learn for me. It is progressing fine. I will let you know the outcome in a week.
Hopefully I am able to make use of this information to achieve my goal of learning and progressing.
Thanks again Sir
Kind regards

Hi JB sir,

I am still having issue with the PDF and saving file. Actually I am making errors in getting the things right.
The entire issue is with my understanding and that will be resolved by more learning & practice.
Your solutions are absolutely perfect.
Since the original query has been resolved I am closing this thread.
Once again my words will ever fall short to thank you.
I have really liked your way of explaining, as it is easy to understand and implement.
Many thanks again
Kind regards

Hi JB Sir,
I was unwell for some time, and could not continue with my work. I did started from scratch and have almost got back on track with all the great help that I got from you.
Now however I am getting a error message 400 for both the PDF and email issue.
Apology for reopening this thread, with hope that I will again get your help.
Many thanks
Kind regards

Hi JB Sir,
I constantly get ERROR400 when use the code .
Possible explanation can be.....

Form already displayed; can't show modally (Error 400)
You can't use the Show method to display a visible form as modal. This error has the following cause and solution:
You tried to use Show, with the style argument set to 1 – vbModal, on an already visible form.
Use either the Unload statement or the Hide method on the form before trying to show it as a modal form.

Cant understand this.....
Can you help please
Thanks

There is no suggestion given... That is the issue.

To be honest I dont know how to deal with this

Hi JB Sir,
I am getting there. I have amended the code. Please see if this is what you are suggesting. I have not tried the amended code unless I cross check with you.

Please Login or Register  to view this content.

Dear JB Sir,
I have given up now. I use outlook for emails. Earlier everything was fine, however it does not work now.
In a way it does save file in the folder, however does not attach it to email ( generally it used to open the email outlook with this file attached).
Now it shows error400.
Just cant understand. I have given up. Please help.
Regards

Hi JB Sir,
Thanks for leading me to the answer .... and not give me the answer.
This has helped me a lot to learn.
For me you are like my Guru... a tough one though.... But it should be that way so that we all can learn rather depend upon a ready made answer.
Thanks again for your help.
Kind regards

You are right.
I am a slow learner and more so a small set back due to sickness.
Well , never say never.
My learning continues.
Thanks JB Sir again.