Merge data 2 sheet

Help Activities
, ,
1

I want to merge data 2 sheet and copy to another file

I want to copy file input (sheet1 , sheet2) to file summary sheet1 (append orginal file)

remark :

  1. Data that copy to file summary sort Planned End (from old to new)
  2. If file input have sheet1 only ---->copy sheet1 to file summary
    If file input have sheet2 only ------>copy sheet2 to file summary
    If don’t have sheet1 and sheet2 ----> don’t nothing

Please guide me about it.
Thank you
input.xlsx (11.7 KB)
Summary.xlsx (9.5 KB)

2

Hi @fairymemay

Can you try the below

CurrentSheet.Name.Equals("Sheet1") Or CurrentSheet.Name.Equals("Sheet2")

image
image996×2186 169 KB

Sequence2.xaml (16.3 KB)

Cheers!!

3

@lrtetala I want to sort column Planned End from old to new data from Sheet1 and Sheet2 too.

How to sort it before write append data?

4

@fairymemay

Try with Sort Range activity

1 Like
6

I want expect output as below.

image

sort only data that paste (yellow row) not sort all originale file

Remak
I want copy data column A-C only.

Can someone guide me for solve it ?

Thank you