Excel Tracking Leads
Cat is tipping over bed-side lamps during the night
Does diversity provide anything that meritocracy does not?
Existence of Riemann surface, holomorphic maps
How can I play a serial killer in a party of good PCs?
Can 5 Aarakocra PCs summon an Air Elemental?
What makes papers publishable in top-tier journals?
Why do all the books in Game of Thrones library have their covers facing the back of the shelf?
Can we "borrow" our answers to populate our own websites?
Book where a space ship journeys to the center of the galaxy to find all the stars had gone supernova
Has Britain negotiated with any other countries outside the EU in preparation for the exit?
Is a new boolean field better than null reference when a value can be meaningfully absent?
Why do we have to make "peinlich" start with a capital letter and also end with -s in this sentence?
Can you tell from a blurry photo if focus was too close or too far?
Plausible reason for gold-digging ant
Best way to strengthen a wheel?
Hosting images in SFMC - is it a good idea?
Is there any risk in sharing info about technologies and products we use with a supplier?
Could an Apollo mission be possible if Moon would be Earth like?
Subsurf on a crown. How can I smooth some edges and keep others sharp?
Why maximum length of IP, TCP, UDP packet is not suit?
How can the probability of a fumble decrease linearly with more dice?
What essential properties make us human?
After checking in online, how do I know whether I need to go show my passport at airport check-in?
How does Leonard in "Memento" remember reading and writing?
Excel Tracking Leads
I work with realtors and I'm looking for an easy way to track the leads I get from a realtor.
Can I have a realtor list in one sheet, then a separate lead sheet with a column that if I enter the realtors name, then the realtor list sheet will update in the "leads received" column automatically?
I.E Bob Smith, realtor, sent me a lead, Jane Doe. I enter Jane Doe into my Leads sheet, and enter Bob Smith's name under the "Referral" column. In my realtor sheet, I have a column next to Bob's name with "Leads Received" and 2 in that column (let's say he referred me 2 ppl before Jane). Will that column update to 3?
Is such a thing possible? Thanks in advance!
-Kris
microsoft-excel worksheet-function tracking
New contributor
add a comment |
I work with realtors and I'm looking for an easy way to track the leads I get from a realtor.
Can I have a realtor list in one sheet, then a separate lead sheet with a column that if I enter the realtors name, then the realtor list sheet will update in the "leads received" column automatically?
I.E Bob Smith, realtor, sent me a lead, Jane Doe. I enter Jane Doe into my Leads sheet, and enter Bob Smith's name under the "Referral" column. In my realtor sheet, I have a column next to Bob's name with "Leads Received" and 2 in that column (let's say he referred me 2 ppl before Jane). Will that column update to 3?
Is such a thing possible? Thanks in advance!
-Kris
microsoft-excel worksheet-function tracking
New contributor
add a comment |
I work with realtors and I'm looking for an easy way to track the leads I get from a realtor.
Can I have a realtor list in one sheet, then a separate lead sheet with a column that if I enter the realtors name, then the realtor list sheet will update in the "leads received" column automatically?
I.E Bob Smith, realtor, sent me a lead, Jane Doe. I enter Jane Doe into my Leads sheet, and enter Bob Smith's name under the "Referral" column. In my realtor sheet, I have a column next to Bob's name with "Leads Received" and 2 in that column (let's say he referred me 2 ppl before Jane). Will that column update to 3?
Is such a thing possible? Thanks in advance!
-Kris
microsoft-excel worksheet-function tracking
New contributor
I work with realtors and I'm looking for an easy way to track the leads I get from a realtor.
Can I have a realtor list in one sheet, then a separate lead sheet with a column that if I enter the realtors name, then the realtor list sheet will update in the "leads received" column automatically?
I.E Bob Smith, realtor, sent me a lead, Jane Doe. I enter Jane Doe into my Leads sheet, and enter Bob Smith's name under the "Referral" column. In my realtor sheet, I have a column next to Bob's name with "Leads Received" and 2 in that column (let's say he referred me 2 ppl before Jane). Will that column update to 3?
Is such a thing possible? Thanks in advance!
-Kris
microsoft-excel worksheet-function tracking
microsoft-excel worksheet-function tracking
New contributor
New contributor
New contributor
asked 1 min ago
Kris MtgBankerKris MtgBanker
1
1
New contributor
New contributor
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Kris MtgBanker is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1409600%2fexcel-tracking-leads%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Kris MtgBanker is a new contributor. Be nice, and check out our Code of Conduct.
Kris MtgBanker is a new contributor. Be nice, and check out our Code of Conduct.
Kris MtgBanker is a new contributor. Be nice, and check out our Code of Conduct.
Kris MtgBanker is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1409600%2fexcel-tracking-leads%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown