finally to "separate al the data between company and personal"
you can use datasort on the "Paid By" column
or dataautofilter to hide rows with one or the other.


"Shane73" wrote:

Is it possible to have a single cell referenced to a separte cell that
contains additional data/information? I am trying to create an expense
report. I would like to have expense amounts entered into the
appropriate cells then when any cell is active, have a dedicated cell
which will collect additional data (ie. how it was paid, explanation,
city, etc.). Basically, when you click on any cell, there will be
another cell with all the additional information to view.

Ultimately, I would like to have an employee enter in a value, have a
drop down list to enter whether it was company paid or personally paid,
and then change the color of the value depending on the response. Then
be able to separate all the data between company and personal.

Can anyone inform me of the programming necessary to do this? Or if it
is even possible to do in Excel?