I am making a travel expense log for two people. I would like to be able to
be able to enter in the employees name and what they spent, and then have
that also show on another sheet which is individualized. For example, if I
enter in $50 for Sue and $30 for Bob on sheet three, I want $50 to show on
Sue's sheet and $30 to show on Bob's.
I know how to do your basic IF= function. What I need to do is make sure
that no blank cells happen in between data entries. So if Sue only has two
entries, they will show up as rows 1 and 2 on her personal sheet no matter
their position on sheet 3.