Share via

Add on called MOREFUNC

Anonymous
2016-01-07T00:15:58+00:00

Hi all,

I am trying to find a way to perform a similar task like the  INDIRECT.EXT function provided on the MOREFUNC add posted while ago by a good Samaritan

Basically what I need is to collect data from multiples files and worksheets (with defined format) into a master file just like when you use the equal sign (=) followed by the file name, worksheet and the cell number.

I have to tell you that I am very happy usinf the add on but it only works on office 2003 and that is getting a bit of problem with the rest of workers using newer versions.

Any idea?

I am using the Windows 7, 64 bits and Office Excel 2013 and/or 2016.

Thank a lot in advance.

Jorge M

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-01-29T09:32:19+00:00

    Excellent subject I benefited from it and I loved to help done by others so I did attach a link to it even helps the owner of the question. Thanking you very much

    3 people found this answer helpful.
    0 comments
  2. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2016-01-29T00:03:44+00:00

    Hi,

    The Morefunc add-in will work on any MS Excel version provided the Excel installation there is 32 Bit (the Bit rate of Windows can be 32 or 64).  You may refer to my solution at this link.

    Hope this helps.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2016-01-28T11:58:00+00:00

    I made a search and found this link I think it is good for you

    http://www.ashishmathur.com/tag/indirect-ext/

    Regards

    0 comments
  4. Anonymous
    2016-01-07T02:34:06+00:00

    Mohamed,

    Thank you to take time an try to find a solution to my request.

    The  INDIRECT. EXT function is not the same as the INDI REC T that comes with the excel application, it is actually an add in customized to use text as part of equation in the formula.

    Any other idea?

    Thanks

    Jorge M

    0 comments
  5. Anonymous
    2016-01-07T01:56:09+00:00

    Did you mean so

    Here I set up Excel file

    DOWNLOADI wish I could find the right solution for you

    Regards

    0 comments