G
greg.mcbride
I am far from an expert at Excel. I'm running Office 2004 on a
PowerBook G4. Here's the situation. I've set up a sales funnel and I am
tracking gross and net revenues. I have columns for 0-30 days out,
31-60 days out, and 61+ days out. I've set up an equation that
calculates the days until closing the deal based on today's date and
the estimated close date. Currently, I am manually moving the data on a
weekly basis to get the gross/net figures in the right columns. Is
there a way to make the cells auto-locate to the correct columns based
on the number of days until close? It seems like it should be a simple
"if, then" equation, but I'm not sure how to do it, if it's even
possible. Please e-mail me directly with suggestions.
Thanks in advance for the help.
-Greg
PowerBook G4. Here's the situation. I've set up a sales funnel and I am
tracking gross and net revenues. I have columns for 0-30 days out,
31-60 days out, and 61+ days out. I've set up an equation that
calculates the days until closing the deal based on today's date and
the estimated close date. Currently, I am manually moving the data on a
weekly basis to get the gross/net figures in the right columns. Is
there a way to make the cells auto-locate to the correct columns based
on the number of days until close? It seems like it should be a simple
"if, then" equation, but I'm not sure how to do it, if it's even
possible. Please e-mail me directly with suggestions.
Thanks in advance for the help.
-Greg