Excel Macros Jobs

Requiero un sistema de inventario en Excel de preferencia que este listo con propósitos para desarrollar un informe para exponer las bondades de aplicar la herramienta, en donde debo exponer un plan de mejora capaz de darle solución a la gestión de este requerimiento donde me permita analizar los procesos de entradas y salidas y los costos que se atribuyen a esta disposición. Si se puede poner cifras que permita nutrir ese archivo y generar gráficos sería lo ideal para hacer una descripción de como este recurso me permita solventar este problema.

Material Planning Project Skills and Experience: - Strong knowledge and experience in material planning - Familiarity with raw materials, finished goods, and packaging materials - Ability to work with specific suppliers for material procurement - Proficient in replenishing materials on a monthly basis Requirements: * Receiving Sheet * COA's, (Batch numbesrs, manufacturer etc) * Production Orders per customer per SKU * Production Planning (Report on Planned vs actual) * BOM's for all products. * Material Requirements based on planned production, Raws, packs etc, needs to show what stock I have on hand and what is required for the production run * Yield Sheet, after every production, I do a yield sheet per product, showing the opening stock you had, what was actualy used as pe...

Create one excel with macros to validate data other excels based on different rules. Please find attached screenshot for the same. First excels should have buttons and option to upload other excels. Demonstration available.

WANT TO CREATE SOMETHING FOR MY BUSINESS REGULARLY?

I am looking to develop a custom Python program that can generate a set of 10-14 Excel files. The program should be able to take the pre-existing Excel datasheet that I have and use it to create a set of files that can be read and manipulated as needed. Structure of the generated files should also be customizable, and they should have the capability to store and analyze data in any way needed. I have attached the requirements and the input/output file for your reference. Kindly go through them before bidding to avoid further problems for both of us. Also the outputs should follow the logic mentioned in the steps file but don't have to look exactly like the ones present in the input/output file presented. You are also free to generate each output in different excel files instead of she...

I have a spreadsheet containing approximately 3000 email addresses and approximately 3000 phone numbers. I need the following steps to be done for each email address and phone number: 1. Search google for the email address or phone number; 2. If the google search for an email address is "no results found" delete the email address in the spreadsheet and replace the email address with "Email Redacted Because Not Held Out To Public" in each place email address was found in the spreadsheet; 3. If the google search for a phone number is "no results found" delete the phone number in the spreadsheet and replace the phone number with "Phone Number Redacted Because not Held out to Public in each place phone number was found in spreadsheet"; 4. For each of th...

Hello, I am looking for freelancer that can import data from website to my excel file. I am sharing the website: The data I need is : Son Fiyat (TL) 2,052654 Example: I will write fund Code to a1 on excel ( it is end of the link: OTJ, IPB , BUY etc... ) and the price of fund will be imported from website to b1.