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