Excel formula help

S

Stephanie McCon

Hello,

I am in the process of making a custom lead tracking excel workbook. S
far i have 2 sheets. Quote request and Leads Breakdown.

Currently what i am trying to figure out is how to transfer the dat
from "Quote request sheet" cell B1 (Date) to "Leads Breakdown" cell P1
(Pending Date)

What i am looking to have happen is whenever a potential customer call
in for a quote, i will enter their information on Quote Request Sheet
The date will transfer from Quote request B1 to Leads Breakdown p1
automatically. The customers name will transfer from Quote request B2 t
leads breakdown q10.

Then after the quote request is printed the information will be delete
but remain on the leads breakdown portion.

When the next individual calls the cycle will repeat but instead o
going to p10 it will be p11, q11. and so on.

Any ideas, i have done research but i cannot figure it out
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top