Vba creare xml jobs
...data on a daily/weekly basis. Based on the few conditions , it has to be put into specific cells in the main database with minor manipulation. Looking for an expert excel/VBA freelancer to assist . Sheets DQ-45, DQ-46, DQ-47 & DQ-48 are identical. However they represent 4 different people who move to various locations . On each location various activities
I need and expert in Visual Basic for Applications to create Macros in order to automate tasks in Excel by writing so-called macros. This is for a project repeated every 3 months. Attached are the spreadsheets we have put together. I also attach the end result which gets fed through the excel information. We take the financial statements for ten banks in one given country. We then input all info ...
we have a database in Microsoft Access and we want relied this a management planning for our drivers. please disc...Microsoft Access and we want relied this a management planning for our drivers. please discuss in private for more details not need you share with me your other skills, I want only VBA developer and if you share other skills I not reply
I need a VBA script that will use the spreadsheet and create outlook emails that will send to each individual recipient listed. Example email body: Hello, I see that PO# (value from spreadsheet) was not picked up yesterday. Can you please advise if this freight is ready for pickup today?
Some bugs to fix for a printing label VBA software
We have an input sheet with multiple columns where each contains number of alphabetic variables ranging from 7 to 60. Objective is to create various permutations of those values by combing values between certain columns using a specific logic with a number of conditions and exceptions. For example: combined values from columns A, B and C except if a value in column B=X, then only pick values fro...
We have an input sheet with multiple columns where each contains number of alphabetic variables ranging from 7 to 60. Objective is to create various permutations of those values by combing values between certain columns using a specific logic with a number of conditions and exceptions. For example: combined values from columns A, B and C except if a value in column B=X, then only pick values fro...
Need someone expert in Excel. I have an excel file and i want to translate it in English. Also it downloads data from web, and i need to have it online, so i need to transform it into a googlesheet file.
adding multipage and adding a new function
We have an input sheet with multiple columns where each contains number of alphabetic variables ranging from 7 to 60. Objective is to create various permutations of those values by combing values between certain columns using a specific logic with a number of conditions and exceptions. For example: combined values from columns A, B and C except if a value in column B=X, then only pick values from ...
I have a macro to be fixed. It was done by some one else but its not working perfectly as i wanted. Thanks
Hi, I have a VBA code written in excel file (macro). It performs the calculations. I will provide you the code and I need someone to provide detailed description for each line of the code. (eg. how code works, what each line does, what each line means etc.)
Job details will be provided later. Hourly job. Please bid only if you are free to work from today.
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
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
Please don't bid without looking at attached worksheet. If you do, I won't 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...
Desired output 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-t...
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.
Need regular assistance with VBA excel
I need a XXXXXXXXX expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
Create a VBA macro for import data to excel. Data from link on website.
I need a XXXXXXXXX expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
Hi Jorge. I have an excel project, might potentially need VBA. Shall we discuss?
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 excel file with list of web site. Need to remove pacific URL from the excel file automatic to follow instruction.
Hi Vba A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
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 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)
Hi, I need help with my VBA assignment. It might take only 20-40 mins for an excel pro n some training to answer the viya questions.
Hi, I need help with my excel Vba project. It would take only 30-40 mins for a pro
Hi, I need help with an assignment and some training for the viva in excel/vba
I would like to create an application that will 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
I am looking for a person who will write a code in VBA that will convert an Excel spreadsheet into a .xml file. .Xml file compatible with UTF-8 encoding.
Large amount of files and web links need to record them, and add fields. Browse and add files [login to view URL]
I have to sort Bill of Material data that I am getting from Inventor and than associate additional material to that data and arrange it in a pre-defined format. Images attached are explained below. 1. BOM (Bill of material) exported from Inventor.(saved as "name of [login to view URL]") 2. Workbook 2 (can be called as Association), In this workbook, sheet 2 should have the macro that pro...
i need a speedometer using vba macro any guys are specilist can be hired for long time
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...
Hi All, I have a very small VBA job. My budget is INR 500 if anyone is interested please bid.
Looking for an Excel expert to create a spreadsheet for entering parts onto our ERP System. The purpose of the spreadsheet is it will capture all the required fields to be entered and perform some basic error proofing, such that we can see that all departments have entered the relevant data. The spreadsheet exists and pulls some basic information from SQL for error proofing and selecting correct o...
Hi Vba A. this project is for modifying the database, organizing the planning by groups rather than by teacher.
To prepare versatile Macro to clean-up delimited data in Excel, which are regularly exported from the system.
Pls refer to the sample f...phone number(this is companies list in Jordan, mobile phone number contains 77 and 79) and email from the excel? I can do it in manual, but too many files and I think excel VBA could handle it in short time You can see phone number and email locates in several columns, not seperate one, increasing difficulty in manual work
Need Help writing a Macro. Would do the following; 1. Show Input Box to prompt User to select 2 Cells of Date - Named/ Customer Name and Project Name 2. Copy that Data 3. Open Another Sheet in the Same Workbook 4. Unprotect the sheet 4. Insert a Row into a table named Active_Jobs (row to be on top of table) [login to view URL] the Date in Cells A6:B6 which would always be the first row o...
if Column 1 AND column 3 are the same, then these rows should be together in column 2, divided by a comma
I have two tabs that need combining and a batch of PDF invoices created. One tab is a database of sales transactions (Value, Address, VAT number, etc) ('Invoice Back Data') and the other with an invoice template ('Invoice Template') which needs one order per template. Currently the template is linked to the order. The macro will need to produce a pdf invoice for every order on ...
We have a single for form in MS Access accdb 2016 for collecting asset data during a site audit of furniture, fittings and equipment in a commercial site. The form needs to have a button and image control to take a photo using the tablets built in back facing camera. We are currently using a Samsung Galaxy 4 tablet with Win 10. The image would be saved to a nominated directory on the tablet HDD a...
Need Excel VBA (Macro(s)) for building an Excel database in an existing spreadsheet, and backfilling data changes/updates made in one worksheet of that workbook read to that database back into separate database. The macro(s) will allow users to change or update data inputted in one worksheet, and have it copied and pasted (values) to another, then another
