Hi all, I have been using excel sheet's now for many a year but on a more basic level, now I want to learn on how to do formulas. For 1 example I have 15 sheets on 1 opened book but 1 of the sheets is an overview of all the other 14 sheets, I simply want to enter data in each of the 14 sheets and it does an over all calculation into the overview sheet. So this is really a 2 Question thread.
Does anyone know of the best way to go about this?
I have also pasted this into the more Absolute Beginners Helproom as im not sure at what level it begins to be an Absolute beginners query and a main helproom query.
VoG™ is an expert on the workings of Excel and if he is around at the moment I am sure that he is composing his reply!
One way of getting the data from the 14 sheets to the overview sheet is by making links on the overview sheet to the relevant cells in the other sheets. Depending on the volume of data this could be quite time consuming and I am not sure that it is the most elegant solution!