ColdSpirit
New Member
- Joined
- Sep 30, 2022
- Messages
- 18
- Office Version
- 2010
- Platform
- Windows
Hi all,
I have on a Sheet named "Elementos", a dropdown list with various data (numbers), and i have some sheets with same numbers.
Now, i need to choose one of those numbers (lets say 047), and when clicking a button it will look for the sheet with the same name 047, move the data on A6, B6, C6 and paste the data on H6, I6, J6 and finally get the value on J6 and show on "Elementos!C3"
Each time i click the button it will repeat the command and get a new number.
The structure of the sheets are as follows:
"Elementos" - Where the data is inserted:
The dropdown list is linked directly to the sheet "AWB":
Sheet "047" - where the table with the numeration that will be inserted on top, based on chosen number
It is possible to do this?
Many thanks in Advance.
I have on a Sheet named "Elementos", a dropdown list with various data (numbers), and i have some sheets with same numbers.
Now, i need to choose one of those numbers (lets say 047), and when clicking a button it will look for the sheet with the same name 047, move the data on A6, B6, C6 and paste the data on H6, I6, J6 and finally get the value on J6 and show on "Elementos!C3"
Each time i click the button it will repeat the command and get a new number.
The structure of the sheets are as follows:
"Elementos" - Where the data is inserted:
The dropdown list is linked directly to the sheet "AWB":
Sheet "047" - where the table with the numeration that will be inserted on top, based on chosen number
It is possible to do this?
Many thanks in Advance.