How to enter data in multiple workbooks at the same time on different work sheets

Question

I have two workbooks which cannot be combined together.

each work book has many work sheets.

I need to find a solution how to link one workbook with another and with different work sheets

I have surfed the internet and got to no concert solution.

I have tried to use = it does copy the items in all ways needed but it does not update on work sheets.

is therea way to link the two workbooks and have them to update each other?

matt mickle · Answer

Try reading through this article.&nbsp; It should help explain how excel handles links to workbooks:
&nbsp;
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&amp;seqNum=2

matt mickle · Answer

Karol-
&nbsp;
Glad you got it working!&nbsp; Just post back to this thread if you have any additional questions!&nbsp; Always happy to help!

karol polubinski · Answer

Thank you, Once again very very helpful&nbsp;

karol polubinski · Answer

Thank you once again. Got it now or at least I think

Forum Discussion

How to enter data in multiple workbooks at the same time on different work sheets

4 Replies

Resources