Updating Excel Files

[devilmountain]

I am a novice user of excel and need a little help. I am using
spreadsheet to update my websites inventory levels. I receive a
inventory update file from my supplier once a day. The problem is
don't sell all of the items in that file. eg

My File 1 ---- Suppliers File
BDDTTH ---- 100001
BDGBB ---- 100011
BDGCJ ---- 1099211
BDGJCS ---- BDGJCS
BDGJGL ---- BDJGL
BDLB-BD38 ---- BDDTH


What I need to do is compare the part numbers and if I get a matc
update the inventory column. I appreciate any help you can give me
Right now I am copying and pasting and that is a futile effort since
have over 1800 products

 

[Guest]

could you use the vlookup feature?

 

[RagDyer]

In your example, do you import the suppliers file to your existing workbook
or worksheet?

Where is your inventory data? - where is the suppliers?

Do you subtract his from yours ... or do you replace yours with his?

A little more info can't hurt!
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


message I am a novice user of excel and need a little help. I am using a
spreadsheet to update my websites inventory levels. I receive an
inventory update file from my supplier once a day. The problem is I
don't sell all of the items in that file. eg

My File 1 ---- Suppliers File
BDDTTH ---- 100001
BDGBB ---- 100011
BDGCJ ---- 1099211
BDGJCS ---- BDGJCS
BDGJGL ---- BDJGL
BDLB-BD38 ---- BDDTH


What I need to do is compare the part numbers and if I get a match
update the inventory column. I appreciate any help you can give me.
Right now I am copying and pasting and that is a futile effort since I
have over 1800 products.

 

[devilmountain]

I do not stock the items from this supplier so I replace the ol
inventory data with the new.


My inventory data is in a different file then the suppliers. I jus
moved to this system and I have been copying and pasting the ne
inventory levels into my worksheet

 

[RagDyer]

You can try this approach.

Suppliers inventory list is in a workbook named "SupplyInven".
Product ID is in column A, from A2:A200, and matching inventory amounts is
in B2:B200.

Since you're *replacing* the present inventory data with new data on a daily
basis, you'll need some sort of "trigger" to initiate the revision, when
you're ready to accept new data in *your* inventory worksheet.
You can use the date for this. Helps with printouts also.
Date goes in C1 - manually keyed in.
What the actual date is doesn't matter.
You'll just *match* it on your WS to activate the formulas.


On *your* inventory WS, the product ID's are in column A, from A2:A200.

The inventory amounts will display in column B.

Enter this in B2:

=IF(TEXT($C$1,"mdy")=TEXT([SupplyInven.xls]Sheet1!$C$1,"mdy"),INDEX([SupplyI
nven.xls]Sheet1!$B$2:$B$200,MATCH(A2,[SupplyInven.xls]Sheet1!$A$2:$A$200,0))
,"BadDate")

Copy this down a few cells, where you're sure that the ID's in column A
*will* find a match to the "SupplyInven" WS.

Now, enter a date in C1 that matches the date in C1 of "SupplyInven".

God willing, and the river don't rise, you should have the inventory amounts
displayed from the matching ID's in "SupplyInven".

If all's well, copy down the rest of the column.

A major snag to this working well the first time, might be the "type" of
data coming from the supplier, being exactly the same "type" of data that's
in your inventory list.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


message I do not stock the items from this supplier so I replace the old
inventory data with the new.


My inventory data is in a different file then the suppliers. I just
moved to this system and I have been copying and pasting the new
inventory levels into my worksheet.