Help me for delete data in excel?

[fairymemay (noona)]

I have file report column No , Status as below.

1. I want to map column No from file report that status = Cut with File input sheet Summary.
2. If found No. in file Input Sheet Summary → Delete Column A-I (in row No that = Cut)
   and delete row in sheet that in column Period (C_Apr , C_May)

3. Copy data from sheet C_Apr , C_May that delete to new sheet Error.

Report.xlsx (9.8 KB)
input.xlsx (45.6 KB)
Output_Final.xlsx (43.3 KB)

Please guide me about it.

• Remark Real Data have 5K rows.

[Nithinkrishna]

Hey @fairymemay

Sorry actually I’m unable to understand the points area which you mentioned.

Could you please help on that

Thanks
#nK

[fairymemay (noona)]

@Nithinkrishna
Step1 Read file Report and focus in column Status = Cut

Step2 Read in file Input sheet Summary —> Focus Column No , Column Name , Column Period

Step3 Delete column (A-I) in sheet Summary that column No = Column NO (status = Cut)

Step4 Cut Data row from Sheet (Sheetname = value Column Period) and paste in to new sheet Error.
Map row by Check Column Name in sheet Summary and check sheet in column Period.

Output_Final.xlsx (43.5 KB)
Report.xlsx (9.8 KB)
input.xlsx (45.6 KB)

Please guide me for solve it.

[fairymemay (noona)]

@Nithinkrishna Can​ u​ guide​ me​ about​ this​ case?

[Nithinkrishna]

Hey @fairymemay

Kindly, Will share a demo tomo.

Hope that’s fine

Thanks
#nK

[fairymemay (noona)]

@Nithinkrishna Thank you.
I will waiting guide from you.

Remark : real data have 4K rows.

[fairymemay (noona)]

@Nithinkrishna If you don’t clear about requirement you can ask me.
Thank you.

[Nithinkrishna]

Hey @fairymemay

Only one doubt From Step 4 - What to cut from that sheet ?

Based on account name ?

Thanks
#nK

[fairymemay (noona)]

@Nithinkrishna yes, Cut​ on​ sheet​ c_apr, c_may.​(follow​ column​ Period​ in​ sheet​ summary)
Base​ on​ account​ name.

[Nithinkrishna]

Hey @fairymemay

Yes, I can understand we need to cut from C_APR or other sheet based on the column period.

But in the C_Apr sheet there are many rows present so which row to cut from that ?

Thanks
#nK

[fairymemay (noona)]

@Nithinkrishna Cut by map Column Name in Sheet Summary with Column Cust Name in sheet C_APR or other sheet based on the column period.

[fairymemay (noona)]

@Nithinkrishna Any update about this case?

Thank you

[Nithinkrishna]

Hey @fairymemay

I’m gonna try today will send you.

Thanks
#nK

[Nithinkrishna]

Hey @fairymemay

Please find the demo code below…

nmnithinkrishna_DeleteRowsMatchingRowsInOtherSheet.zip (82.5 KB)

Here is the bot generated output file - output.xlsx (44.6 KB)

Hope this helps.

Thanks
#nK

[fairymemay (noona)]

@Nithinkrishna In your output file sheet summary must delete column A-I that match Column No as below.

Please guide me for solve it.

[Nithinkrishna]

Hey @fairymemay

Sorry missed it.

Please find the updated…

nmnithinkrishna_DeleteRowsMatchingRowsInOtherSheet_v2.zip (77.5 KB)

Hope this helps

Thanks
#nK

[Nithinkrishna]

Hey @fairymemay

Kindly check this now…

nmnithinkrishna_DeleteRowsMatchingRowsInOtherSheet_v3.zip (83.5 KB)

Hope this helps

Thanks
#nK