Quickbooks exporting into Excel, formula trouble

reni7722

New Member
Joined
Nov 4, 2005
Messages
3
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!
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Can you tell me what the formula is before you dump in Quickbooks. And how exectly are you getting the info in (copy and apste?)
 
Upvote 0
the formula is not actually in the QB reports. it's one i created using data from the imported reports. From QB, i export the file into an existing workbook, onto a set tab. In another worksheet, i copy data from certain cells of the report, my formula looks like this: =Design!F6 with Design being the name of the worksheet I am copying from and F6 being the cell containing the data that I am copying. It's a very simple formula, but everytime I export a new report from QB (same report, just up-to-date with different numbers) my formula goes null and void :(
 
Upvote 0
Ar you copying the formula from one cell into the same cell on another workbook (if you are moving it it may not work)?
Try this:
=Design!$F6

And do you have a sheet called "design" in the new workbook?

Are you deleting rows or columns? If so, try clearing the contents instead.
 
Upvote 0
ok, that didn't work. no, this is all involving only one workbook. 2 different sheets. I'm not copying any formulas, with my =Design!F6 formula i am copying simply a value. When those values change (current reports) I have to manually reenter each formula to re-create my values.

GRRR! well thank you for trying to help!
 
Upvote 0

Forum statistics

Threads
1,226,506
Messages
6,191,439
Members
453,658
Latest member
healmo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top