Looking for the best way to update different worksheets within the same workbook(template). I have a workbook that will contain 4 worksheets, I will need to update the data from an Access Database. My current vba (Access) will take the template and add a new workbook for each instances within the loop. I need to be able to check if there is more than 1 instance of the loop and if so, create the first copy of the template then update all pertinent worksheets within the newly created workbook.
Please Login or Register to view this content.