mightymorgs
New Member
- Joined
- Dec 22, 2021
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
I have a rather large workbook I use to analyze data from different sources. I copy and past data into 16 different worksheets and then use VBA to format the data so it's readable. The data is pulled in to a single worksheet I use to rollup all of the information into a table with a pie chart. Everything works the way I expect it to but one column doesn't calculate once the macro runs. Since the macro format data in several of the worksheets, it messes up the formulas in that last column and gives me a "REF" error. I need to find a way to lock the formulas in that last column so that I don't have to go back and repoint to the correct reference cells once the macro runs. I tried locking all the cells with formulas and I tried to turn off automatic calculations until the macro runs and neither option did the trick. I'm convinced that there HAS to be a way to do this...
TLDR: I need to lock formulas on one worksheet in a workbook so that they point to the same columns on a separate worksheet regardless of whether there is data in those particular cells or not.
TLDR: I need to lock formulas on one worksheet in a workbook so that they point to the same columns on a separate worksheet regardless of whether there is data in those particular cells or not.
