Setting up a dashboard with a data source that can be updated by copy/pasting data into a different sheet

ethicskayak

New Member
Joined
Jun 11, 2021
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
Hi! I've essentially built a dashboard that has many slicers, allowing users to select various requirements and view which IDs are applicable to the given selection. I've built this dashboard via a macro, so that the user can just re paste the needed data into a sheet, click a button with the macro linked to it, and build the dashboard (with needed slicers and tables) based off of that copy/pasted data.

It works great on a single set of data, but I'd love ideas for a better way to build this out so the user doesn't have delete everything, and re run the macro every time they need to update it with new data, as well as reduce my possibilty for error in creating and editing the formulas and formatting through the macro. My biggest barrier to this right now is the slicers, since they are tied to the table that is built with the macro used to build out the dashboard.

I just started learning VBA, so I'm a total newbie with that, but any advice on this would be greatly appreciated! Please let me know if you have any questions or I can clarify anything about my issue.
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,141,704
Messages
5,707,970
Members
421,539
Latest member
zuniBM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top