Is it possible to consolidate excel worksheet from a Microsoft Sharepoint? I have some excel files that needs to be consolidated that resides on a sharepoint server.
Thank you for your help.
To all,
How are you? I need your help on a formula to look up and sum on different criteria. Sumifs will not work because it has to be backward compaitble to 2003 and sumproduct will not work because the ranges are different. Here is the gist of the problem:
I have a template that will be...