Hi guys,
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)
ResultProduced.xlsx (10.5 KB)
FinalFormatedReport.xlsx (8.4 KB)