I know there is a way to do this! There HAS to be!
January 13, 2008 6:31 PM Subscribe
MS Excel question: Creating a master spreadsheet that dynamically updates when information is updated from any one of six other spreadsheets. Possible?
I'm doing an inventory of three buildings, each with two floors. I've made six different speadsheets (one for each floor) to help me keep track of things. My boss wants weekly updates on a single, master spreadsheet.
I know I could just copy/paste all of the information into a speadsheet but I was wondering if there was a way to create a single spreadsheet that dynamically updated itself whenever I added information to any of the six other spreadsheets?
I'm using MS Excel 2002. Thanks.