LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Variable codes in Excel

Hello, I am VERY new to Excel. I have created a pricing worksheet for a
printing company. With printing we will have a lot of extra services
depending on the job, what I would like to do is be able to enter a code
number that will provide a certain formula from a list of formulas need for
the extra services. For Example:

On one job I would enter "A1S" and the "B5E"

Extra Code A1S
Extra Code B5E

There will be a list:

A1S - 1 position score - with a formula =20+.02* quantity
B5E - Blank A2 Envelopes - with a formula =.15* quantity

The list can be coded anyway

Any ideas? Thanks for your help.

Keith
 
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 and zip codes dm Excel Discussion (Misc queries) 10 September 12th 06 07:34 PM
How do I have Bar Codes appear in Excel? Max Excel Discussion (Misc queries) 2 September 20th 05 04:03 PM
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? Daniel Excel Worksheet Functions 1 July 9th 05 03:05 AM
Zip Codes from excel to .csv vkushnerov New Users to Excel 3 February 10th 05 04:43 PM
Bar Codes in Excel bktopper Excel Discussion (Misc queries) 2 December 2nd 04 08:25 PM


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

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

About Us

"It's about Microsoft Excel"