If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Import data from one workbook to another

Thread starter manc
Start date Aug 12, 2019
Tags

backend data import another excel import data from excel query

manc

Active Member

Aug 12, 2019

Hi Demigods,

I do not have a specific issue at this time, more just want to gauge your advice...

I would like to have two workbooks - one called backend, one called frontend.

The backend contains rows of data.

The frontend contains the backend data imported into it.

Is it possible that if a change is made to the backend data, the frontend adjusts in real-time?

We can do a power query ok, and it will update changes after 60 seconds, but we are looking for a faster option, ideally without having to have the backend open.

Any thoughts/ideas would be greatly appreciated.

Best regards
manc