I am hoping to get some clarity about how clipboard works. I am building a dashboard where data comes from multiple excel sheets. I have a worksheet (say A) where i bring in data needed from these excel sheets (like a vlookup but with more calculations). My next steps involve building a pivot from worksheet A. I was able to copy data from worksheet A on clipboard and use that as data souce and build the pivot i needed. This was much quicker and avoided potential complex logic to count these records. My question here now is that i am trying to have the clipboard data refresh everytime worksheet A is refreshed with new data.
Is there a way to have the clipboard data refresh or link to the worksheet it is copied from?
You may not be able to refresh the clipboard data since it's not linked to any file as such. You should work directly with your original worksheets or the derived Worksheet A, and have either a live connection to it or create an extract.