Automatically transfer "IV" data to sheet 2

Hello Microsoft Excel experts. I have a question and I really hope that you can help me out. I would appreciate it so much. My business requires me to dial names and phone numbers all day from a list of leads in Microsoft Excel. I use verious disposition codes for each phone number I dial such as...

• WN = wrong number
• NQ - Not Qualified
• IV = Invite
• SA - Sale
• DNC = Do Not Call
• UA = Unavailable
• AM = Answering Machine

What I would like to do is apply a function to the disposition column so that when I label a lead as "IV" the information will automatically be copied to sheet 2.

Please click on this link to get a microsoft excel list of leads that I've already dialed on and has dispositioned applied to it so that you know exactly what I'm talking about.

http://www.7figurenetworkerkit.com/leads.xlsx

Simply go to the 1st cell in sheet 2 where you want the data to appear and type:

=Table1[[#This Row],[Disp.]]

Then copy this formula down the page.

Oh, hang on, just re-read your question...

Do you only want those records with IV copied?

Welcome to the forum, jawaune.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

jawaune, no one may respond to the thread until you've changed the thread title.

Thanks.