I am writing a series of technical reports within one Excel document. Two sheets are seperate areas of testing relating to the same sample, the third a summary. How would I go about entering values common to all three sheets on the summary and have them appear on the other sheets in the appropriate cell? Specifically as a starter, date of test would appear in sheet 1 cell F7. Sheet two it appears in C5, D5, E5, F5, G5. Sheet two it appears in C1, C2, C3, C4, C5. I'm sure it can be done via VBA but my self taught skills lack the expertise. Thank you for your help!

---

Answer from Richard Rost:

You can just enter this information into the first sheet and then LINK to those cells in the next 2 sheets.

For example, type in some data into Sheet1 cell A1. Then go to Sheet2 and type in:

=Sheet1!A1

Now that cell will REFER to (is LINKED to) that cell on Sheet1.

Alternatively, you can COPY and then PASTE SPECIAL… PASTE LINK the data between two sheets in a similar fashion.