I'm hoping to receive some assistance:
I'm attempting to create a summary worksheet from 6(Monday-Saturday) other worksheets within one workbook.
I need the summary sheet to update automatically as the other worksheets are populated without having to manually run the VBA code.
What I'm doing is linking the summary data sheet to another workbook for yield analysis SO when I manually run the code all the links are broken to the analysis report, URG.
I have been working on this for over a week and can't seem to find a solution.
I'm attempting to create a summary worksheet from 6(Monday-Saturday) other worksheets within one workbook.
I need the summary sheet to update automatically as the other worksheets are populated without having to manually run the VBA code.
What I'm doing is linking the summary data sheet to another workbook for yield analysis SO when I manually run the code all the links are broken to the analysis report, URG.
I have been working on this for over a week and can't seem to find a solution.