thanks
Following up on your replies: do you always receive your data as PDF files? If so
yes
it would (must!) be worth considering writing an an "Excel-to-PDF" conversion/cleanup macro producing a single file format AND common field (column) headings.
yes I agree with you , and I already know that . in this time I have to split and arranging for each separated sheet firstly and I will create another sheet with single field (column) headings and merging whole sheets by another macro has already existed .
I have some notices:
1- the macro doesn't create sheets automatically . I have to create manually , this is not problem
2- and will change data from TABLE to range . also this is not problem I will change to table after run the macro
3 in this point I want fixing as I said
should update the sheets have already divided when update TT sheet
it means any change in tt sheet should automatically change in others sheet are divided.