Excel Help Needed

wuesty

New Member
Joined
Dec 26, 2018
Messages
1
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.
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,743
Office Version
2013
Platform
Windows
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>
 

Watch MrExcel Video

Forum statistics

Threads
1,095,365
Messages
5,444,030
Members
405,261
Latest member
Khauff

This Week's Hot Topics

Top