Hellow to the forum
Ok, this must be easier than my previous task. I have vba generated below data range from multiple worksheets.
Every time i add results, i hit the update button placed in this Master Sheet
and automatically clear contents and merge the updated ranges.
The next step is to periodically transfer this range that grows vertically every week,
in another closed workbook (database) and always placed under the previous seasons
historical results (Cell B14522) that must be remain untouched. I have no problem
to set the code to source book (and call to open the target) or the opposite.
The target sheet has the exact same structure and same order of columns (B2:AF).
With my limited knowledge i think that this can be done either with clear contents
from B14522 and down and rewrite all the records every time
or with some comparison code that identifies the new records.
I have search forums with all the possible terms and tags but with no luck.
I would be grateful with any help.
Ok, this must be easier than my previous task. I have vba generated below data range from multiple worksheets.
Every time i add results, i hit the update button placed in this Master Sheet
and automatically clear contents and merge the updated ranges.
The next step is to periodically transfer this range that grows vertically every week,
in another closed workbook (database) and always placed under the previous seasons
historical results (Cell B14522) that must be remain untouched. I have no problem
to set the code to source book (and call to open the target) or the opposite.
The target sheet has the exact same structure and same order of columns (B2:AF).
With my limited knowledge i think that this can be done either with clear contents
from B14522 and down and rewrite all the records every time
or with some comparison code that identifies the new records.
I have search forums with all the possible terms and tags but with no luck.
I would be grateful with any help.
| Book1 | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | E | F | G | H | I | J | K | L | M | N | O | P | |||
| 1 | A/A | CAT | DATE | DAY | SEAS | TEAM 1 | TEAM 2 | G1 | G2 | G1(HT) | G2(HT) | SCORE | SCORE (HT) | ATTED | REFEREE | ||
| 2 | B3 | 21--17 | 1 | 16/17 | KARLSRUHER | OSNABRUCK | 2 | 2 | 0 | 2 | 2-2 | 0-2 | 14837 | STEGEMANN S. | |||
| 3 | B3 | 22--17 | 1 | 16/17 | ERFURT | PREUSSEN MUNSTER | 1 | 1 | 1 | 1 | 1-1 | 1-1 | 5063 | GERACH | |||
| 4 | B3 | 22--17 | 1 | 16/17 | FORTUNA KOLN | VFR AALEN | 1 | 0 | 0 | 0 | 1-0 | 0-0 | 1962 | CORTUS | |||
| 5 | B3 | 22--17 | 1 | 16/17 | HALLESCHER | PADERBORN | 4 | 4 | 1 | 3 | 4-4 | 1-3 | 6507 | ZWAYER | |||
| 6 | B3 | 22--17 | 1 | 16/17 | SPORTFEUNDE LOTTE | HANSA ROSTOCK | 0 | 2 | 0 | 1 | 0-2 | 0-1 | 3354 | SIEBERT | |||
| 7 | B3 | 22--17 | 1 | 16/17 | MEPPEN | WURZBURGER | 2 | 2 | 1 | 0 | 2-2 | 1-0 | 5088 | STIELER | |||
| 8 | B3 | 22--17 | 1 | 16/17 | WERDER BREMEN II | UNTERHACHING | 3 | 0 | 0 | 0 | 3-0 | 0-0 | 1209 | HEFT | |||
| 9 | B3 | 22--17 | 1 | 16/17 | WEHEN | JENA | 1 | 0 | 1 | 0 | 1-0 | 1-0 | 2753 | FRITZ | |||
MASTER | |||||||||||||||||
