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 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 [login to view URL]") 2. Workbook 2 (can be called as Association), In this workbook, sheet
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...
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) [login to view 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
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
..."" Then 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 ...
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.
...docs/?php#introduction 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 3. Set WooCommerce parameters for these products (ex: New Products
Hi, I run a warehouse. In order to manage our inventory dispatches to our customers, need to build Excel tool (using VBA and macro) for inventory management. Need someone who is very good with VBA and excel macros. Thanks
I need a salary tracker, that will determine my gross and net pay also will counts days worked. I need this to also once it get to 170 days worked, on the 171 day plus wi...hours, it will calculate a set day rate . I'm including this sheet as a guide, but I'll be looking for something new from you, not the same one. You will need to be able to do VBA
...simple marcros in VBA that are, generally speaking, [login to view URL] formulations, then combine the coding for all into a single macro. The Code for two macros will have to identify with some complexity a paste location back into a database. I expect the coding of the first four macros to consist of no more than 15 or 20 lines of code including an DIM
I’d like to automate, recreate/ redesign excel report, create template; Knowledge of vba macro, powerpivot and power bi will be helpful; available to communicate and respond to email ASAP. Thank you.
Looking for freelancer who is well versed with Excel VBA to be used on simple finance question. Looking for someone who can help code out NPV and IRR values for the scenarios, create a graph visualizing the NPVs. Drop me a message if you are into this
...in years and months. I can work out the ages in years using the datediff function but can’t work out how to refine that to include the date as well. I have no experience with VBA codes....