You are reading a single comment by @krikov and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@krikov
Cheers for replying!
I don't need to be able to reference multiple source spreadsheets, I just need to build this year's version using last year's as a guide, if that makes sense. If I cut out the extra columns that are in this year's source data and tag them on to the end, then clone the pivot tables from last year and refresh, do you think that will work? I'm thinking if I do that, the cell references won't be buggered as the data will be in the same place. (There are a bunch of Vlookups at the end of all the data that would need re-running but I'll cross that bridge when I come to it).