Forum Discussion
Error with formula when moving cells #REF
mathetes i have attached a very simple example of what i am trying to achieve. Has 2 tabs - consultant and architect costs. On each tab costs are scheduled per job and per month. The collection sheet totals all these costs. I have duplicated this information and then moved some of the costs around and you can see on the totals pages I get REF but in the totals for each month these are ok ie. row 15. If you can suggest a better way of doing this, it would be much appreciated 🙂
LHarris89 OK, I've attached a sample of how you could accomplish the same results by modifying the way you enter the information in the first place, and then using a Pivot Table to create the summary report. This uses exactly the data you gave me in your sample. But I think it illustrates what is possible by changing how you envision the process.
Among other things (I've put two extended comments into the workbook), there's only a single database, incorporating job, month, vendor and amount into one database whether it's the architect or the consultant. If you need to separate those out for reporting, there's a way to do that within the Pivot Table process. I'll leave that for now to a later stage, but basically I recommend you find a course (or read up on your own, if you're comfortable doing that) on the way to create a Pivot Table.....it's a very powerful tool. It does depend on thinking differently about your "raw data" and that I've tried to model for you in the database tab in this revised sample.