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

Question ajoutée par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date de publication: 2015/02/25

Apprécier (1) Vues (2) Suiveurs (2) Réponses (1) Report Question

Ajoutez Une Réponse
Inscrivez-vous ou connectez-vous pour répondre.

par Riya Antony LNU , Intern , Mithril Telecommunication Ltd

The formula to be used in the cell in Book2 is

='[Book1.xls]sheet7'!$AZ$99

Apprécier (1)

Déprécier Réponses () Rapport

Offres d'Emploi Ingénieur Offres d'Emploi Vendeur Offres d'Emploi Comptable Offres d'Emploi Informaticien Offres d'Emploi Technicien

What can I do to stop the duplicated value in a specific column or row, and if I entered a duplicated value it opens an alert window message?
Top Answer: from the data tab select data validation customize your settings according to your rules and the message ... Voir Plus

Réponses (4)
What does focus group mean? What value can this group add to research?
Top Answer: Focus groups = Focus group ... Voir Plus

Réponses (2)
What value do consulting firms add to an operation?
Top Answer: i belive they add substantial value. being an outsider expert,analyzing the c ... Voir Plus

Réponses (2)
What does focus group mean? What value can this group add to research?
Top Answer: Dear Mr. Amr Hisham, With all respect to your trails in order to improve yourself and eventually your pr ... Voir Plus

Réponses (6)