Formatting

[kleaningpatrol]

Hello all, I am new here and looking forward to the interaction. This question may have been asked countless times before and for that I apologize. I will get through all the threads soon enough but I need assistance.

Is there a way to format the entire workbook to interact between sheets? What I mean is I have a workbook of over 40 pages but the first page is the profile so to speak. I want information from the other sheets to show on the profile sheet without having to duplicate the information. Does that make sense???? Help???

 

[ExcelMercy]

Do you mean that you have several sheets and want information to appear on another?

Like, say on Sheet1, you want something from Sheet2 to appear in a way if you edit Sheet2, Sheet1 automatically edits?

If so:


In a cell on Sheet1, type = and click on Sheet2 and pick the cells you want to appear.

Example: On Sheet1's A1 cell type: =Sheet2!$A$1:$A$10

 

[kleaningpatrol]

ExcelMercy,
Thanks so much, it worked like a charm.....