Hi There
I have created a spreadsheet using a range of data from A1 through J100 with cells having different sizes, data, text and numbers. Generally the core information will remain the same however I need to be able to utilise the data across a number of spreadsheets and for that data to be updated from time to time. So I would like to know how to set up the spreadsheets so that when data is input or edited on Sheet 1 that data is also edited and included on the other spreadsheets. That is through Sheets 2 to 6 for example.
Hope you can help.
Regards
Spencer
