My question is the following:
I have 2 excel worksheet.
In the 1 worksheet there is an empty template (with 4 rows and 5 columns).
In the 2 worksheet there are 20 templates with values in the 4 rows and 5 columns. Each template has a different name.
In the 1st worksheet there is also a list with the 20 different template's names.
What I would like to do is that when I select one name, Excel will look for the corresponding one in the 2nd worksheet and automatically display the related values in the empty template.
Maybe it might help you with a little illustration of the problem:
Worksheet "empty template":
"PICK THE NAME OF THE TEMPLATE" (in a cell)
B C D E F G
2
3
4
5
Worksheet "templates":
3 NAME OF TEMPLATE 1
B C D E
5 10% 13%
6 20%
7 35% 14%
8 20%
3 NAME OF TEMPLATE 2
F G I J
5 14%
6 20% 32%
7
8 18%
3 NAME OF TEMPLATE 3
K L M N
5 14%
6
7 20%
8
So let's assume that I choose "NAME OF TEMPLATE 3" then automatically, the value 14% and 20% will be displayed in the "empty template"
Hope I was clear enough and that you can help me on this one. Thanks a million
I have 2 excel worksheet.
In the 1 worksheet there is an empty template (with 4 rows and 5 columns).
In the 2 worksheet there are 20 templates with values in the 4 rows and 5 columns. Each template has a different name.
In the 1st worksheet there is also a list with the 20 different template's names.
What I would like to do is that when I select one name, Excel will look for the corresponding one in the 2nd worksheet and automatically display the related values in the empty template.
Maybe it might help you with a little illustration of the problem:
Worksheet "empty template":
"PICK THE NAME OF THE TEMPLATE" (in a cell)
B C D E F G
2
3
4
5
Worksheet "templates":
3 NAME OF TEMPLATE 1
B C D E
5 10% 13%
6 20%
7 35% 14%
8 20%
3 NAME OF TEMPLATE 2
F G I J
5 14%
6 20% 32%
7
8 18%
3 NAME OF TEMPLATE 3
K L M N
5 14%
6
7 20%
8
So let's assume that I choose "NAME OF TEMPLATE 3" then automatically, the value 14% and 20% will be displayed in the "empty template"
Hope I was clear enough and that you can help me on this one. Thanks a million
Last edited: