Head of table in VBA code

[jpol]

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.

[arlu1201]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).