let's say I have 2 excel files openI wanna access cell A1 value of sheet1 of excel file 1 in excel file 2.How it can be done?
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 hitenter. That data will now show up in the Excel file 2
You can do this manually.Have the two files open and put "=" into a cell... Then go to A1 of theother sheet and press return.A reference will be inserted.