Hi,

I need your help in configuration of VBA code. I have managed to find a VBA code that splits data into multiple worksheets, but now I need it to be place in specific form. So, the splited data needs to be placed in new worksheet (or separate pdf fils) in new changed form.

I have attached an excel file with VBA code that splits the data. Now I need it to add a function that redisigns the data splited into new form. If you lunch the VBA, you will get several of new worksheets. What I want it to look like, is in "AAAAA".

I need to print extracted date (each worksheet), so I need the VBA code to:
- set printed area in new workshhets, or;
- generate new pdf files, except of new worksheets

many thanks for your help
0002361186-20140821.xlsm