Hello,
I am sure there is an easy solution to this one.
I have a document containing two worksheets. The first is constantly updated and i want the second sheet to mirror exactly the first sheet. When someone puts a number in the A1 on worksheet 1 and turns the cell green I want cell A1 on the 2nd sheet to automatically be filled with the same number and be turned green.
Basically i want the content and the format of a cell in worksheet 1 to be automically mirrored in worksheet 2
Any help would be greatly appreciated.
cheers
I am sure there is an easy solution to this one.
I have a document containing two worksheets. The first is constantly updated and i want the second sheet to mirror exactly the first sheet. When someone puts a number in the A1 on worksheet 1 and turns the cell green I want cell A1 on the 2nd sheet to automatically be filled with the same number and be turned green.
Basically i want the content and the format of a cell in worksheet 1 to be automically mirrored in worksheet 2
Any help would be greatly appreciated.
cheers