LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 26th 13, 07:58 PM
Junior Member
First recorded activity by ExcelBanter: Feb 2013
Posts: 1
Default Excel formula help


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

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

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

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

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

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

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formula Guidance. Formula need to determine if cell is popul Matt Excel Programming 0 February 19th 10 07:32 PM
When I enter a formula, Excel shows the formula not the results Pat Adams Excel Worksheet Functions 4 July 25th 07 09:56 PM
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible blue[_2_] Excel Discussion (Misc queries) 2 July 11th 07 06:08 PM
Build excel formula using field values as text in the formula val kilbane Excel Worksheet Functions 2 April 18th 07 01:52 PM
Excel 2002 formula displayed not value formula option not checked Dean Excel Worksheet Functions 1 February 28th 06 02:31 PM

All times are GMT +1. The time now is 03:12 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017