I would like to do the following:
I have 3 sheets:
1. Data
2. Sheet A
3. Sheet B
What I want is, in Sheet 'Data', specify the name of the sheet and the cell where I want to go a value, and automatically the value goes to that Sheet and Cell, without formuling the destination sheet.
For example:
1. In sheet 'Data' I have the Columns:
- Sheet = I give the value 'Sheet A'
- Cell = I give the value 'B3'
- Value = 10.000
2. I want that after filling this form, the value 10.000 goes to Cell B3 in Sheet A.
Appreciate your help.
Wish I could have explained well.
Thanks!
I have 3 sheets:
1. Data
2. Sheet A
3. Sheet B
What I want is, in Sheet 'Data', specify the name of the sheet and the cell where I want to go a value, and automatically the value goes to that Sheet and Cell, without formuling the destination sheet.
For example:
1. In sheet 'Data' I have the Columns:
- Sheet = I give the value 'Sheet A'
- Cell = I give the value 'B3'
- Value = 10.000
2. I want that after filling this form, the value 10.000 goes to Cell B3 in Sheet A.
Appreciate your help.
Wish I could have explained well.
Thanks!