Woodpusher147
Board Regular
- Joined
- Oct 6, 2021
- Messages
- 69
- Office Version
- 365
- Platform
- Windows
HI
This isnt as simple as I thought it was and I hope someone can point me in the right direction.
I have a shared folder on NExtCLoud which has multiple folders representing different stores.
In each of these folders is the store's own excel workbook
In the head office folder, I have a workbook with one sheet that references certain cells in each of the store's workbooks and updates whenever the store updates its sheet.
I have done this on my side and it works but it uses an absolute link and therefore when someone else accesses the "head office" sheet it doesn't update when other sheets are changed.
Here is one of the cells references
='C:\Users\ME\Nextcloud\Digital Marketing\19-Store\Discounts\[Monday 25th December to Sunday 4th February 2024 - Store.xlsm]5 Week'!$J$11
How can I make this so it will work on any pc that accesses the main sheet in the head office folder
Thanks for any help
This isnt as simple as I thought it was and I hope someone can point me in the right direction.
I have a shared folder on NExtCLoud which has multiple folders representing different stores.
In each of these folders is the store's own excel workbook
In the head office folder, I have a workbook with one sheet that references certain cells in each of the store's workbooks and updates whenever the store updates its sheet.
I have done this on my side and it works but it uses an absolute link and therefore when someone else accesses the "head office" sheet it doesn't update when other sheets are changed.
Here is one of the cells references
='C:\Users\ME\Nextcloud\Digital Marketing\19-Store\Discounts\[Monday 25th December to Sunday 4th February 2024 - Store.xlsm]5 Week'!$J$11
How can I make this so it will work on any pc that accesses the main sheet in the head office folder
Thanks for any help
