Hello all,
I have a directory that contains monthly lead reports - one Excel spreadsheet per month. I have an aggregated spreadsheet that takes all the data from each of the monthly spreadsheets to show all the data for all months. I do this by using the "get data" -> from file -> from folder function in excel 2016. In the aggregated file I make changes and updates. The problem is that when a new month is added and I "Refresh all" the previous excel files over right the aggregated data basically deleting the updates that I made in the aggregated file. My question, "Is there a way to make changes to the aggregated data file and sync it back to the original files?" If this is possible, when I refresh all the previous data would refresh with the most recent changes.
Any suggestions would be appreciated.
Thanks,
ambios
I have a directory that contains monthly lead reports - one Excel spreadsheet per month. I have an aggregated spreadsheet that takes all the data from each of the monthly spreadsheets to show all the data for all months. I do this by using the "get data" -> from file -> from folder function in excel 2016. In the aggregated file I make changes and updates. The problem is that when a new month is added and I "Refresh all" the previous excel files over right the aggregated data basically deleting the updates that I made in the aggregated file. My question, "Is there a way to make changes to the aggregated data file and sync it back to the original files?" If this is possible, when I refresh all the previous data would refresh with the most recent changes.
Any suggestions would be appreciated.
Thanks,
ambios