Thread: display current cell contents in another worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andy62 andy62 is offline
external usenet poster
  
Posts: 158
Default display current cell contents in another worksheet
I have used the following formula to display the contents of the current cell
(since last refresh - update using F9):

=INDIRECT(CELL("address"))

Can I do anything similar to display the current cell in a different
worksheet?

TIA.
Reply With QuoteReply With Quote