Head of table in VBA code

Hello,

I would like to automating some operation with macro, and here is a problem with the head.
At the beginning I’ve attached files that are done as a model - to represent how the macro works.
1) 5 variable with limit

I’ve tried to process these macros so that the function well with the head, but there is something wrong - file 2) 5 variable head

3) 1995-1996 makro test The target file in which I want to use the macro by the rule laid down in one model
So, that added 1997
As regards the differences in relation to model is:
• 4 TITLE D (1 +2 +3) and 8 NAME H (5 +6 +7) are summarized. I don’t know whether it makes sense to implement into the macro. May be
better is to add a empty blank row in the macro, and later I’ll be copied it by "hand".
• The final major difference is the table ”changes” where date doesn’t get from created separate sheet for 1997/1996 as a sheet of data taken in 1997, etc. Only always takes directly from a single sheet of "changes" horizontally eg. C5, H5 etc.


More information about this idea u can find here.
http://www.mrexcel.com/forum/excel-q...lications.html

Thank you in advance for your help.