Preparing new excel file with data from last year RRS feed

  • Frage

  • I have two almost identical Excel files. One for the previous year and the other for the current year. The sheet names are identical, but their order does not have to be the same.
    I need to rewrite the links from the previous year to the current year. The rank is not equal. Somewhere only one line is copied, somewhere 2nd, 3rd and 11th line.
    I need a script that would only copy fields with links (or those that contain .xls in a field) from the previous one to the current year.
    Does anyone have a solution perhaps?

    Some sheets have 120 rows and 60 columns, som just 10 rows, some just 10 columns. How do I dynamically define that only data fields are searched and not empty fields?

    Freitag, 22. Januar 2021 13:35


  • Hello/Hallo,

    Аll English Technet forums have been migrated to Microsoft Q&A. All US Technet Forums are read-only from the 6th of January. As this is a German Technet forum I would kindly ask if you prefer to continue in English to post your question in Microsoft Q&A. If you choose to continue your discussion on the German Technet platform, I would ask you to translate your post into German.

    Thank you!

    Kind regards,


    Bitte haben Sie Verständnis dafür, dass im Rahmen dieses Forums, welches auf dem Community-Prinzip „IT-Pros helfen IT-Pros“ beruht, kein technischer Support geleistet werden kann oder sonst welche garantierten Maßnahmen seitens Microsoft zugesichert werden können.

    Montag, 25. Januar 2021 12:31