Copying data from an an excel file at sharepoint to a local workbook report

[corporate_slave]

Hi,

Lately, I've been studying basic macros through the "record macro". However, I'm having difficulties in this one.

We do have sharepoint site wherein u can export the data into excel. Those data are used to update my report. So, to save time. I would like to create a refresh button wherein instead of exporting the raw data from sharepoint and copy the necessary data to cells in my workbook report(with formulas already).

I hope you can help me. Thank you.