HI Guys,

Would you please be so kind to assist with my macro. What i would actully like to do with the code is to save different sheets to pdf file. For example sheet name "13101" & "13102", the name of the file should be taken from specific cell in another worksheet for example sheet:"test" Cell:"A1:A2". But the trick is also that I would like the macro to create the folder automatically with cell contents in sheet ("test") cell("B1:B2"). And then I would like the macro to email the pdf file to en employee. This will be done on an monthly basis as an monthly asset report.

So to sum up i would like to do the following:
1) Create folder based on an specific cell content in another sheet in the workbook
2) Save a selection of worksheets as pdf in the folder created in step 1, the name of the file will be derived from the same sheet as step 1 name is derived
3) Email the files created in step two to an employee.

It would be greatly appreciated if you could assist as I'm an rookie when it comes to VBA. I have tried to copy macros from the forum and try them but I am struggling with even getting them to work without combining them.

Thanks in advance!