Thread: How to creat a reference to a cell in another worksheet and keep f
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PhilRobinson PhilRobinson is offline
external usenet poster
  
Posts: 3
Default How to creat a reference to a cell in another worksheet and ke
Sorry,
This still doesn't work

"TomPl" wrote:

You could use a formula like this:

=IF(ISBLANK(Sheet2!A1),"",Sheet2!A1)

Reply With QuoteReply With Quote