Cell AZ99 is in sheet 7 and book1.xls , can I reach whatever the value is in that cell ( without ) opening book1.xlsx and add it to book2.xlsx?

HI 

THANKS FOR INVITATION

THERE ARE MANY WAYS 

 

SIMPLY 

SELECT CELL AZ99

COPY IT "( CTRL +C)

GO TO BOOK2 SELECT  ANY CELL YOU WANT 

RIGHT CLICK >>>>>> SPECIAL PASTE>>>>>>>CHOOSE PASTE WITH LINK 

******************************************************

ANY CHANGES IN VALUE IN CELL AZ99 BOOK1

WILL AUTO CHANGE IN CELL BOOK2

NOTE 

YOU  MUST TO NOT MOVE BOOK1 SHEET

 

Yes we can get the value, If we know the path to "book1.xls"

Yes we can, as we know the workbook name, work sheet name and the exact cell reference, we can link it to the another workbook

Dear Mr ahmed Firstly first thanks for inviting me Your case is reside on adding an external reference (link) to the source file (book1.xls )Between square brackets ([ ]), followed by the worksheet name, an exclamation point (!), and the cells that you want to get it's value [book1.xls]sheet7!AZ99 Hope that this was helpful, regards

Yes as we know the workbook /worksheet name and the exact cell. We can simply link and add it

Open both books

In Book2 select the cell where you want to put the value

Press = (as writing formula)

Use mouse to select Book1 from task bar, go to sheet7 and cell AZ99

Press enter

 

You will have reference like this in your formula bar: ='C:\\Users\\Documents\\[Worksheet2.xlsx]Sheet1'!$E$3

 

Modify over reference to match your path

 

linking can be used you can google it it is very simple.