How to copy specific data from one excel to another where the data in first excel sheet is changing dynamically?
Create a workflow which will run periodically and do following
- Excel scope --> read range --> specify the range --> output Datatable
- Use this datatable and write range in new excel --> name the excel dynamiclly (for example use datetime in the excel filename)
- Clear DataTable