Link to another worksheet

Posted by Earl Perot on May 28, 2001 6:57 AM

Linking cells to another worksheet.Using edit,copy and paste special and paste link.Formulas remains as is and does not return number. e.g In work sheet Jan01Al,cell A1=12569, Link cell a1 to work sheet Feb01al. Result =Jan01!a1 instead of 12569

Posted by Dave Hawley on May 28, 2001 7:04 AM

Hi Earl

Check the formatting of your cell is not Text.

Dave

OzGrid Business Applications