Merging multi excel files into one sheet with colors as original sheets!

Feedback Robot
,
9

@Anil_G
I believe we are on the same page.

You must indeed specify source and destination. It is basis for copy-paste :slight_smile:
But both source and destination must be within the same excel file given the “Copy/Paste Range” activity operates in context of “Excel Application Scope”

E.g. in below screenshot it will copy range from “Sheet1” to “Sheet2” of file “Book2.xlsx”

The image shows an Excel Application Scope workflow activity that specifies copying a range from "Sheet1" to "Sheet2" in the "Book2.xlsx" file. (Captioned by AI)
The image shows an Excel Application Scope workflow activity that specifies copying a range from "Sheet1" to "Sheet2" in the "Book2.xlsx" file. (Captioned by AI)457×375 12.6 KB

Cheers