Forum Discussion
Auto Drag and fill Formula/Value
Dear Everyone,
I have two worksheets. Every time I will put value on sheet2B1, I want sheet1B1 has the same value with sheet2B1 AUTOMATICALLY. Or, with one worksheet, C2 to have the same value with B2. I think it has something to do with Macro/VBA. Sorry I dont know the terms. I hope someone can help me with this. Thank you in advance.
PS:
I want to learn VBA/MACRO, please kindly give me simple or understandable instructions. Thank you thank you.
This is a standard feature of Excel no VBA needed.
One sheet/cell is the where you want someone to input data and the second sheet cell is where you want to see the same data.
Let's say sheet1B1 is the source and you want it to show on sheet2B2
Go to sheet2B2 and enter = the click on sheet1 and then on the cell B1 and hit enter
It will add a formula that looks like this =Sheet1!B1
If that so, looks simple. But that is not what I want. I mean without putting a formula on sheet2B2. Because the values on Column B will increase from time to time. So, I have to update/drag the formula on sheet2B2 if that so. Thats why I capitalized the word AUTOMATICALLY Maybe I should clarify my post.
