Dear Sir
I have a separate Excel Workbook for each of our Sales Center. I have to prepare a summary report for Cash Sales. Cash Sales value is derived from D36 of each worksheet.
I don't want to manually D36's value in my Cash Sales report by linking external link! Rather I want to create the link text and want to get value from link text. Is is possible to get the value from Text of external link files?
For your kind consideration I have attached the demo file.
Will you please reply if you have time?
Farid
Dhaka Bangladesh
Bookmarks