Pulling Informations from Excel Spreadsheet

Closed
mahrens66 Posts 5 Registration date Thursday November 13, 2014 Status Member Last seen November 18, 2014 - Nov 13, 2014 at 06:12 PM
mahrens66 Posts 5 Registration date Thursday November 13, 2014 Status Member Last seen November 18, 2014 - Nov 18, 2014 at 09:24 AM
Hello - can anyone please help me?

I have a spreadsheet that has the information from a Realtor office. It has all the information from each sale for all Realtors. I need to pull certain information off of this main sheet for each Realtor (I will be making a separate sheet for each Realtor). I would use VLOOKUP but not sure how to set it up with all the other information on there.

Example Headings:
Date MLS Address Seller Lead Listing Agent Buyer Lead2 Buyers Agent Gross Sales Sale $ Commission Total Commission Co-broke In Office Agent Split Agent 5% Gift

I need to pull off certain columns if the Listing Agent or Buyers Agent is in this office.

If anyone can help me I would greatly appreciate it.

Thank you,

Michelle

4 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 14, 2014 at 01:42 AM
upload a small extract of your data to file uploading webpage like speedyshare.com and inform the download address . also explain what you want preferably what should be the result.
0
mahrens66 Posts 5 Registration date Thursday November 13, 2014 Status Member Last seen November 18, 2014
Nov 14, 2014 at 12:30 PM
OK I hope I did this right - http://speedy.sh/FngS2/Sample-Report.xlsx

Sheet one is the main information and sheet two is the information that would be pulled from the main sheet. I need a sheet for each Agent to pull off the information just for them. Let me know if you need more information.
0
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 15, 2014 at 01:04 AM
something wrong. when you choose the file from your computer and upload it to speedy share below the page from which this can be downloaded will be given. copy paste that.
0
mahrens66 Posts 5 Registration date Thursday November 13, 2014 Status Member Last seen November 18, 2014
Nov 17, 2014 at 12:06 PM
It gives me three links to share. Here are all three:

Download Page: http://speedy.sh/FngS2/Sample-Report.xlsx
Forum Link: [code]http://speedy.sh/FngS2/Sample-Report.xlsx[/code]
HTML Code: <a href="http://speedy.sh/FngS2/Sample-Report.xlsx">Download at SpeedyShare</a>

If you send me your e-mail I can send it to you - mine is mahrens66@charter.net
0
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 17, 2014 at 11:42 PM
sorry your earlier ref is ok. that is download page. I did a mistake
ok I downloaded your file

in sheet 2 see the extract from row 11 I have give below. better use index match function. see the formula in the fists row in column B and C which is copied down
write similar formulas for other columns

download the file from

http://speedy.sh/343dz/mahrenas-141118-Sample-Report.xlsx
0
mahrens66 Posts 5 Registration date Thursday November 13, 2014 Status Member Last seen November 18, 2014
Nov 18, 2014 at 09:24 AM
Can you e-mail me the file - when I open up the one from the web site it doesn't open up correctly. I don't know if it is because my excel is 2007. My e-mail again is mahrens66@charter.net. thank you for all your help.

Michelle
0