For situations like this I usually use comments inserted
into the cells of interest specifying where the data comes
from/goes to.

-----Original Message-----
Hi,
We need to create some documentation for mappings between
two spreadsheets.

What notation / methods have people used / are people
aware of that will
enable us to do this?

Basically we have some input spreadsheets which are
consolidated into some
different output sheets. We need to map where the output
data comes from in
the input sheet(s).

Many thanks in advance.
Andy
.