Hi All,

I created a assessment in excel wherein everything answered is tabulated and referenced into a sheet which works as the summary report of what a test taker answered. A problem with using the Connections function of excel is that it creates a table that looks very different from the original sheet.

How can I export the content of that specific sheet to a new separate excel file with will be my Main Database while still retaining the exact look and format. What I also need hopefully is that for everytime it's exported at the end of every take it then creates a new worksheet on the Main Database excel file so that I can treat each sheet as one testpaper per student since I also designed it to require their name and create a timestamp too.