Get Data From Diferent Sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In an excel file with multiple sheets (for instance sheets name’s 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
 
Back
Top