I need a quick bit of VBA that copy and pastes (values and formatting) my dynamic table (connected to SharePoint) to another worksheet after the user has completed using various slicers and filters on the connected table.
It would take me a while to create a dummy workbook, as you wont be able to connect to the SharePoint list; however my tables column header starting in A12 is "Name". The value for data starting in A13 will always start with always start with a "2". The Table's width is to Column T and can have as many rows as Filtering / slicing does to it. I currently have the "Totals Row" featured turned-on, on the table; however, I'd like if the macro just down selected to the last bit of available data incase the user were to turn-off the totals row.
If you need more information just let me know.