LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mount_mordor
 
Posts: n/a
Default Customer Quoting Database


Hello

I have a quoting program in excel that I created, I use this program to
quote customers for laser cutting. It is fairly basic, on the first page
I input all the data required to determine the amount of the quote, such
as the customer, the material, the size of the part, the amount of
parts. The second page is a print page, set up to accordingly and
drawing all it's information from the 1st page. The third page is a
list of all my customers. On the 4th page is my current steel price
list. All of this works great so far, but the problem is this:

I need to "Record" all the quotes I make. What I would idealy like to
have is a different sheet for each customer, so that after I enter the
information in the first page that, and select the customer, I could
hit a button that would search for that customers "sheet" and copy the
information to a new row there.

I am not that well versed in excel, so please keep the answers simple.

TIA

Troy


--
mount_mordor
------------------------------------------------------------------------
mount_mordor's Profile: http://www.excelforum.com/member.php...o&userid=26879
View this thread: http://www.excelforum.com/showthread...hreadid=401134

 
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
Links to External Database Rubble Excel Discussion (Misc queries) 0 July 20th 05 10:44 PM
How do I create a customer database in excel nhankins Excel Discussion (Misc queries) 1 July 5th 05 06:04 PM
Text manipulaion (summarizing customer records) Index function probably not good choice Paul Buob Excel Discussion (Misc queries) 1 February 1st 05 06:41 AM
How can I use Excel as a simple database for Quoting? Stefan Excel Discussion (Misc queries) 1 January 4th 05 01:26 PM
Searchable Database Shannon W. Excel Worksheet Functions 0 November 12th 04 07:14 PM


All times are GMT +1. The time now is 11:04 PM.

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

About Us

"It's about Microsoft Excel"