Repeating Text in Another Worksheet

  • Thread starter Thread starter Edward
  • Start date Start date
E

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
 
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
 
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
 
Back
Top