• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel workbook name reference from a cell instead of mentioning hardcore excel name

Status
Not open for further replies.
V

vaidmohammed

Member
Attached is the sheet where under Col A I have mentioned complete path of Excel workbook which I am referring in my formula from Col B to Col F.

In the current set of formulae I have mentioned excel workbook name explicitly but I want that instead of mentioning workbook name in formulae I should give excel cell reference like A1 in my formula.

Any advice.
 

Attachments

  • Report.xlsx
    10.8 KB · Views: 1
vaidmohammed
Your previous:

Request for creating a master excel which refers various sheets, in it, and get output on the basis of formula.

I need help on a formula creation for generation of a test execution report. My need is : Background 1. I use to get test status reports, in defined excel format on mails, from various team members who are geographically divided, on daily basis. 2. I use to maintain these reports in 1 folder 3...
chandoo.org
Why do You need to 'solve' path many times ... instead ONCE?

And You could continue with Your previous thread ... as it belongs to same challenge...
I'll close this.
 
Last edited:
Status
Not open for further replies.
Back
Top