View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pedro Serra Pedro Serra is offline
external usenet poster
 
Posts: 19
Default Get Data From Diferent Sheets

In an excel file with multiple sheets (for instance sheets names A and B) is
it possible to use in sheet A in cell A2 a formula like =A1!&A2, where A2 is
a in sheet B and A1 is in sheet A and as the tab name (B) written. The
formula should return the value in cell A2 of sheet B.

Thanks in advanced