Hi
I have found an array formula that allows me to select a list of details from a master list in excel based on 2 criteria and referencing a specif column. This array is very slow and time consuming. I have tried googling for something similar using vba but could not find anything similar. I am a novice at vba and find I can help myself if I have a starting point and then I can tweek a macro to suite my needs.
Could somebody perhaps assist with the following.
Start and End value should be selectable and refers to masterlist.
Column refers to 1st column in masterlist.
Value 60 refers to count of items, I am just using simple calculation at this stage eg 'end value -(minus) start value + 1
Values are then extracted into 3 columns as below.
'Sequence", 'Card' & 'Tracking Id
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I have found an array formula that allows me to select a list of details from a master list in excel based on 2 criteria and referencing a specif column. This array is very slow and time consuming. I have tried googling for something similar using vba but could not find anything similar. I am a novice at vba and find I can help myself if I have a starting point and then I can tweek a macro to suite my needs.
Could somebody perhaps assist with the following.
Start and End value should be selectable and refers to masterlist.
Column refers to 1st column in masterlist.
Value 60 refers to count of items, I am just using simple calculation at this stage eg 'end value -(minus) start value + 1
Values are then extracted into 3 columns as below.
'Sequence", 'Card' & 'Tracking Id
Start Value: | 2351047 | 60 |
End value: | 2351106 | |
Column: | 1 | |
Sequence | Card | Tracking |
2351047 | 53 892********** | 120940802351047 |
2351048 | 533892********** | 407640802351048 |
2351049 | 533892********** | 347940802351049 |
2351050 | 533892********** | 640940802351050 |
2351051 | 533892********** | 477540802351051 |
2351052 | 533892********** | 558640802351052 |
2351053 | 533892********** | 268140802351053 |
2351054 | 533892********** | 411540802351054 |
2351055 | 533892********** | 601740802351055 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>