How to copy specific data from one excel to another where the data in first excel sheet is changing dynamically?

thank you.

Create a workflow which will run periodically and do following

  1. Excel scope --> read range --> specify the range --> output Datatable
  2. Use this datatable and write range in new excel --> name the excel dynamiclly (for example use datetime in the excel filename)
  3. Clear DataTable
1 Like