Many a times we open the file but don’t know where the file was actually been saved or need complete location of the file… to able to do this pls rfer below formula
very simple formula which can be very useful for you..
Just type >>>>> =CELL("filename") <<<<< in any cell and
it will give you the complete address in the file itself
likewise you can use many functions with this formula (refer image below)
I m sorry to say this but I am not getting the same .....
can pls explain the same by giving any example??
Thanks
KK & Company Chartered Accountant
Pune
CA Inter
View Details
MANUJ SHARMA AND COMPANY
Noida
CA Inter
View Details
Hema Yashwanth & Associates
Chennai
B.Com
View Details
Twenty Point Nine Five Ventures Private Limited
Noida
CA Inter
View Details
CCI
Pro
CAclubindia
