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.

http://sendfile.pl/23589/ang.zip
Thank you in advance for your help.

Hi

Can you please be specific about the requirement. You can post the lines of code you have attempted already for speedy response

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)