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

[karol polubinski]

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?

[#2]

Try reading through this article.  It should help explain how excel handles links to workbooks:

https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2

[#3]

Thank you, Once again very very helpful

[#4]

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

[#5]

Karol-

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