I have a large spreadsheet (around 30 tabs) which is used to store and update data on a daily basis. Various people need to take built in reports (in the form of pivot tables and manually created tables using formula) and add them to their own workbooks for use in presentations.
Is there a way to set up a macro to allow the user to select which tab they want to 'export' (move/copy) into a new or existing workbook so that the data in the exported sheet appears as 'Paste Values' (i.e. not linked to the sourse data in the main workbook but with all formatting maintained, column widths, colours, images etc., together with a graph that feeds off the exported data?
I've attached a very basic sample, with a tab called 'Pivot' to demonstrate. In my main workbook there are several different tabs all with different names that different people would want to 'export', so they would need to be able to determine which tab it is the want to export, whether by having the tab selected or by entering the tab name in a user form or whatever is the easiest way do achieve this.
It would also need the ability to select either a 'new' or an 'existing' workbook to be moved to.
Many thanks
Bookmarks