copy to SumSheet, Save new tab, save as Pdf

Hi there Gurus.

I made an excel sheet and was hoping to have one button to do all I need - where I have like 4 Buttons. (Going on Maternity soon and replacement does not know a lot about excel)

What is to happen in the Spreadsheet:

Person fill in only on the SUMMARY PRINT SHEET (grey is Formulated; Green is where they may Tipe)
After filling in They must press "THE BUTTON" to do the following:

Selected Cells to be copied to the Summary sheet (See yellow cells in Summary sheet - Where the Data must go)
Then The SUMMARY PRINT SHEET must be saved to a new Tab (Like in Example), with the Date (D3) as the name of Tab
THEN the page is to be SAVED AS PDF (Person who will use this is not Excel skilled)

Then lastly, wil press the Clear sheet Button to clear the GREEN areas for the next entry.

I would rather have on button than 4 to help this person do my job

Thanks alot

Hi Thangavel

I Updated the strPath to strPath = "C:\Users\WS19\Dropbox\MARK TROKKE"

But when I push the Button after inserting data, it highlights the following in Yellow, after giving me the message that file is not saved. The document may be open or an error may have been encountered when saving..

Cant remember how to add code:

[/CODE]Sheet2.Range("A1:I55").ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
strPath & strFName, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False

Thanks for all the help

HI
I would very much like it to be in Dropbox, yes person will sit at my desk. But PDF will be shared to other departments and Stores.

Otherwise it would also just work that the window opens up, the SAVE AS window, then I will just teach person to scroll to .pdf...

Thanks a lot

Originally Posted by than_gold

Export to Dropbox - I'm not able to test it in my machine. Hope someone will help you on this.
Please check this link to export to Dropbox : https://stackoverflow.com/questions/...using-multiple

Whatever I gave to you, will save the pdf in local machine.

Thank you so much!! I will have a read, otherwise I will keep it to a local machine Thanks