View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] scott.siegler@gmail.com is offline
external usenet poster
 
Posts: 3
Default Table function question

Hello,

Is it possible to reference cells on a different worksheet then where
you run Table? For example, I am creating the table on sheet 1.
However the row and column references I want to use are on sheet 3. I
am getting an error saying "input cell reference invalid." Is there
any way for me to accomplish this without having to create the table
on sheet 3 - which does work?

Thanks,
Scott