1. Formula for Markup 2. Formula for Volume Pricing A. I have 3 files, same format on each file. Each file has Inventory Sheet & Markup sheet. I (amatear) have used (If) formula, I know you can do better. B. I have try to have volume discount formula and failed. I use hidden columns. I use Teamviewer.
tengo un listado en una columna de excel y deseo eliminar los saltos de linea de cada celda reemplazarlos por el simbolo "/" para que quede en una sola linea resumiendo: 1- eliminar el texto "Volver al listado" 2- reemplazar los saltos de linea entre palabras y reemplazar por un simbolo "/" EJEMPLO del contenido de una celda: Volver al listado
I just need a form where I can enter details and that should be added to my access database, it's very simple. You should only use VBA code in MS Access, no other language or inbuilt feature of MS Access. I will give you all the table related information
i want to make a simple inventory application for ios or android to input the serial numbers of the items by scanning the bar code of each unit, some thing like the attached file
Need VBA to sum numbers. First, the VBA looks into column B to identify product category. After it looks into column D. In column E it creates the sums with a MAX value of 800. As you can see on the picture we have many sums within the same product category.
Hi there! I have been working on an excel vba macro that transfers data from one workbook to another. The part that I am stuck on is how to transfer several rows of data from one workbook to another and at the same time setting things up so the next time data is transferred, it will go under the previously transferred data. The majority of the macro
We want to create a selection program in Excel that sends dimensional parameters to dwg files to modify drawings according the Excel output parameters. In the attached example, we might want to change four dimensions, currently "800 Channel", 1080 (vertical dimension, middle of drawing), "1067 (25% BLINDED)", and "1008 (CLEAN)". We would want the
I need a Visual basic expert for my current projects. If you have knowledge please bid. Details will be shared in message with the f...a Visual basic expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers. Please bid if you have experience in VBA. Project will take max to an hour
...even consider your offer. I have written a complicated pricing program in Excel and need assistance finishing it. For this moment you are bidding on debugging the macro "Building 1" Located on the "Quote" Worksheet. The winning person will: *Have advanced knowledge of Excel. *Be able to start immediately *Be available for hourly work over the next
...important since we are going to rebrand and revamp both mobile and desktop apps ASAP. Someone who can use bulk price editing to take the daily CSV we email you so that all the inventory and pricing of our drop shipped items is updated daily and new products are imported using the csv. If this job goes well we will keep going. Someone actually has an app
custom android app with inventory management with a bus ticketing module
...is an Excel (Mac Version 14.7.7) spreadsheet which prioritizes restock from vendors by sales volume and/or profitability. Inputs are two data files exported from Quickbooks ("sales" and "stock") which are attached. Note that these data export files can be modified to some degree if required. Also, "sales" data file includes data for all inventory year...
I need a faster VBA macro. It's important to mention that the data I intend to scrape needs expanding to view the data required. It's like vertical tabbed content if you will. XML http is faster you can use it or other way but goal is fast vba. Apply if you can deliver this and pls do so within my budget.
I need some changes to an existing website. I need you to build my online store.
I need a XXXXXXXXX expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
Throught QR codes ...billet arrivals (cast nr., alloy, supplier, lenght) from picking area; and when we will use it for produce operators will scan again QR code and should be substracted from inventory. Also we will like to see inputs & exits of database. Step to register arrivals from tablet with android. Step operators scan used material from PC.
The mobile app should allow us to scan barcodes of products we carry, and be able to add/remove them into the inventory, and should connect to our cloud inventory site through API. Adding Products: If scanned item exists in inventory database, there should be a pop up asking quantity, and location of tires. Quantity should be a required text box
We have 3 stores and i want to manage all my inventory through this software . I'll be explaining you everything once you impress me with your quotation , i need this software delivered in 7 days .
Strengthscape requires a functional trainer who has an experience of at-least 10 years in the above mentioned field. Residing in Either Bangalore, Mumbai or Hyderabad. Requesting you to revert with the profile.
I need help with developing a VBA code for the attached example document which essentially only uses two functions: copy-paste and goalseek. If you can develop and implement the code in the attached document using the named ranges, then I can import the code into a confidential document it shall be used in.
I have some issues to be solve immediately in database I have. • Responsible for MS Access, MSSQL database administration and management (capacity planning, installation, backup, recovery, monitoring, optimizations, troubleshooting, etc.) • Support the development team for database design • Review existing software architecture and contribute to improving
Best regard; I need to update automatically the inventories of one of my clients that has its on-line store developed in osCommerce. The process would be to fire from my ms sql database a query that updates the inventories in that on-line store. The process must be programmable in one hour of the day and run daily
Dear all We Need Inventory ,invoice Software with Invoice Report print Invoicing product inventory Customer Statement Tax report sales Report Voucher print And Please Don't Bid For New Development I have Good Team For New Development I need a Application Which is ready For Sale
Need Excel VBA macro to Get EndDate+Time from StartDate+time and Duration (hours) Requirement 1. The calculation should account for holidays (see holiday format below) 2. The calculation should account for workdays (see details below)
I need a few functions for this app that include: - view items, users and tasks in a gridview or listview - ability to create, edit, delete items, users and tasks - integrated database to store items, users and tasks - User authentication module - Dashboard with user access depends from role - Simple analysis module Requirements: - Language used: c# - Type of application WPF - SQL Server db
I have an excel macro which fills an online form. I just need you to add a line to the code in order to click the "Submit" button of the form. I will provide de HTML code of the form. (Attached)
I need an iPhone/iPad app. I would like it designed and built. Something like uber but its for transportation goods and inventory something like an appliction named ( Goshare ) in 2 languages one of tbe langueges is in English
...integrate with Microsoft Outlook 2016. VBA and .net framework are definitely a requirement for this application. Some design experience would also very helpful. It would be ideal if we can determine if this application will also work on Outlook for MAC. I would like to be able to create a full CRM, Document Management capabilities, and a Windows File Explorer
...data and give the output on sheet 1 and than saves it as the same name but can be with .xlsx to have the excel file in same folder. (This is open for discussion,to find out the best way to do this). 3. For association part I have one database excel sheet that I have attached. It has info about the top level parts and what accessories goes with those parts
...OF PRODUCTS AND IT'S COMBINATIONS, which makes it harder for any excel sheet or standard software to handle it efficiently. key features I want in my software 1. sales report 2. in hand inventory 3. bulk change of landing cost and selling price option 4. purchase page 5. low Inventory item list I feel Microsoft Access better suit my need. Any other
These are Dynamic formulas with IIF statements. There is a variable in the formula so they are not basic or simplistic. So please read through the attached carefuly before bidding or accepting the project. The formula are DateDiff but the formula depends on whats selected in one of the fields on a form in the database. My Max price $45 US. Please Dont bid more. If you know what you are doing...