Announcement

Collapse
No announcement yet.

$ 20 USD for importing data from multiple files

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • $ 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.
    Sheet (Source) Cells Target Comment
    General Data C7:D7 YYYYMMDDHH_AN1! A1 A1
    General Data YYYYMMDDHH_AN2!A1 A1
    General Data YYYYMMDDHH_AN3!A1 A1
    General Data YYYYMMDDHH_AN4!A1 A2
    General Data L20:R23 YYYYMMDDHH_AN1!B1:23 B1:B23
    General Data A28:J30 YYYYMMDDHH_AN2! B2:K:4
    Intervention+Monitoring A11:J17 YYYYMMDDHH_AN3 B1:K17 The Code should copy all data below the row 17 if the Cell in Column A is not empty.
    Intervention+Monitoring A21:J22 - YYYYMMDDHH_AN4
    B2:K22
    The Code should copy all data below the row 23 if the Cell in Column A is not empty.
    For questions please ask

    John

    Transactioncode 4PU133195A685143S
    Last edited by jan77; December 11th, 2018, 00:11. Reason: Added the transactioncode :)

  • #2
    Hi
    i can help you with this.
    i will let you know if I have any questions.

    Comment


    • #3
      Hi,

      I have a solution ready for you. Will send you payment details via PM.

      Comment


      • #4


        Payment received and file sent.

        Comment

        Working...
        X