How are you?
I'm trying to find an automated way to transfer data from sheet to sheet without the copy/paste method.
What i want to do is this:
I have two sheets on a book.
On the 2nd sheet, i want to input "cell" like A2 on a blank cell. This is the input value set by me.
The next cell, would read the value A2 on the other sheet, and give me the value i have on C2, based on that value.
I don't know if i'm explaining this correctly.
So i'm doing an example here:
A2 = 6 B2=9 c2=10
A2 = input by me cell number A2 B2 = automatic input value B2 of sheet1 C2 = automatic input value C3 of sheet1
Can you help me with this? Is it even possible to do?