I need a macro created so it calculates the Sale Price & Shipping Price of our products so that we make 20%. The profit calculation is as followed; Profit ($)= ((Sale Price + Shipping Price)*.85) - ODT Cost Profit (%)= (((Sale Price + Shipping Price)*.85)- ODT Cost)/ODT Cost Again I need the following Sale Price & Shipping Price. Rules:
...convert data contained in array into tabular format. 1st row is the header row and in the output date column names would become the row values in a column called Date and the integer values would come under a column called Hours. Integer value would move to row corresponding to date. See Raw to Clean tabs in file attached. Desire VBA macro solution
I need a simple excel vba macro to automate turning excel file flat for access import.
Microsoft Outlook We would like the ability to SEND ALL emails that are in our DRAFT folder. We have multiple email accounts within Microsoft Out...have multiple email accounts within Microsoft Outlook so we would like to be able to specifically nominate the draft folder to SEND ALL. We believe this may be best via a Macro. Can you help?
I need a MACRO built to save a worksheet as a PDF with the file name of a particular cell, then mark the file saved on a different worksheet (one workbook) I also need a formula to pull multiple values based on one cell
I need a simple macro to insert into my document. The idea is that, depending on the type of building, its size and insulation, to select a different energy cost, productivity, etc.. Kind Regards. Alex.
This is not excel VBA. This is word. should only take 15 minutes. the file contains bugs need it fixed. Please start your proposal with word "NotExcel"
Tengo una planilla de Excel "DATOS" y necesito que de acuerdo a un valor "SKU" busque en otra planilla ese SKU, copie datos de algunas columnas y las pegue en las columnas correspondientes a SKU de la planilla DATOS.
Tengo una Base de Datos "BASE" en excel (SKU, PRODUCTOS, DESCRIPCION, ETC) y otro Libro "SKU". Necesito que con los datos de "SKU" copie en otro Libro "ENCONTRADO" unicamente los que figuran en el libro "SKU" y en otro libro "NO ENCONTRADOS" los que no encontro.
I need you to copy and paste in excel from PDF as per instruction provided by me. I need this job to be completed by tomorrow. Please bid if you can only complete and deliver the job in time. Very small works.
...using the Account button under the Send button. Normally the default Exchange account is selected but you can choose any configured account to send from. What I want is a Macro or Outlook VBA code to run when the Outlook Reply or Reply to All button is clicked that will look at the domain name of the To... address field and if there is an account configured
I am a Purchasing Manager in a factory. Due to the outdated ERP, my buyers need to do many routine and time consuming job which waste them a lot of time. One of the most...One of the most time consuming job is to split the open PO report into various suppliers and then send to various suppliers by email. I want to automate this job by one click macro.
I need a form filler that logs into different accounts and posts in different categories and it uses titles , body, and images that I upload and it posts randomly. it also needs to be able start a short cut on my desktop
Simple excel macro which use Bittrex exchanges API. Base code in here: [accedi per visualizzare l'URL] you will find everything what you need in there. In the app we need few parameters: -API Key - StopLoss % - CurrencyPair - Price Check Interval in Seconds Macro need to do Trailing Stop-Loss which is for example: For example, a
...1st row in excel and pull/copy relevant data (price, description etc) and paste to relevant box on donedeal and then open a folder and select first 1st picture to upload on donedeal then move to next row on excel and 2nd picture etc. I see a guy write one before that copy from excel and move onto next row each time and copy relevant ...
We would like to have our VBA Macro enabled excel file as a web application with a login mask to manage the user and the ability to call this service from a different web application (SOAP, Json) .Skills Application Server Tomcat o PHP 5.x o 7.x, Linux Centos 7.x .NET su ambiente / / IIS MySQL o SQL Server
I have an excel macro that takes data from an excel workbook, and generates multiple outlook email messages from the data in the excel workbook. This code works right now in windows excel, but not with mac excel. I need to make this code compatible with mac excel.
I will provide a input and certain set of logic. Code needs to linearly read the data and present it in a pre-defined format in terms of outpur.
Need to build a macro that will record result in the defect type column f. If column d contains the word bag and column e = 1 then record defect type as oversize. Second calculation is to perform a count of distinct column d and then determine if that count is greater than 60 percent of its matching quantity of column e. If true then defect type recorded
All functionality to reside within an Excel workbook and be fully unprotected for future use by others. All code needs to be fully notated to describe functionality, etc. No proprietary or exotic applications or maintenance restrictions to be used. No functionality, additional prompts, etc. should be added other than what is requested. Need to add
Hello Freelancers, I have a small work for Excel macros. Details in PM
create a macro or formula to convert text to number in column "G" and place the number value in column "L" Example "-975 " is in column "g" it is stored as a text, place the number value in column "L", remove the spaces This can either be performed as a formula or vba macro This is a micro project, budget $5/ to be completed in 1 ...
Hi I will need simple VB Macro which will be taking into excel JSON data from website api. Requairements are: How Often data will be refreshed (excel cell value ) (Start/Stop) button. Data to be addet to spredsheet continusly up to 10000 records ( FIFO - once number of rows hit 10000 oldest records are deleted to make a space for new ones ). Only
I need a simple Excel macro to go into a folder and open any CSV workbook within the folder, 1 or 100 workbooks, convert the file from CSV to Excel. Excel macro needs to fully unprotected and every line notated for conversion to local PC, etc.
i have xls wanted it open in excel file with groups and with sub totals and with design
Hi, I need a small macro to be coded and the requirement is as follow: I have an excel with historical stock market data (sample attached) and it has so many stock recommendations. Now if I can buy only 5 positions at a time (due to my limited money), we need to pick those 5 stocks at any point in time from the excel sheet. 2 points to note:
I am looking to hire an excel expert, must be a VBA expert (no recording of macro as it will require you to write custom code). I will require you to make a template for me to import various balance sheets. I will share further details with the short listed freelancers. Please start your application with the word - "VBA EXPERT" so that I am aware that
We are looking for a Excel Sheet, where we will enter the product's component (fixed values), later it will 1. create the variants itself taking attributes itself and 2. Also calculate the total price itself. 3. Price will be based on the component. 3. Categories will be assigned to each variants. 4. Features once selected , will be copied to
I have list of domain address. I need Company address & Contact number based on domain. Is it possible to do?
I need to develop a macro to control a Windows application to perform some automated tasks. The application is a cloud based messaging app and I do not own the app. I just need to macro some tasks to perform on the app. More details to follow when we talk privately. Some of the skills required: - Perform tasks in the app - repeating this
We will provide few input files. Macro should read content from the input files and prepare excel sheet in pre-defined formats. It should also run validation checks based on defined logic and flag if any error.
Tengo un libro en Excel con dos hojas. "Retazos" y "Usados". En la hoja de retazos quiero agregar una condición que filtre los datos de esa misma hoja por UBICACIÓN, colocando ese dato de forma manual en la tabla pequeña que está junto a la tabla grande o base de datos... un vez que coloque ese dato de ubicación y también de form...
Hi, i have two files here. Currently i have to go to mailing sect...have two files here. Currently i have to go to mailing section in the ribbon. Then click load existing data, find the excel file and select the sheet. Can you automate the whole process, where the printing, will select data for all sheets in the excel file and print all of them out?
I need help to develop a macro to control an android app on an Android Emulator to perform some automated tasks. The android app is a ride sharing app, and I do not own the app. I just need to macro some tasks to perform on the app. More details to follow when we talk privately. Some of the skills required: - Perform tasks in the app - repeating
Currently, the excel VBA breaks down all the mailing address into groups of 30 in a sheet Errors in this macro: 1) The final sheet does not have "A" in column A first row, "B" in column B first row, "C" in column C first row with the entire row frozen 2) The sheet starts from Sheet 3 not Sheet 1 Please rectify
...BUTTON, MACRO STEPS: Step 1. RESET > Clear all data in "Import sheet" and "Convert sheet" Step 2. IMPORT > Open the *.xls files in the source folders and copy the data and paste to Import sheet. There could be more xls files appending the data from the last data. Step 3. MAPPI...
BOM =...is a document used that has details of all the raw materials that are needed in order to produce one unit of a finished good. In the Macro, we need each BOM to be in a particular format in one sheet only. The Macro helps us to create a BOM in a separate sheet for any one of the Raw Materials present in a parent BOM by the click of a button.
I need a Excel macro developer to work for me on my project Condition: Payment: Will be made after project ends. Budget: $25 Estimated time: 5-8 Hours depending on your skill TIme/Duration: Project needs to be completed in 2 days Maximum. If completed in one day then he will get a bonus of $5 Please start your Cover letter with " I READ AND