$ 20 USD for importing data from multiple files

  • Hello,
    for my work i have to copy from various files severals cells and ranges.
    All the files are in the same Folder (C:\SAP\).
    For each Import procedure the following Sheets should be created in the target file:
    - YYYYMMDDHH_AN1
    - YYYYMMDDHH_AN2
    - YYYYMMDDHH_AN3
    - YYYYMMDDHH_AN4
    The YYYYMMDDHH are just the variables :) So today the Sheets would be called 20181210_AN1.


    This is the example of the procuedure for the first Excel file. All files following the first one should be added after the last dataset. [TABLE="border: 1, cellpadding: 1, width: 500"]

    [tr]


    [td]

    Sheet (Source)

    [/td]


    [td]

    Cells

    [/td]


    [td]

    Target

    [/td]


    [td]

    Comment

    [/td]


    [/tr]


    [tr]


    [td]

    General Data

    [/td]


    [td]

    C7:D7

    [/td]


    [td]

    YYYYMMDDHH_AN1! A1

    [/td]


    [td]

    A1

    [/td]


    [/tr]


    [tr]


    [td]

    General Data

    [/td]


    [td]

    [/td]


    [td]

    YYYYMMDDHH_AN2!A1

    [/td]


    [td]

    A1

    [/td]


    [/tr]


    [tr]


    [td]

    General Data

    [/td]


    [td]

    [/td]


    [td]

    YYYYMMDDHH_AN3!A1

    [/td]


    [td]

    A1

    [/td]


    [/tr]


    [tr]


    [td]

    General Data

    [/td]


    [td]

    [/td]


    [td]

    YYYYMMDDHH_AN4!A1

    [/td]


    [td]

    A2

    [/td]


    [/tr]


    [tr]


    [td]

    General Data

    [/td]


    [td]

    L20:R23

    [/td]


    [td]

    YYYYMMDDHH_AN1!B1:23

    [/td]


    [td]

    B1:B23

    [/td]


    [/tr]


    [tr]


    [td]

    General Data

    [/td]


    [td]

    A28:J30

    [/td]


    [td]

    YYYYMMDDHH_AN2! B2:K:4

    [/td]


    [td]

    [/td]


    [/tr]


    [tr]


    [td]

    Intervention+Monitoring

    [/td]


    [td]

    A11:J17

    [/td]


    [td]

    YYYYMMDDHH_AN3 B1:K17

    [/td]


    [td]

    The Code should copy all data below the row 17 if the Cell in Column A is not empty.

    [/td]


    [/tr]


    [tr]


    [td]

    Intervention+Monitoring

    [/td]


    [td]

    A21:J22

    [/td]


    [td]

    - YYYYMMDDHH_AN4
    B2:K22

    [/td]


    [td]

    The Code should copy all data below the row 23 if the Cell in Column A is not empty.

    [/td]


    [/tr]


    [/TABLE]

    For questions please ask


    John


    Transactioncode 4PU133195A685143S