Hello!
I am trying to make a macro that will loop through all sheets of a workbook and copy a range of cells from each sheet and past in a cumulating summary sheet. Specifically my issue has been arising with how to code for finding the starting row number of the range desired to copy each time.
The data set from each sheet of the workbook that I am trying to add to a summary always starts with "COPY TO ACCESS" in column A and ends with Lastrow/Lastcol (always column S).
Any assistance would be greatly appreciated!!!
Thanks!
~Jared
Bookmarks