Please help me figure out if this is do-able.
I am looking for a way to streamline my inventory update process, I currently spending
about 2 hrs each morning updateing my inventory from a daily feed....not to mention the
cost of printing the sheets for comparison.
I want to update my current inventory sheet with the values from another spreadsheet...I want it to find the matching ID# on the feed, and copy the qty and cost figures to the product list
Inventory Feed (Info I need):
Column A:ID# (same, doesn't change)
Column D:Qty
Column K:Cost
Product List (website update):
Column A:ID# (same, doesn't change)
Column E:Qty
Column Z:Cost
My hope is that I can make a new workbook, and have sheet 1 be the code sheet (never changes), and then just copy the inventory feed and product list into the same workbook....once it makes the changes, I just copy the product list to a seperate sheet and upload it to my site......this might be a stretch.
I figured setting functions on the product list page wouldn't be a good idea because it will be changing (add / subtract items) frequently, and I pull a fresh copy of the product list everyday from my site.
I currently mess with about 200 Select items of the 8000 items I could have, but I would be stuck at my desk all day if I had to do all those items.
Any help or suggestion would be appreciated....just getting started with excel, and have learned alot from this site so far, I made a great profit sheet to track my sales, and I keep finding something to do in excel.
Thanks, Brian
Bookmarks