Excel Help Needed

[wuesty]

I'm trying to figure out excel and I'm having a heck of a time.

I am keeping track of travel. What I would like the excel to do is take my list of personnel who have traveled and the dates they travelled and create blanks for their travel vouchers. I have a list of vouchers. I am trying to see who did not turn in a voucher as well as keep track of those who need one in the future. If at all possible I would like to make those who don't have vouchers red.

Any help would be much appreciated. I'm new at this any any resources that you may have would be great.

 

[My Aswer Is This]

Specific details. We always need specific details.

You said:

take my list of personnel who have traveled

Where is this list? On what sheet? In what column?
You said:

and the dates they travelled

Where are these dates?

You said:
and create blanks for their travel vouchers

What is a blank?
Create blank where?

You said:

I have a list of vouchers,

Where is this list?

I believe you can see where I'm going here.
We need specific details.

​

​

_{^{<strike>
</strike>}}​