Using head in VBA

[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
or second file 2) variable_s_f - a slightly different approach to the macro code (more advanced)
Here I received a comment to second file model (comments are also attached directly to the code)
“Based on your subsequent procedures ...
I'd make a list of sheets with the proper Name.
On the basis of the number of sheets of Num - names identified shift.
I’d pass by to (for) copy between worksheets source only one time.
Immediately copied all the data from the spreadsheet, taking into this shift,
without. Insert Shift: = xl down.
Because if you add another sheet still u need to change the contents of the procedure.
The question is sort of sheet names in a table?”


Comment attached directly macro - translated:
„const bo nie wiem czy nie powinny to byc parametry
const because I do not know if it should be the parameters

'**1 docelwowo wlaczyc ta linijka i bezwzglednie wtedy '**2
** 1 ultimately enable this line and then ruthlessly '** 2
zrodlo - poczatek danych w kolejnym arkuszu
source - the beginning of the data in the next sheet
pobieranie wszystkich danych z danego arkusza
download all data from a spreadsheet

opis po lewej tylko z 1-go ark bo zakladam ze sa takie same?
description on the left but from the 1st to the sheet because I assume they are the same?
nazwa arkusza zrodla
sheet name of source
a moze jednak albo copy values albo value=value?
But maybe, or copy values or value = value?
gdy wylacz
when you turn off”

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


4) 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.

Link
Thank you in advance for your help.

 

[SkipVought]

hi,

Your post is extremely difficult to understand.

Please post VBA questions in forum707. You will get much better responses in forum707 than in this forum, which is not designed to address macros and such.

Please state the application and version, such as Excel 2007.

Please include the applicable VBA (macro) code. Posting a link is not sufficient as some members are restricted from certain downloads by company policies.

Please explain what happens when you run your code that is not as expected. "Does not work" or "there is something wrong" is not an explanation.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}