Forum Discussion

Nashu's avatar
Nashu
Copper Contributor
Feb 26, 2025

Copy and paste/append values along with formatting within workbooks

Hi folks,

We have a requirement where all the excel files from a particular document library in SharePoint and all the content in each sheet of each files (Source)  need be populated in a specific sheet of different excel file (Target) along with all the formatting in source. Is there any way to automate this?

Thanks in advance.

developer
excel
Excel for web
Macros and VBA
Office Scripts
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Feb 27, 2025

    Power query allows you to do this on a per-sheet basis, but it isn't able to also pull in formatting. Which makes me wonder: Why would you want to include formatting?

    • Nashu's avatar
      Nashu
      Copper Contributor
      Mar 04, 2025

      Thanks for your reply JKPieterse 

      I have a requirement where user can upload excel files (Could have different sheets and formatting) in a particular document library as a supporting files. After that user can trigger a flow which going to create another main file, Add some data on it with office script, after that below the data, Everything from supporting files should be populated along with formatting.

      Hope you understand what I need to achieve.

       

Resources