I am tasked to do the following. It may sound abit complicated but I'll try my best to explain.
Let say I have a workbook with 3 worksheets, names 'A', 'B' and 'C'.
Spreadsheet 'C' is like a summary of A and B with numerical values and graphs.
Can I insert a button in A. At the click of it, information from A and specific information from C will be generated onto another new workbook and saved under a specific file name.
Same goes for worksheet 'B'.
Thank you in advance =)
Bookmarks