I can't seem to move the formula over without errors. On the Chesterbook tab I keep trying to move the formula over but it puts REF errors in the formula. So on chesterbook C29 i want the formula to move over from B29 and pull in from 2016 Actuals - Accrual W103. I realize i have to change to W103 in the fomula in the end but i still don't understand why i would have to rewrite it all.
I believe it might be because you don't have a $ sign in front of XFD in your formula. It's wanting to move the formula on to column XFE and the spreadsheet isn't that large.
Indeed so.Originally Posted by Vwheel
After saying in a post only last week that I'd never before seen a sheet that uses XFD this is now a second - although I suspect it's an error and there's no reason for the formula to use a column past X.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks