Hi,
I've been reading lots of post here, but can't find a fitting answer (probably due to my lack of VBA knowledge...)
Anyway, I have a sheet "export.xls" wich contains different data every week.
Data is names and points.
Spread over four sheets,"okp", "skp", "okr", "skr"
Layout is always the same:
Pos Vnaam Naam Tijd Punten
1 Pat Freesen 19,00 20
2 Harry Berk 19,72 19
3 Henk Hof 19,75 18
In the Masterworkbook I want to append names if not exist on the same named sheet, and copy points to one column.
Vnaam + naam should go to B, points to column E.
Next time points should go to Column F and so on..
Have a add-in which opens the export.xls and does some stuff to create the data (read:names and points) which I want on the Masterworkbook.
Anyone might have an example for this ?
Please ask if more info is needed..
Thanks..
I've been reading lots of post here, but can't find a fitting answer (probably due to my lack of VBA knowledge...)
Anyway, I have a sheet "export.xls" wich contains different data every week.
Data is names and points.
Spread over four sheets,"okp", "skp", "okr", "skr"
Layout is always the same:
Pos Vnaam Naam Tijd Punten
1 Pat Freesen 19,00 20
2 Harry Berk 19,72 19
3 Henk Hof 19,75 18
In the Masterworkbook I want to append names if not exist on the same named sheet, and copy points to one column.
Vnaam + naam should go to B, points to column E.
Next time points should go to Column F and so on..
Have a add-in which opens the export.xls and does some stuff to create the data (read:names and points) which I want on the Masterworkbook.
Anyone might have an example for this ?
Please ask if more info is needed..
Thanks..
