How to combine 2 arrays of data into 1 array:
TA0 Page No. TA1 Page No.
SR4.1/1 T001 SR4.1/1 T001R
SR4.1/2 T002 SR4.1/1+1 T001+1R
SR4.1/3 T003 SR4.1/1+2 T001+2R
SR4.1/4 T004
Combined pages by VBA:
TA0+TA1 Page No.
SR4.1/1 T001R
SR4.1/1+1 T001+1R
SR4.1/1+2 T001+2R
SR4.1/2 T002
SR4.1/3 T003
SR4.1/4 T004
Please note that:
1. Number of data for TA0 and TA1 may be varied in future;
2. Pages with "+" have to be added to TA0+TA1
Bookmarks