Ok, so here is the deal, im workin on excel 2010, and i need to make a tablet that has an up to date balance of data from several workbooks.
My problem is that i dont know how or even if its posible, to make it autoupdate each day.
The workbooks that i need to take data from are leveled as
"balance-january.xls , balance-february.xls, etc" and each one has 31 sheets, one for each day.
I need to make a link that can update from a workbook to another, and then that it can search the current day from the sheets or the last day that has value and import that data.
Also, if anyone knows if there is possible to link data from infoprod or scada to excel, would be of great assistance.
My problem is that i dont know how or even if its posible, to make it autoupdate each day.
The workbooks that i need to take data from are leveled as
"balance-january.xls , balance-february.xls, etc" and each one has 31 sheets, one for each day.
I need to make a link that can update from a workbook to another, and then that it can search the current day from the sheets or the last day that has value and import that data.
Also, if anyone knows if there is possible to link data from infoprod or scada to excel, would be of great assistance.