Help with Excel phone list

  • Thread starter Thread starter Matthew
  • Start date Start date
M

Matthew

I have created a phone list with a lot of extra data, On a different
worksheet, I want to display only certain fields, and have the ability
to sort the list, via Name or Number
RawPhoneList
Extension, First Name, Last Name, Phone Patch, Phone Type , Jack
Number, Notes, Display in Phone List.

UserPhoneList
First name, Last Lane, Direct Number<This is calculated via the
Extension, Extension
So I do I pull the data from the RawPhoneList based upon “Display in
Phone List” and show it in a formatted and sort able version on the
UserPhoneList?

Right now if I just make one cell = the other cell, I am left with a
buch of empty bank cells which I can trying to get rid of.

Thx
 
Make a copy of your Raw list: hold down the Ctrl key, drag the sheet tab to the right and let go.
Remove the data you don't want.
Blanks sort to the bottom.

--
Jim Cone
Portland, Oregon USA .
http://www.contextures.com/excel-sort-addin.html .
editorial review of special sort add-in (30 ways to sort)




"Matthew" <[email protected]>
wrote in message
I have created a phone list with a lot of extra data, On a different
worksheet, I want to display only certain fields, and have the ability
to sort the list, via Name or Number
RawPhoneList
Extension, First Name, Last Name, Phone Patch, Phone Type , Jack
Number, Notes, Display in Phone List.

UserPhoneList
First name, Last Lane, Direct Number<This is calculated via the
Extension, Extension
So I do I pull the data from the RawPhoneList based upon “Display in
Phone List” and show it in a formatted and sort able version on the
UserPhoneList?

Right now if I just make one cell = the other cell, I am left with a
buch of empty bank cells which I can trying to get rid of.

Thx
 
Back
Top