I need a Visual basic expert for my current projects. If you have knowledge please bid. Details will be shared in message with the fre...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
...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 the project. *Normally works
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.
This project requires formulation of market strategy based on historical data and backtesting various processing for asset ranking. The optimum performance needs to be calculated for maximum profits. Exceptional skills in MATLAB are required, and involve excel and VBA.
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)
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 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 [iniciar sesión para ver URL]") 2. Workbook 2 (can be called as Association), In this workbook, sheet
...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
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
...Is there any way could pick mobile 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
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) [iniciar sesión para ver URL] 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
... Cells(8, 24).Value = "" Else Cells(8, 24).Value = Format(Now, "HH:mm:ss") End If End If End If i found this code on internet, but it does not work on excel table.. i want to update timestamp on a particular cell (cell A) based on changes that happens on (Cell B) which is based on formula which is on (Cell C) i want to link entire
Working with Outlook 2010 - Inbox and any sub folders. Have set up various Categories, which are assigned to an email via Quick Steps. When s...assigned to an email via Quick Steps. When sorting by Categories I want the 'Done' Category to Collapse, so that no Category 'Done" is visible. I assume that it will require VBA, but open to other options.
...using their API. [iniciar sesión para ver URL] We would need an expert in communicating with the Woocommerce API and Parsing XML data. The goal is 1. Automate and import/export of products from Woocommerce which would also include images for these products. 2. Update Quantities on existing items in Woocommerce
...an Access 2010 application and want to replace the Access backend with an SQL Express Backend. There are approximately 126 tables and 114 forms in the program. There is also vba code behind the forms. We are interested in receiving resumes and bids from qualified Vendors or individual programmers. Please email a copy of your resume and contact information