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.

You can use a form of VLookup. For example, I have this statement on Sheet 1
of my worksheet
=IF(ISNA(VLOOKUP(A6,'Sheet2'!$B$14:$E$70,2,FALSE)) ,0,VLOOKUP(A6,'Sheet2'!$B$14:$E$70,2,FALSE))

It is looking at the value in cell A6 on Sheet1 (equivalent to the name you
type in on the master log file), and compares it to a list of possibilities
on sheet 2 and returns the value that is in the 2 column of the selected
range on Sheet2. it is looking for EXACT matches so you would need to make
sure you always type the same thing.

You either would have to reference another cell in the formula to get
separate lines or use a numbering system before or after the name on the log
sheet so you would get the separate lines.

It is not very elegant, but it would be a start.




"HeidiG" wrote:

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.