PDA

View Full Version : How to split table into multiple worksheets based on one column and change its format



afgi
09-05-2014, 03:27 AM
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 help12233