AustSportingPix
New Member
- Joined
- Oct 5, 2020
- Messages
- 42
- Office Version
- 365
- Platform
- Windows
- MacOS
- Mobile
Hey all, got a large database that's at the moment gets its data from 2 workbooks.
The first workbook has data from last year, the 2nd one from this year.
The problem is when I update them now I have to open both workbooks otherwise 2021's data goes missing.
Is there a way to freeze the cells from updating from 2021 while adding new data to the 2022 part of the database?
The first workbook has data from last year, the 2nd one from this year.
The problem is when I update them now I have to open both workbooks otherwise 2021's data goes missing.
Is there a way to freeze the cells from updating from 2021 while adding new data to the 2022 part of the database?