Update in purchasing.xls

[Andri_JT]

Dear Member,
I have two files : purchasing.xls and Receiving.xls.
In purchasing.xls there are fields: PO#, Vendor, PartNumber, QtyPurchase and
QtyReceived, while in Receiving.xls, there are fields
RRP#(ReceivingReportPart), PartNumber, PO#, QtyReceived

I would like to update the field QtyReceived in purchasing file with the
condition if the fields PartNumber and PO# in both files are identical.

So, I am able to get the BackOrder Report.

Please help me, to solve the above problem.

Thank you,
Andri

 

[Rob Schneider]

Sounds like you are using Excel. Best to re-ask in an Excel programming
newsgroup. What you want to do is relatively sophisticated and
complicated.

Perhaps you should consider simplifying by using a database application
for this (Access or other).

Hope this is useful to you. Let us know.

rms

 

[Chris Schatte]

Andri_JT,
You could do this easily in an integrated fasion using Ouick Books (Intuit)
as your inventory / recievables / sales / etc... manager. Then apply the data
to your P & L reports created in Excel.

Chris Schatte

use the Office Online web based newsreader here:
http://www.microsoft.com/office/community/en-us/default.mspx
In Office System 2003 applications:
Help/Assistance Pane/open Communities