Hi,
You can enter a formula in a cell in Sheet 2 col A which refers to Col B
of Sheet 1.
For eg. enter this formula in Cell A2 of Sheet 2 "=Sheet1!B2" and this
will automatically update the value in sheet 2 column A based on the
values in sheet 1 column B.
Govind.
Steved wrote:
Hello from Steved
I've two identical worksheets Labeled Sheet1 and Sheet2
Sheet1 ColB, ColC, ColD
Sheet2 ColA, ColB, ColC
How do I write a formula Please to update sheet2 ColA
from Sheet1 ColB,
Sheet1 ColC, ColD Are the same Values in Sheet2 ColB, ColC
Thankyou.
|