How to autoupdate values to excel from a workbook with sheets for each day

nmirson

New Member
Joined
Mar 1, 2016
Messages
1
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.
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Watch MrExcel Video

Forum statistics

Threads
1,123,083
Messages
5,599,643
Members
414,326
Latest member
kfg1287

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top