I have a macro which inputs QC data as a text file then creates separate worksheets for each QC. It then calculates mean, SD and CV for the different analytes. The number of analytes can vary. This coding although crude works well.
I now want to create a summary sheet in order to print out the data. Each sheet has a Range J1:M12 with my required data.
How do I copy this range allowing for spacing etc onto one worksheet?
kind regards,
Peter
I now want to create a summary sheet in order to print out the data. Each sheet has a Range J1:M12 with my required data.
How do I copy this range allowing for spacing etc onto one worksheet?
kind regards,
Peter