N
NickC
I am using Office 2003
I have a telephone bill which contains about 500 different calls with the
numbers listed and amount charged. I have copied the relevant columns to a
worksheet (Call it Worksheet X)
A B C D
date phone # $ amount person responsible
there are about 500 rows
A, B, C, I took from phone bill and sorted the numbers in column B. In
Column D I would like to add the name of the person responsible for making
the call. Now I have a list of numbers that these people called with their
names (Call it Worksheet Y)
G H
phone number name
there are about 4 different names, each name has about 5 numbers (Varies)
that belong to them. So there are about 30 rows. The numbers in column G
are sorted.
What I would like to do is use the information from sheet Y to fill in the
name in column D of sheet X, automatically.
I need to do this so that each person could be billed for the calls they
made
Please help.
I have a telephone bill which contains about 500 different calls with the
numbers listed and amount charged. I have copied the relevant columns to a
worksheet (Call it Worksheet X)
A B C D
date phone # $ amount person responsible
there are about 500 rows
A, B, C, I took from phone bill and sorted the numbers in column B. In
Column D I would like to add the name of the person responsible for making
the call. Now I have a list of numbers that these people called with their
names (Call it Worksheet Y)
G H
phone number name
there are about 4 different names, each name has about 5 numbers (Varies)
that belong to them. So there are about 30 rows. The numbers in column G
are sorted.
What I would like to do is use the information from sheet Y to fill in the
name in column D of sheet X, automatically.
I need to do this so that each person could be billed for the calls they
made
Please help.