Leslie
Your questions was well writen and very general in nature. It just seemed like a lot of the homework problems that pop up here every once in while
Two more tips for you. If you enter your two letter code before assigning the name to the next cell, when you do Insert>Name>Define, the name field will fill in automatically from the cell to the left
Also, lookiing at your example it appears that you want the user to type in the two letter code and have the formula use that factor. You can use the INDIRECT function for this. Say the List price is in A1 and you want the converted price in B1, and you want to enter the variable name in C1. Then you can use this formula in B1
=A1*INDIRECT(C1
Now your user can enter the code in C2 and the INDIRECT function will convert it to the defined name
By the way, I'm an ME and started participating in the newsgroups after posting my own problems here. I'm always happy to help, I just hate doing someone elses homework when I always did my own
Good Luck
Mark Graesse
(e-mail address removed)
----- Leslie wrote: ----
Mark
I guess being an engineer for all of these years I still haven't learned that nobody can read my mind yet. I have used spreadsheets for a number of years but untill my boss wanted me to do this spreadsheet did I get stumped. Here is the complete detail
Spain Conversion Factor SP 1.2
Canada Conversion Factor CA 0.7
U.S. Conversion Factor US 1.0
China Conversion Factor CH 0.0
Spanish Freight Factor SF 0.1
China Freight Factor CF 0.0
Spanish Freight Factor SF 0.10
China Freight Factor CF 0.00 Vendor 1
Drawing Description Part Number TOTAL As Quoted/Each Factor Converted/Each
Plastic Wheels 720399 8 0.198 1.25 1.980 0.000 S
Under the column "Description Converted/Each" they want to be able to input the varaibles. They also want to be able to change the variables from any of the two letter designer to any of the other ones. By changing that current days money conversion they want it to update all of the variables in the spreadsheet. I haven't had to do any kind of programming since my Fortran 77 days
I should be designing the manufacturing machines instead of doing this, but without this I wouldn't have a job at all anymore. Oh well, life sucks then you die
Thanks for the help and the time you have spent with me I really do appreciate it
Sincerely yours
Leslie H. Howell
----- Leslie wrote: ----
Mark
Thanks for the information
----- Mark Graesser wrote: ----
I think I got suckered into doing someones homework again.. Luckly I figured out a better way to do what they need. ;-
----- Mark Graesser wrote: ----
Les
The name you type in the first column will only be for your reference. Select the cell that will have the actual value in it. Then just above the upper left corner of your sheet you will see the cell reference (ex. A2). Click on this text and type in the variable name and hit enter. Now whatever value is in that cell will be assigned to that variable name
Another way to see or assign name is Insert>Name>Define... on the pull down menu
Good Luck
Mark Graesse
(e-mail address removed)
----- Leslie wrote: ----
Yeh, yeh, I know for some of you guys this is prbably a very simple task. This is what I am wanting to do
Assign a list of variables(in this case they are a two letter designator) at the top left of the worksheet and the cell to the right of the cell input the value for the variable
In a different row and colum use any of these varaibles and be able to change the values at the top list. I also need to be able to just insert a new variable in "different row and colum" and have it use this new variable.
Sincerely yours,
Les
