linked spreadsheets

I thought this was straightforward but it does not seem to be. I have a two spreadsheets and in one (call it S1) I get a calculated value in column C. In the other (call it S2), I want to link to the values in column C. If, in S2 B10, there is a reference =S1!C10, and I sort S1, how do I...

Hello. I am fairly new to building complex Excel spreadsheets so I could really use your help :) This is also my first question, so if there's anything I forget please let me know so I can do better in the future ;) My first project on my new job is to create a daily Sales document that I...

Hi Guys, Im not sure if this can be done but if it can im sure you guys can help :) My colleagues fill in a daily call log with a list of customers who's policies are due. These customers are called and then the outcomes of the calls recorded on the spreadsheet. What i am looking to do is to...

Hi all I have a workbook with a management dashboard - let's call it the central workbook - that collates commissions and performance data for our sales people from various other workbooks which are managed by leaders. Currently, we keep all of the aforementioned workbooks in a folder that only...