In support of this Post:
http://www.excelfox.com/forum/showth...ll=1#post11847


Before
_____ Workbook: BeforeDumpTemplate.xlsm ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
1
 Voucher Date Link
2
Worksheet: Summary





After for first two vouchers
_____ Workbook: BeforeDumpTemplate.xlsm ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
1
 Voucher Date Link
2
 V0001 01.01.2020 Go To Sheet
3
 V0002 01.01.2020 Go To Sheet
4
Worksheet: Summary





After for all vouchers
Remove this code line
Code:
 ReDim arrUnicDtsSrc(0 To 0): Let arrUnicDtsSrc(0) = "01.01.2020_99909900 - A" ' ***** I am limiting it to the first unique identifier, ( 01.01.2020_99909900 - A ) just for demo purposes. If you remove this line,  then you will see that all dates and sources  will be considered
_____ Workbook: BeforeDumpTemplate.xlsm ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
1
 Voucher Date Link
2
 V0001 01.01.2020 Go To Sheet
3
 V0002 01.01.2020 Go To Sheet
4
 V0003 01.01.2020 Go To Sheet
5
 V0004 01.01.2020 Go To Sheet
6
 V0005 01.01.2020 Go To Sheet
7
 V0006 02.01.2020 Go To Sheet
8
 V0007 03.01.2020 Go To Sheet
9
 V0008 04.01.2020 Go To Sheet
10
 V0009 05.01.2020 Go To Sheet
11
 V0010 06.01.2020 Go To Sheet
12
 V0011 07.01.2020 Go To Sheet
13
 V0012 08.01.2020 Go To Sheet
14
 V0013 09.01.2020 Go To Sheet
15
 V0014 10.01.2020 Go To Sheet
16
 V0015 11.01.2020 Go To Sheet
17
 V0016 12.01.2020 Go To Sheet
18
 V0017 13.01.2020 Go To Sheet
19
 V0018 14.01.2020 Go To Sheet
20
 V0019 15.01.2020 Go To Sheet
21
Worksheet: Summary