+ Reply to Thread
Results 1 to 5 of 5

create and print files automatically

  1. 08-20-2018, 10:15 AM #1
    laurentkeruzec
    laurentkeruzec is offline
    Registered User
    Join Date
    08-20-2018
    Location
    Luxembourg
    MS-Off Ver
    2013
    Posts
    2

    create and print files automatically

    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
    Reply With QuoteRegister To Reply
  2. 08-20-2018, 07:50 PM #2
    mjr veverka
    mjr veverka is offline
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,151

    Re: create and print files automatically


    And ... what is the obstacle ?
    Reply With QuoteRegister To Reply
  3. 08-20-2018, 10:14 PM #3
    meabrams
    meabrams is offline
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: create and print files automatically

    Please upload a sample sheet so that we are able to try to better understand what you are trying to accomplish... Right now the information you have posted is a little hard to try to follow.... in the sample include how it currently looks then have a second sheet that shows how you would like it to be displayed when the file is printed/saved.
    Bramz
    Reply With QuoteRegister To Reply
  4. 08-21-2018, 04:51 AM #4
    laurentkeruzec
    laurentkeruzec is offline
    Registered User
    Join Date
    08-20-2018
    Location
    Luxembourg
    MS-Off Ver
    2013
    Posts
    2

    Re: create and print files automatically

    Dear all,

    I have an excel sheet with plenty of line as per below.
    I want to do a formula or VBA to split this excel sheet into different sheets and print them automatically with the following :

    title row
    Id Account Asset Class Sub Asset Class Action Qty/Nominal Symbol Name ISIN Exchange Currency Last price at CRE Run Counterpar

    sheet 1 : (title row) + row 2
    sheet 2 : (title row) + row 3
    sheet 3 : (title row) + row 4

    etc

    Thanks in advance for your help.

    Kind regards

    Laurent
    Reply With QuoteRegister To Reply
  5. 08-21-2018, 05:21 AM #5
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: create and print files automatically

    Rule 08: Cross-posting Without Telling Us

    Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

    No further help to be offered, please, until the OP has complied with this request.

    Cross posted on at least three other forums
    Last edited by Pepe Le Mokko; 08-21-2018 at 05:25 AM.
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Create a print macro that would automatically select print area?
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  2. Create a print macro that would automatically select print area?
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  3. [SOLVED] Create a print macro that would automatically select print area?
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  4. Create a print macro that would automatically select print area?
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  5. Create a print macro that would automatically select print area?
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  6. [SOLVED] Create a print macro that would automatically select print area?
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  7. [SOLVED] Create a print macro that would automatically select print area?
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  8. Create a print macro that would automatically select print area?
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1