Originally Posted by Translated
Good afternoon,
First of all, I do not work daily with Excel, but I can reasonably handle it.
Now I am more of a challenge, who can help me?
It involves the following:
I will excel in developing a module, generating a 4-many components a total price in one time. The components concern in this story '' sheet ''. These are glued together so that the first end should be. Below, the components:
Component 1: W980lam (code / text) size: 3050x1300mm price € 8,25m2
Component 2: MDF18305130 (code / text) dim. 3050x1300mm price € 5,85m2
Component 3: W980lam (code / text size: 3050x1300mm price € 8,25m2
Component 4: softening / production (code / text) € 5, - m2
I have a few questions:
1. Normally we calculate it using the calculator. Doing fine, but this should be easier. Now will I in Excel for the employees at my company sure that 'there are only three fields must be filled namely component 1 t / m 3. It is best to update components 1 / m 3 with text fields. If someone w980lam enter, it automatically calculates the price and size of the total price, how can this be?
2. We work with hundreds of codes / texts, how can I make when I'm in a field eg Component 1 of the code. W980lam enter, recognizes this and is taking over the data?
I hope date is so clear. I'm looking forward to the reactions.
M.v.g. Lennart