Check row in excel (delete & cut)

[fairymemay (noona)]

I have file input and file report.

But I want to check column status in file report if value = Cut

Delete no. (Lot) in file input sheet Summary (Delete Col A-I)
and cut row in sheet (check sheet name in column Period) to new sheet file name error.

*I want column A-I in row red text

And cut row to sheet Error.
And write Column A = Sheet Name before cut.

File as attached.
output.xlsx (43.5 KB)
Report.xlsx (9.8 KB)
input.xlsx (43.0 KB)

Please guide me about it.

[Robinnavinraj_S]

Hi @fairymemay

Cant able to get it clearly can you elaborate your flow little clearly

[fairymemay (noona)]

@Robinnavinraj_S

Step as below.

1. Open file report and check column E (status).
   

2 If status = Cut ----> map column No. with file input file (column A = No)
delete column A-I in file input (Row No that match status = Cut)

3. In sheet Report in file input have column Period —> I want cut data row in sheet name in period By map column Name in sheet Report with column Cust Name in Sheet (Period name)
   and insert in new sheet name error —> Paste data in sheet error.
   
   

Follow attachment :
input.xlsx (43.0 KB)
output.xlsx (43.5 KB)
Report.xlsx (9.8 KB)

Please guide me about it.

[Charbel1 (Charbel)]

I’m working on this.

[Charbel1 (Charbel)]

@fairymemay ,

In Reports excel, the report No has an additional 0. (Lot062 instead of Lot62)

Should we add this condition in our algorithm?

Also, this is the first phase of the work:
Main.xaml (16.4 KB)

What is remaining is:

1. Preserving the format
2. The error sheet

Forum_CutDelete.zip (90.0 KB)

Best,
Charbel

[fairymemay (noona)]

@Charbel1 @Robinnavinraj_S How to preserving format in sheet report , header in every sheet and error sheet?

[Robinnavinraj_S]

Hi @fairymemay

In read range activity , you can see preserve format check box in properties panel, enable it

[fairymemay (noona)]

Now my flow, header and template file correctly.
But remain how to add data row that delete in sheet C_Apr , C_May in sheet error.

Forum_CutDelete.zip (192.8 KB)

Please guide me about it.

[Sagar_Gupta1 (sagar Gupta)]

ping me on mail id; sg2070156@gmail.com