Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

access cell value

  Asked By: Kavisha    Date: Mar 25    Category: MS Office    Views: 816
  

let's say I have 2 excel files open
I wanna access cell A1 value of sheet1 of excel file 1 in excel file 2.

How it can be done?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Jonah Brown     Answered On: Mar 25

In your excel  file 2 select cell  you want the data to display in.
Select the + sign and then go to file  1 select the cell A1 and hit
enter. That data will now show up in the Excel file 2

 
Answer #2    Answered By: Boyce Fischer     Answered On: Mar 25

You can do this manually.
Have the two files  open and put "=" into a cell... Then go to A1 of the
other sheet and press return.
A reference will be inserted.

 
Didn't find what you were looking for? Find more on access cell value Or get search suggestion and latest updates.




Tagged: