Currently using excel, would like to add barcode scanner. I have one master list of stock from where I distribute to different locations. I need to track by expiry date and batch numbers. My problem is I have the same product in several different locations which excel doesn't pick up.
I have attached a sample spreadsheet for these location. The only changes made to the sheet are the quantity, expiry date, batch number. The product number, product and prices columns change occasionally. At the moment it is all done manually and is set up for expiry date to change colour to warn me when product expiring.
41 freelancere byder i gennemsnit $151 på dette job
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can do this task. Please come on chat for more details. Awaiting your response. Thank you.
i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro, VBA etc. Please review my profile and inbox me. Thanks
Hi, I have read the project description & seen the attached file. I am interested so I have some query. Please send a massage so we can discuss more. Thank You