Need some help… I managed to generate a report and open the report automatically but can i also automate to extract information across 3 worksheets (ResultProduced.xlsx) into 1 worksheet,format and save it as a new file (e.g. FinalFormatedReport.xlsx)
Hello again @Eros,
Did you extract the data present in those 3 sheets from somewhere? or it is manually written?
If you could manage to extract that in the systematic pattern as you want it to be in the final file, it can be done.