	AllExperts > Excel
	Search

Volunteer
Answers to thousands of questions

Home · More Excel Questions · Answer Library

· Encyclopedia ·

Excel - Update data without links

Expert: Richard Stephens - 5/20/2008

Question
QUESTION: I am running office 2003 on XP SP2.

I have a worksheet with sales data, sales enters the quantity of an item and it calculates the materials cost/labor/etc.

Currently I manually update the sheet when prices from vendors change, however we also update our ordering/tracking software (Quickbooks) which can conveniently export to excel.

The question is, can I take the data from the exported quickbooks file, which is generally the more current, and automatically update the sales workup?

Note: The part number in the Quickbooks file will be similar but not exactly what is in the sales workup.
I can provide versions of both the workup and the quickbooks export if necessary.

Thanks!

ANSWER: Seth

Not sure you can automate it without the part numbers being the same. Send me a copy of the files though and I will have a look at them. My email is answer (at) pcexperthelp (dot) com

---------- FOLLOW-UP ----------

QUESTION: Did you get a chance to look at the files I sent?

Answer
Seth

I have been looking at the files and have forwarded it onto a VBA expert that I know. If it is possible he will find a solution. The only problem we have is that not all the items have service or install and some don't have the hyphen in them which makes it more difficult to shorten or split the column at the hyphen (some of them have even more hyphens as well).

Either way if there is a solution we will find it and get back toyou in a few days.

Richard

Add to this Answer Ask a Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here