Ill have to get some approval on that since these are work documents and contain sensitive material.
If you can still help without it at this point, that would be great.
Ill try to explain whats going on in more detail and maybe thatll give you an idea of where im going without the documents.
I have my Summary Document that all the code is in. It displays a button on the page that allows the user to open a file (wbSource) to be summarized located in the same place as the Summary Document. After which it opens a userform that will allow me to select a begin column and end column on wbSource for the test being summarized.
The issue im currently working on now is 1. the file that i opened (wbSource) thru the summary document, i want to call it out in the code to specify between the 2 files when summarizing. So the just opened file i want to set = wbsource but i dont know how to do that yet. Ive got