•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Don’t want formulae to auto update cell once data moves
Using formula =COUNTA($C$5:$C$6000) and have to add rows of data to the top a few times a day. Everytime I add data, $C$5 gets updated to the new location. I want it to always start at C5
The first 4 rows are not merged, but frozen.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com