Hello.
I received spreadsheet with the columns that looked like it was re-labeled.
It is messing with my formula giving me error --circular reference.
I know you do something to rename it but I have brain fart and can't remember what to do.
Thank you for your time. Beth
When I put formula to add the "hours" from F6 + H6 --- it doesn't work because "J6 is now F6" --columns have been renamed
It seems to me that if the formula in cell J6 should be =F6+H6 then the hours in F6 should be calculated from something other than =J6-H6.
Perhaps there is data in another sheet as the sheet name, Dinmore Engineering (Page 8), indicates there are other sheets (pages).
The other option would be to manually enter the hours in F6, as is done in cell F8, so that the formula in J6 does not produce a circular reference.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you!
You're Welcome. If the issue is resolved, please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks