I am trying to create a reporting macro to place in the Quick Access Toolbar, but recording doesn't seem to change each new sample as the new one gets replaced with the sample that the record was used on. I have attached an xlsx showing the data is looks and the desired report after. Previously I had no trouble but something appears to be different now. The box towards the end can be variable as sometimes there are 3 rows and sometimes there are 10. I have have attached an example file with the the data tab being the initial and the desired being the final report. All the information is used for the report is in the data it is basically just re-ordering, but it doesn't seem to be working. Thank you.
Reply With Quote