Remove - All Records

[suby]

Hi All,

 Step 1 - I have copied this TEST - INPUT workbook  from my shared network drive to my local Desktop.

 Step 2 - In my workflow I'm taking TEST - INPUT workbook from my desktop folder.

 Step 3  - Then i take sheet 1 and sheet 3 and doing some transformations and overwriting the data in sheet 1 and sheet 2 in  my desktop folder.

I'm looking for a solution where i want to delete all the records in Sheet 2 and say 'Redundant - No Data Available'  and overwrite the sheet 2  in my desktop folder based on sheet name.

Attached the Test Input for the Input Data and Test Output is the Expected Output.

Thanks

[HomesickSurfer · Accepted solution]

Hi @suby 

Output to overwrite range, and; preserve formatting (optional)

Workflow package attached.  Export to C:/Temp to test.

Hope you like it.

[suby · Accepted solution]

Thank you so much...it works..