So I have this great, detailed visualization for a marketing campaign. I am now able to get similar (separate) datasets for other campaigns done in the past. So I would ideally just duplicate the tab, and replace the data in the new tab with the other dataset, but that replaces the data in all tabs. I've seen some workarounds for this, but it seems like this should be a pretty common task so if there a more straightforward way?
Hi there - Could you copy the worksheet to a new workbook, and try replacing the source there?