Repeating Text in Another Worksheet

[Edward]

I have an accounting worksheet that shows the last date a bill was received
in cell, F11 written in text. (Last Bill Receive 01/01/09). This information
appears in the same way in another worksheet, or at least it should, but it
keeps getting forgotten so becomes out of date.

When I type "Last Bill Received <date>" in cell F11 in Worksheet 1, I want
it to automatically enter in cell K14 in Worksheet 2. In other words, cell
K14 in Worksheet 2 will automatically copy text from F11 in Worksheet 1.

Can this be done? Preferably without VB script.

TIA

Ed

 

[Bernard Liengme]

If the first sheet is named Sheet1 then on Sheet2 in K14 use =Sheet1!F11
If the sheet name has spaces you need single quotes: ='Worksheet 1'!F11
The easiest way to make the formula and get it correct is: on the target
sheet cell type =, open the source sheet and click on F11
best wishes

 

[Edward]

Thanks, Bernard.

So obvious I feel slightly embarrassed.

Best wishes,

Ed

 

[Bernard Liengme]

Not to worry - we all learn something each day
all the best

 

[John]

Hi Bernard
How true it is; I came across this and found it very profound:
"Who dares to teach must never cease to learn."
by John Cotton Dana.
Regards
John