Hi all,
I'm a newbie to the forum, so please excuse any breaches in etiquette!
I tried searching this, but I don't know what to call what I'm trying to do, so it's not going very well...
Is there a way to copy/paste the source cells for a range of data? For example, I have a table with a bunch of raw data, and another table on a summary tab that looks prettier for better presentation. I want to be able to change the source table data and have the summary tab table update automatically, without having to go individually into each cell and referencing the source cell (eg putting ='Q2 2011'!C26 " or ='Q2 2011'!C27 into each summary table cell).
Is there a way to copy/paste the source cell paths without having to do each one individually?
THANKS!
Bookmarks