Inventory management application: 1. Input of tea purchased manually or copy from excel sheet 2. Differentiated on columns: Garden Name, Grade, Invoice No., Bag Size, No. of Bags, Total Kg, Price/Kg, Input, WIP, Sale, Closing 3. Categorization of different teas on the basis of quality - Good, Premium etc. 4. Creating batch for WIP (drag & drop) 5.
Hello We have several thousand listings active on ebay. Each listing is impo... Each listing is imported from amazon withou seller account login. We need a fast sync of inventory for each variation for all listings. The product id for amazon and ebay is same for each product variation. So you can take that as a criteria for inventory cross check.
I need a programmer. I had an excel file of renters for a residential & commercial building. I prepare this file monthly. It consists from columns with Flat numbers, it’s kind (residential or commercial), renter name and rent And the era paid for rent at its time it is in Hijri calendar from...to... You can get and update all information from last month
1. Create Input Sheets using the example to be provided 2. Populate the sheets with sample data based on the example to be given 3. Write a macro to import and merge all the input sheets into one 4. Write macro to create other sheets in the master file to analyze the data based on instructions to be provided 5. Create a Gantt Chart based on the data
Need help preparing for a test on operations and inventory management. Things you need to be able to do are: -Calculate process/system capacity and bottlenecks -Compute Mean Absolute Deviation (MAD) and Mean Absolute Percentage Error (MAPE) -Calculate Seasonal Index, Indices, Average Seasonal Index -Use regression line and seasonal indices to derive
I'm looking for someone who can create VBA Word 2016 templates for a law firm, based on our needs as they come about. We have current small access db, that some of our templates pull from, that can be used when needed.
Hi , i need our inventory management software to integrate with WP / opencart or mangento and then need android and ios app for frontend, our inventory management software export excel file (2lakhs products), we want to edit it , add few more fields and want to upload to our shop please quote with samples and send me how you follow this , layout
##Advanced VBA skills and high experience automating excel will be needed to understand the code written so far, debug and complete the work according to spec## A VBA programmer has done most of the work according to the attached Statement of Work, however due to personal issues he has not been available in weeks to complete the work. This has been
Excel Macro VBA - assistance with VLookup in VBA Hello The purpose of the macro is to process each row, and when there is a certain condition, correct the entry in the cell. I am using (attempting to use) VLookup to access the values in the 2nd sheet and correct the values in the first sheet of the workbook. Receiving the following error when running
build a macro which will copy data from one excel workbook to another. for each row in one excel file the macro should create two lines in the other excel workbook. in the column A of the new file CA should be written in the first line and SL in the second one. also in column E should be filled with text "y" as many as rows
Looking for very clean APP to inventory a collection of items. Ability to take photo on phone / iPad, add details, add location, save to database. Able to run through sections in the database, scroll through imagers, select specific items, and move these items to another location. Able to generate reports of where items are located.
I am looking for an Excel VBA programmer. I need to develop a Warehouse Management System in Excel with the help of VBA programming. The task is to setup a Master-Data file (Excel) that should function as a database. I need you to create an excel for every team where they are able to store data in Master-Data and retreive information from the Master-File
We have an excel model with macros that converts raw excel product detail data from suppliers to the format we need to upload into our store. We need to fix this model as it appears to have some bugs. For example, in the attached file "Dreamline..." file, the model populates column "A" (parent_sku) with values for SKUs that have no parent SKU (see and
Hello, I want to streamline some tasks for my colleagues so I want them to be able to do three things using separate buttons on an Excel sheet. I can do the buttons and attach the macros but writing the macros seems to be beyond me. I need as follows: From one button: Save a template .xlm file as a new file in a specified location with the file
I need you to develop inventory management module and integrate the same in our current application. I would like this to be developed using .NET and SQL Server. it has to be web services based.
I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard format. The format being "Deal Name", "Task & Description", "Key Date", "Organizer", and "Commen...
I have got a VBA Macro for Ms Excel coded by a VBA Expert. I want some changes in it, need to delete something & add few new contents. It should be a simple project for an expert so lowest bids will win this project.
OMO_Import - Potential crash when the time stamp on the import file is not "0:00". Modify the macro to ignore delivery time and only consider delivery date. SENDORDER - Modify the macro to generate an image file whenever the parameter for "Breakdown" is set for Y in the Suppliers worksheet MYOBvsOM - Add a column to sum the totals of price plus gst
...you-------- -----------------PROJECT DESCRIPTION: I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard format. The format being "Deal Name", "Task & Description", "...
I am a book publisher located in the United States. I need a purchasing tool that will take inputs including unit sales history, point of sale sales history, costs for different production quantities, desired months in stock and expected turnaround time and will output a recommended reprint time and quantity. Since the costs are constantly changing, and we have more than a decade of prior data t...
* Background on the project: We purchase truckloads of inventory for which we receive a rough list of products we should be receiving. Upon receiving we would like the ability to scan through and confirm receipt of goods from that load, mark damaged/destroyed goods and also scan products we received which may not have been on our list. Through the
Advanced VBA needed in 24hrs
Hello, I have a small Excel VBA project to be completed. Data is not large but needs to just be automated to fill data to a template. Need a good knowledgeable person to help me out. I will send the files later. Need this to be done around this weekend so you need to be available then. Budget -10$. Any bids for excess value will not be considered. Thanks
I am looking for lead generator and sales person, who will work along with me (remotely) to adjust the business for leads and get some sales. If you're interested, please comment with your previous experience in generating leads and also please add portfolios to your profile.
Hi, if you are an expert with VBA, access and word, this project will be very easy for you. I have a * very small and basic* invoice database with client, invoice and billing tables set up and need some functionality, user interface and reporting added to it: Functionality Each "client" entry has multiple invoices and each invoice has multiple billing
Build a custom cloud-based inventory management platform similar in functionality to tradegecko with the following features. - Multi-tenant (able to host multiple companies) - User management (with different rights) - Supports B2B selling with discount (products can be assigned to group A, B, ... and different discounts assigned to the groups)
I would like to build a tool that will allow us to better manage our user lists and service Providers. Function: I would like an excel to hold the following data: List of all teams List of all users in those teams List of all service providers contracted with those teams and the budgets Contact details at service providers Email text The above data
Full details will be provided with examples to the winning bidder. Simple explanation: - Create a macro in Excel - Have it replace the placeholders in powerpoint when the script is run - have it then save the powerpoint to pdf OR jpg, depending on what the option is asked for. Should NOT be a long job and it's work for hire (meaning I own it and can
An existing excel macro has been used to generate invoices from fixed cell references within a spreadsheet and to create a pdf file. Our payment terms have now changed for the first time but the macro does not seem to be picking up the changes.
We habe a little Rental Management System in Excel. Now we need some VBA funktion to Create a Picking list. what is to do ? 1.) Every device has a button whit his special information in it. So we have to develop a function that will save this information. 2.) we have to put with checkbox selected devices to a picking list on a another sheet
We have a set of tools in excel, that uses VBA, we need to fix and optimize some macros in excel
I have an excel sheet which will keep on adding new worksheets or deleting existing one. The current VBA code, creates a table of content, with the page number for each worksheet. However instead of the page number, I need the first page number of the print preview page for each worksheet. Attached is the excel sheet, and in the cover worksheet, I have
My name is Wayne. I am a personal trainer and nutritionist; I offer my services both in person and online. I want to create a macro calculator built into my website. A macro calculator helps people calculate their calories based on different factors. Essentially I want to create a pop up ad for my website that will calculate their macros after they
We are looking to hire 3 individuals (or an Agency that can provide 3 team members) to help us update our dealer database of actual "on-the-lot" vs "listed online" inventory of various car dealership websites. We will provide approx 30 minutes paid training to explain the process and answer any questions you have. We will start with a small segment
Create a macro that will take a excel file with data in 3 worksheets (the data in the same format), and through a new macro associated to a button called ‘Create Schedule’, combine the rows into a new worksheet called “FinalSchedule”, adding 3 rows for specific times (9:30, 11:00, 13:30) and adding a priority text values (Emergency, Standard, Deferred)
- I need someone to work on my Excel VBA project. - Lots of worksheet referencing, saving as PDF, message box, etc. - The excel spreadsheet attached should list everything that needs to be accomplished. Any other questions can be asked upon confirmation.
1 – Read a file of existing employee IDs 2 – Accept data entry from a user 3 – Write the data to a CSV file Details 1– Read t...including the header row. For the hourly pay, save the data with two decimal places. Deliverables: For each program submit: ➢ Program analysis ➢ Hierarchy chart ➢ A working VBA programs with good internal documentation.