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

excel
uiautomation
activities

#1

thank you.


#2

@Venkatesh_Chowdary
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