Jun 29 2021 07:25 AM
Is it possible to set up a 2 way connection between different workbooks?
So for example I have 200 individual spreadsheets, which I need to manipulate the data in. I want to copy all the data from each spreadsheet (all are in same layout) into a master spreadsheet, then make changes within the master spreadsheet which will then update the individual spreadsheet. Reason for this is I need the individual spreadsheets to be up to date so I can import back into a system
Jun 29 2021 07:34 AM
That is far too complicated. Either update the master spreadsheet from the individual ones, or the other way round, not both ways.
Jun 29 2021 07:38 AM