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.
...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 column Y that containY. Example input data: [kirjaudu nähdäksesi URL:n] I have highly detailed instructions written out for this project that I
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.)
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
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.
...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 is
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
...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 10 days to assist me complete
Hi Balint K., I noticed your profile and would like to offer you my project. I have a excel workbook. With a VBA userform data is inputed into a master table. Additionally I also wanted it to copy that input to diferente sheets depending on one criteria (like master table all inputs, then if is about car also copies to car sheet but if is motorbike
...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 dat...
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 a XXXXXXXXX expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
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.
...performance • To be fix a issue for building high-performance data persistence systems Requirements • Bachelor's degree or higher in Computer Science or related field • Solid understanding of MS Access, MS SQL Server database technologies and experience with SQL query/SQL programming • Familiar with VBA scripting programming and C#, .NET skills • Exp...
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)
...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 Management
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 [kirjaudu nähdäksesi URL:n]") 2. Workbook 2 (can be called as Association), In this workbook, sheet
These are Dynamic formulas w...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 this will take you less than 30 minutes to do.
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
Pls refer to the sample file of the attachment. Is there any wa...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) [kirjaudu nähdäksesi URL:n] the Date in Cells A6:B6
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
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
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
I want VBA code in excelsheet, its look like an invoice sheet i want a save button with this form one I click that it will save the invoice same of the id + open new invoice with the following number directly.
Hello, I found a little company. All the entries my expense and revenu are organized in a excel spreasheet. I have my budget for each location. I'd need help to how my entries in my ledger can be linked to my budget so everytime I put a need entry with a refresh it can updated in the budget in column called actuals.
Hi, I have a field 'Field' in attached excel and I want a VBA code that will loop through the column values in Field and create a new field 'Field2' which will flag 1 when loop hits the last value in the Set of same values. Finally, the macro should delete the original Field, retain Field2