Hello!
I have been doing some research on the internet to get help with this but I have not found anything that addresses this design that I can understand.
I have already developed a macro that successfully copies the designated fields from the multiple tabs into a spreadsheet one line at a time. Open workbook, run macro, data is where it is expected.
Now I need to take that same code and use it within a macro that will open multiple worksheets (900+) and populate each line in a spreadsheet - one for each workbook. The workbooks will be in a file named Student_Workbooks.
Thanks for your help!
Bookmarks