I'm struggling with an Excel issue and would be grateful for any help!
I have a spreadsheet of phone numbers, with the phone number in 1 column, and the name of the person whose number it is in the column next to it. This is the 'people' spreadsheet.
Every month I get sent a 'calls' spreadsheet, which contains lists of calls made to the numbers, but this spreadsheet does not have the names of the people in it; it just has a list of the numbers and information about the calls in each number's row (when they were made and how long they were for and so on).
Every month I insert a column in this 'calls' spreadsheet to the right of the numbers and, at the moment, manually check the other spreadsheet in order to work out the name of the person associated with the number, and then I manually type that into the 'calls' spreadsheet in the new column. As the list of numbers is about 300 long, this is time-consuming, and what I need to do is to somehow get the 'calls' spreadsheet to reference the 'people' spreadsheet and put the appropriate name into the inserted column automatically when the numbers match.
I could of course copy and paste the 'people' information into a couple of free columns in the monthly spreadsheet (so that I don't have to reference a completely different spreadsheet, if this makes things any easier), but after that I'm not sure what to do.
There are possibly a few ways of doing this, but I'm a bit stumped as to how to proceed.
I'm using Excel for Mac 2011.
Any help gratefully received, thanks!
I have a spreadsheet of phone numbers, with the phone number in 1 column, and the name of the person whose number it is in the column next to it. This is the 'people' spreadsheet.
Every month I get sent a 'calls' spreadsheet, which contains lists of calls made to the numbers, but this spreadsheet does not have the names of the people in it; it just has a list of the numbers and information about the calls in each number's row (when they were made and how long they were for and so on).
Every month I insert a column in this 'calls' spreadsheet to the right of the numbers and, at the moment, manually check the other spreadsheet in order to work out the name of the person associated with the number, and then I manually type that into the 'calls' spreadsheet in the new column. As the list of numbers is about 300 long, this is time-consuming, and what I need to do is to somehow get the 'calls' spreadsheet to reference the 'people' spreadsheet and put the appropriate name into the inserted column automatically when the numbers match.
I could of course copy and paste the 'people' information into a couple of free columns in the monthly spreadsheet (so that I don't have to reference a completely different spreadsheet, if this makes things any easier), but after that I'm not sure what to do.
There are possibly a few ways of doing this, but I'm a bit stumped as to how to proceed.
I'm using Excel for Mac 2011.
Any help gratefully received, thanks!
