Hello
I'm trying to pickup daily total of sales values from multiple workbooks on sharepoint to newly created workbook. Each workbook on sharepoint represent a month such as April, and has multiple worksheets/tabs named in date order such as, 01.04.14, 02.04.14.......On each of the worksheet cell F23 contains the daily sales total.
I want a formula to lookup the daily totals for each month onto my newly created work book(ATTACHED). Grateful if someone could help.
Thanks.
I'm trying to pickup daily total of sales values from multiple workbooks on sharepoint to newly created workbook. Each workbook on sharepoint represent a month such as April, and has multiple worksheets/tabs named in date order such as, 01.04.14, 02.04.14.......On each of the worksheet cell F23 contains the daily sales total.
I want a formula to lookup the daily totals for each month onto my newly created work book(ATTACHED). Grateful if someone could help.
Thanks.