Copy data of 1 sheet with color and all the formats to the sheet of other excel?

excel
activities

#1

Hi everyone,

I want to copy data of 1 sheet with color and all the formats and paste it into another sheet of the other excel. If possible please guide me with pictures.

Thank,
Long


Excel application scope - Copy contents including its format
#2

I could think of 3 ways:

  1. Using Read Range, Get Color, Set color will take lot of time. Cant guarantee formats.
  2. Open both excel use Ctrl+A, Ctrl+C in excel1 sheet and got to excel 2 sheet, go to cell 1 and Ctrl+V
  3. Move or Copy feature. Attached (modify your selectors,file and sheetnames)
    copyexcelsheet.xaml (14.3 KB)

#3

Thank vvaidya,
I trying.


#4

This is not working. I have modified the xaml according to my requirements but it didn’t work. I need to retain the formats. Please check and let me know the correct solution.

CopyExcelSheet.zip (1.2 MB)


#5

Hi ,
This will help you.

Regards
Balamurugan.S