Here's my issue..
I export Quickbook reports into an Excel worksheet regularly in order to compute certain figures and analyze compared to budgets, etc. I have certain worksheet tabs that I always dump the same QB reports on to. Then on another worksheet (in the same workbook) I have a reference cell formula that is simply copying data. However, when I export an updated report into excel, with the same columns dumping into the same cell references, my other worksheet also shows #REF! . How do I prevent this from happening? It doesn't happen if I'm just linking a value to another cell, but everytime I export data from QB, it knocks my formulas useless. This is very annoying!!
Any help = great appreciation!
I export Quickbook reports into an Excel worksheet regularly in order to compute certain figures and analyze compared to budgets, etc. I have certain worksheet tabs that I always dump the same QB reports on to. Then on another worksheet (in the same workbook) I have a reference cell formula that is simply copying data. However, when I export an updated report into excel, with the same columns dumping into the same cell references, my other worksheet also shows #REF! . How do I prevent this from happening? It doesn't happen if I'm just linking a value to another cell, but everytime I export data from QB, it knocks my formulas useless. This is very annoying!!
Any help = great appreciation!