Hi!
I'm new to this forum so please, excuse me if I'll be making silly comments. I'm not an Excel power user but rather a very average one.
Anyway, I got to an idea I'd like to fulfil.
I have an Excell file with two worksheets (database + calc).
One worksheet serves as a "database". It has multiple collumns with separate values (description + value 1 + value 2 + value 3)
Another worksheet serves as a callculator of these values. At the moment I'm doing all the job manualy (copy / paste) - from the source to a callculator so it's able to calculate values. I need to copy / paste description and value 1 and value 2, etc...
And it's very time consuming.
I'd like to automatize the process.
I was able to make a "dropdown menu" in the callculator worksheet, of the first column - description values from the "database" worksheet.
But the hardest part it just yet to come...
I need to (somehow) link the cells together (desc. + 1 + 2 + 3) so the callculator will know how to properly fetch all the rest data values.
Example can be seen in a specimen file attached.
I hope I made it clear enough.
Thank you very much!
View attachment specimen_calc.xlsx
I'm new to this forum so please, excuse me if I'll be making silly comments. I'm not an Excel power user but rather a very average one.
Anyway, I got to an idea I'd like to fulfil.
I have an Excell file with two worksheets (database + calc).
One worksheet serves as a "database". It has multiple collumns with separate values (description + value 1 + value 2 + value 3)
Another worksheet serves as a callculator of these values. At the moment I'm doing all the job manualy (copy / paste) - from the source to a callculator so it's able to calculate values. I need to copy / paste description and value 1 and value 2, etc...
And it's very time consuming.
I'd like to automatize the process.
I was able to make a "dropdown menu" in the callculator worksheet, of the first column - description values from the "database" worksheet.
But the hardest part it just yet to come...
I need to (somehow) link the cells together (desc. + 1 + 2 + 3) so the callculator will know how to properly fetch all the rest data values.
Example can be seen in a specimen file attached.
I hope I made it clear enough.
Thank you very much!
View attachment specimen_calc.xlsx