create and print files automatically

[laurentkeruzec]

I want to create and print files with the following logic :

file 1 :
keep row 1
Id Account Asset Class Sub Asset Class Action Qty/Nominal Symbol Name ISIN Exchange Currency Last price at CRE Run Counterpart
and add row 2
11814 30000 stock sell 28300 ATW ATWOOD OCEANICS INC US0500951084 US (NYSE) USD 8,08 KBL FIX

file 2 :
keep row 1
Id Account Asset Class Sub Asset Class Action Qty/Nominal Symbol Name ISIN Exchange Currency Last price at CRE Run Counterpart
and add row 3
11815 30000 stock buy 1800 PNDORA PANDORA A/S DK0060252690 Denmark (Copenhagen) DKK 600 KBL FIX

file 3 :
keep row 1
Id Account Asset Class Sub Asset Class Action Qty/Nominal Symbol Name ISIN Exchange Currency Last price at CRE Run Counterpart
and add row 4

etc


Id Account Asset Class Sub Asset Class Action Qty/Nominal Symbol Name ISIN Exchange Currency Last price at CRE Run Counterpart
11814 30000 stock sell 28300 ATW ATWOOD OCEANICS INC US0500951084 US (NYSE) USD 8,08 KBL FIX
11815 30000 stock buy 1800 PNDORA PANDORA A/S DK0060252690 Denmark (Copenhagen) DKK 600 KBL FIX
11624 30000 stock buy 2300 TSCO TRACTOR SUPPLY COMPANY US8923561067 US (NASDAQ GS) USD 57,57 KBL FIX
11428 30000 stock buy 14900 BAD BADGER DAYLIGHTING LTD CA05651W2094 Canada (Toronto) CAD 30,56 KBL FIX
11424 30000 stock buy 10900 HCG HOME CAPITAL GROUP INC CA4369131079 Canada (Toronto) CAD 10,81 KBL FIX
11417 30000 stock buy 1000 NTES NETEASE INC-ADR US64110W1027 US (NASDAQ) USD 281,49 KBL FIX
11313 30000 stock buy 10327 UEPS NET 1 UEPS TECHNOLOGIES INC US64107N2062 US (NASDAQ) USD 10,2 KBL FIX
11112 30000 stock sell 270000 EUROB EUROBANK ERGASIAS SA GRS323003012 Greece (Athens) EUR 0,836 KBL FIX
10921 30000 stock sell 254000 EUROB EUROBANK ERGASIAS SA GRS323003012 Greece (Athens) EUR 0,687 KBL FIX
10734 30000 stock buy 22000 ATW ATWOOD OCEANICS INC US0500951084 US (NYSE) USD 7,94 Manual Adjustment
10735 30000 stock buy 3400 PNDORA PANDORA A/S DK0060252690 Denmark (Copenhagen) DKK 710,5 KBL FIX
10685 30000 stock buy 3400 PNDORA PANDORA A/S DK0060252690 Denmark (Copenhagen) DKK 712 KBL FIX
10583 30000 stock buy 4100 GTT GAZTRANSPORT ET TECHNIGA SA FR0011726835 France (Paris) EUR 33,9 KBL FIX
10416 30000 stock buy 1700 TSCO TRACTOR SUPPLY COMPANY US8923561067 US (NASDAQ GS) USD 70,16 KBL FIX
10417 30000 stock buy 7200 NTCT NETSCOUT SYSTEMS INC US64115T1043 US (NASDAQ GS) USD 37,75 KBL FIX
10411 30000 stock buy 3900 RMV RIGHTMOVE PLC GB00B2987V85 UK (London) GBP 40,29 KBL FIX
9628 30000 callmoney 120000 call money EUR Manual Adjustment
9523 30000 stock buy 15000 ATW ATWOOD OCEANICS INC US0500951084 US (NYSE) USD 9,28 KBL FIX
9386 30000 stock buy 8500 NOVOB NOVO NORDISK A/S-B DK0060534915 Denmark (Copenhagen) DKK 235,7 KBL FIX
9086 30000 stock sell 2309 UEPS NET 1 UEPS TECHNOLOGIES INC US64107N2062 US (NASDAQ) USD 13,65 KBL FIX
8897 30000 stock sell 2650 BMW3 BAYERISCHE MOTOREN WERKE-PRF DE0005190037 Germany (Frankfurt) EUR 69,8 KBL FIX
8898 30000 stock sell 72369 SPD SPORTS DIRECT INTERNATIONAL GB00B1QH8P22 UK (London) GBP 2,961 KBL FIX
8558 30000 stock buy 230000 EUROB EUROBANK ERGASIAS SA GRS323003012 Greece (Athens) EUR 0,571 KBL FIX
8175 30000 stock buy 11000 ATW ATWOOD OCEANICS INC US0500951084 US (NYSE) USD 12,18 KBL FIX
8146 30000 spot buy 230000 spot exchange deal USD/EUR OTC EUR (Fixed Income Market) USD 0,9341 KBL Forex
8068 30000 stock buy 4000 QCOM QUALCOMM INC US7475251036 US (NASDAQ GS) USD 54,24 KBL FIX
8016 30000 spot buy 253000 spot exchange deal USD/EUR OTC EUR (Fixed Income Market) USD 0,9379 KBL Forex
8011 30000 stock buy 20000 ATW ATWOOD OCEANICS INC US0500951084 US (NYSE) USD 13,93 KBL FIX
7522 30000 stock buy 2800 BBBY BED BATH & BEYOND INC US0758961009 US (NASDAQ) USD 40,75 KBL FIX
7475 30000 stock sell 725 WDC WESTERN DIGITAL CORP US9581021055 US (NASDAQ) USD 71,86 KBL FIX
7405 30000 stock buy 55 AZO AUTOZONE INC US0533321024 US (NYSE) USD 791,46 KBL FIX
7403 30000 stock buy 7600 GILD GILEAD SCIENCES INC US3755581036 US (NASDAQ) USD 76,4093 KBL FIX
7328 30000 stock sell 6900 CALM CAL-MAINE FOODS INC US1280302027 US (NASDAQ) USD 45,45 KBL FIX
7108 30000 stock sell 1800 BMW3 BAYERISCHE MOTOREN WERKE-PRF DE0005190037 Germany (Frankfurt) EUR 73,9 KBL FIX
6870 30000 stock sell 12800 ATW ATWOOD OCEANICS INC US0500951084 US (NYSE) USD 13,49 KBL FIX
6867 30000 stock sell 18000 ATW ATWOOD OCEANICS INC US0500951084 US (NYSE) USD 13,49 Manual Adjustment
6868 30000 stock sell 5600 BAD BADGER DAYLIGHTING LTD CA05651W2094 Canada (Toronto) CAD 31,39 Manual Adjustment
6865 30000 stock sell 2175 WDC WESTERN DIGITAL CORP US9581021055 US (NASDAQ) USD 67,71 Manual Adjustment
6727 30000 stock sell 7900 BBBY BED BATH & BEYOND INC US0758961009 US (NASDAQ) USD 48,01 KBL FIX
6567 30000 stock sell 3900 GTT GAZTRANSPORT ET TECHNIGA SA FR0011726835 France (Paris) EUR 33,04 KBL FIX
6574 30000 stock sell 12800 ATW ATWOOD OCEANICS INC US0500951084 US (NYSE) USD 11,34 KBL FIX
6349 30000 stock sell 5600 BAD BADGER DAYLIGHTING LTD CA05651W2094 Canada (Toronto) CAD 31,25 KBL FIX
6348 30000 stock sell 18000 ATW ATWOOD OCEANICS INC US0500951084 US (NYSE) USD 9,46 KBL FIX
6323 30000 stock sell 2175 WDC WESTERN DIGITAL CORP US9581021055 US (NASDAQ) USD 62,27 KBL FIX
4756 30000 stock sell 260000 EUROB EUROBANK ERGASIAS SA GRS323003012 Greece (Athens) EUR 0,674 KBL FIX
4749 30000 spot sell 887527,31 spot exchange deal CAD/EUR OTC EUR (Fixed Income Market) CAD 0,6972 KBL Forex
4492 30000 stock buy 3000 LNR LINAMAR CORP CA53278L1076 Canada (Toronto) CAD KBL FIX
4351 30000 stock buy 4900 SYNT SYNTEL INC US87162H1032 US (NASDAQ) USD KBL FIX
4343 30000 spot buy 57000 spot exchange deal USD/EUR OTC EUR (Fixed Income Market) USD KBL Forex
4340 30000 stock buy 2700 BBBY BED BATH & BEYOND INC US0758961009 US (NASDAQ) USD KBL FIX
4312 30000 stock buy 13368 SPD SPORTS DIRECT INTERNATIONAL GB00B1QH8P22 UK (London) GBP KBL FIX
4301 30000 stock buy 10000 ATW ATWOOD OCEANICS INC US0500951084 US (NYSE) USD KBL FIX
4292 30000 stock sell 17000 UEPS NET 1 UEPS TECHNOLOGIES INC US64107N2062 US (NASDAQ) USD KBL FIX
4280 30000 spot buy 360000 spot exchange deal USD/EUR OTC EUR (Fixed Income Market) USD KBL Forex
4278 30000 stock buy 13600 SYNT SYNTEL INC US87162H1032 US (NASDAQ) USD KBL FIX
4270 30000 stock sell 600 BAD BADGER DAYLIGHTING LTD CA05651W2094 Canada (Toronto) CAD KBL FIX
4224 30000 stock buy 12700 UEPS NET 1 UEPS TECHNOLOGIES INC US64107N2062 US (NASDAQ) USD KBL FIX
4167 30000 spot buy 289265,13 spot exchange deal USD/EUR OTC EUR (Fixed Income Market) USD KBL Forex
4164 30000 stock buy 40000 ATW ATWOOD OCEANICS INC US0500951084 US (NYSE) USD KBL FIX
4144 30000 spot buy 60000 spot exchange deal USD/EUR OTC EUR (Fixed Income Market) USD KBL Forex
4138 30000 stock sell 2500 WDC WESTERN DIGITAL CORP US9581021055 US (NASDAQ) USD KBL FIX
4068 30000 stock buy 6900 CALM CAL-MAINE FOODS INC US1280302027 US (NASDAQ) USD KBL FIX
4009 30000 stock buy 7000 GTT GAZTRANSPORT ET TECHNIGA SA FR0011726835 France (Paris) EUR KBL FIX
3996 30000 stock sell 3399 TGS TGS NOPEC GEOPHYSICAL CO ASA NO0003078800 Norway (Oslo) NOK Manual Adjustment
3995 30000 stock sell 36500 SPD SPORTS DIRECT INTERNATIONAL GB00B1QH8P22 UK (London) GBP Manual Adjustment
3994 30000 stock sell 25000 SPD SPORTS DIRECT INTERNATIONAL GB00B1QH8P22 UK (London) GBP Manual Adjustment
3992 30000 stock buy 2600 WDC WESTERN DIGITAL CORP US9581021055 US (NASDAQ) USD Manual Adjustment
3991 30000 stock buy 120501 SPD SPORTS DIRECT INTERNATIONAL GB00B1QH8P22 UK (London) GBP Manual Adjustment
3990 30000 stock buy 2000 LNR LINAMAR CORP CA53278L1076 Canada (Toronto) CAD Manual Adjustment
3989 30000 stock buy 9100 HCG HOME CAPITAL GROUP INC CA4369131079 Canada (Toronto) CAD Manual Adjustment
3988 30000 stock buy 8500 BAD BADGER DAYLIGHTING LTD CA05651W2094 Canada (Toronto) CAD Manual Adjustment
3983 30000 stock buy 2800 WDC WESTERN DIGITAL CORP US9581021055 US (NASDAQ) USD Manual Adjustment
3982 30000 stock buy 6100 SYNT SYNTEL INC US87162H1032 US (NASDAQ) USD Manual Adjustment
3981 30000 stock buy 1400 QCOM QUALCOMM INC US7475251036 US (NASDAQ) USD Manual Adjustment
3980 30000 stock buy 50000 UEPS NET 1 UEPS TECHNOLOGIES INC US64107N2062 US (NASDAQ) USD Manual Adjustment
3979 30000 stock buy 7800 BBBY BED BATH & BEYOND INC US0758961009 US (NASDAQ) USD Manual Adjustment
3978 30000 stock buy 3399 TGS TGS NOPEC GEOPHYSICAL CO ASA NO0003078800 Norway (Oslo) NOK Manual Adjustment
3977 30000 stock buy 120501 SPD SPORTS DIRECT INTERNATIONAL GB00B1QH8P22 UK (London) GBP Manual Adjustment
3976 30000 stock buy 1049000 EUROB EUROBANK ERGASIAS SA GRS323003012 Greece (Athens) EUR Manual Adjustment
3975 30000 stock buy 10187 DANR DANIELI & CO-RSP IT0000076486 Italy (Milano) EUR Manual Adjustment
3974 30000 stock buy 4450 BMW3 BAYERISCHE MOTOREN WERKE-PRF DE0005190037 Germany (Frankfurt) EUR Manual Adjustment
3973 30000 stock buy 2000 LNR LINAMAR CORP CA53278L1076 Canada (Toronto) CAD Manual Adjustment
3972 30000 stock buy 9100 HCG HOME CAPITAL GROUP INC CA4369131079 Canada (Toronto) CAD Manual Adjustment
3971 30000 stock buy 8500 BAD BADGER DAYLIGHTING LTD CA05651W2094 Canada (Toronto) CAD Manual Adjustment
1959 30000 stock buy 10187 DANR DANIELI & CO-RSP IT0000076486 Italy (Milano) EUR Manual Adjustment
1958 30000 stock buy 45000 BBRY BLACKBERRY LTD CA09228F1036 US (NASDAQ) USD Manual Adjustment
1957 30000 stock buy 7800 BBBY BED BATH & BEYOND INC US0758961009 US (NASDAQ) USD Manual Adjustment
1956 30000 stock buy 3250 BMW3 BAYERISCHE MOTOREN WERKE-PRF DE0005190037 Germany (Frankfurt) EUR Manual Adjustment
1955 30000 stock buy 1400 QCOM QUALCOMM INC US7475251036 US (NASDAQ) USD Manual Adjustment
1954 30000 stock buy 321000 EUROB EUROBANK ERGASIAS SA GRS323003012 Greece (Athens) EUR Manual Adjustment

 

[Macropod]

Cross-posted at:
https://www.excelguru.ca/forums/showthread.php?9313-create-and-print-files-automatically
http://www.vbaexpress.com/forum/showthread.php?63467-create-and-print-files-automatically
https://www.excelforum.com/excel-pr...385-create-and-print-files-automatically.html

Please read and acknowledge Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html