I would like to hire an Excel Expert to correct a faulty Excel VBA Sub. I want to 1) Transpose a column to a row, 2) Multiply that row times a conforming matrix, and 3)Transpose the result to a column. Attached is an Excel spreadsheet with some data and some defined ranges. It contains a macro triggered by the only button on the spreadsheet. ...
I need some help with finding an accountant to solve some accounting issues and interpretation of data from excel files. I need some high level expert in this field please . Include "Unicorn" in your bid otherwise you will get reported.
I am looking for someone to help me put together a small excel which has certain conditions and criteria and functions that auto change and update as values entered. This will not take more than 30 mins for an excel expert. Need the same to be done by tonight without fail, so if you feel you can do it...lets get together
Hi, I have a bit of a challenge making a table for monitoring orders. I am a supply chain intern now and my task is to prepare this. My main idea is to compare “promise date” which is the date promised to deliver the order and “lead time in days” which is lead time for specific component of the order from the supplier. So the question is how can
I have got a VBA Macro for Ms Excel coded by a VBA Expert. I want some changes in it, need to delete something & add few new contents. It should be a simple project for an expert so lowest bids will win this project.
I need to create a user interface on Excel or similar program if you recommend. The data i have is a table with different energy efficient projects that have up to 6 variables. Depending on the variables to prioritize e.g. best projects with high CO2 reduction and low investment, there will be different projects selected. I want to create 4 different
...different reports, need to generate a database in excel to record date, and the database needs to give the date of one month, two month and three month of the due date, and generate a result sheet with projects that are due within a month of "today" and their future two,three months due date in order to help us plan report ahead. need help about how to
I'm using Excel 2010 and saving my worksheet in Workbook Excel-Macro Enabled Workbook or Excel Workbook. Numbers with decimals will add/subtract,multiply and divide. However, formulas using Min/Max, IF, And, Median etc; do not return correct results, in this case "Y","N". Numbers with decimals default to "N". All cells are formatted as numb...
I am wanting to create a sheet that run's a macro for crew rostering that will auto-calculate crew members rostered days on & off for the entire year once given a start date for each member. In the attached, I am not sure if I am structuring it as best as I could be. The crews will work 14 days on & 14 days off. I would like to auto populate that as
...into Excel, but the formatting does not appear to conform to any traditional method. It is not delimited by comma, tab or spacing. Each row begins with a variable identifier, and then no delimitter. I need the help of an data expert. Please see the attached file for a link to the file I'm downloading, and a few screenshots of the data as I se...
...is [ログインしてURLを表示] We have a M2 template to install and custom modules that we have purchased from 3rd parties that also need adding. Any coding requirements need to meet Magento best practices. Ideally looking for an expert developer with experience who can ensure our server is secure and performing correctly for M2 and can advise us where needed
I have an employee schedule in work. I would like to put in hours and get totals in an excel spreadsheet. I want a template I can use each week where I put in each employee in each classroom and the hours they are working and the totals show up automatically. I want it to look pretty with colours and be able to print on one page I<...
Hello, I require an excel expert to work on an existing excel sheet. You must have an excellent knowledge of Excel VBA, Macros and add-ins. The sheet already contains a lot of existing code which has some bugs which need to be fixed. The main part of the project is to create an add-in for mapping. This need to be dynam...
Deliverable: Working Tableau workbook around data types and desirable contents Freelancer sought: Expert Tableau builder with understanding of statistics (will need some statistics calculations in report) Specific needs: 1) to create a type of "psychometric" view in Tableau. Sample data can be provided. Basically, each individual in the data needs
Hello! Our bus...is in the fashion industry. We have 18 retail stores across the United States. We are having issues cleaning up our contact list. There are multiple duplicate contacts that need to be merged into one contact. Our issue is that some last names are entered as first names and vice versa causing the system to not recognize the duplicate.
I need somebody to build a reliable data scrapper to get me the information I need from an Excel Document. I will give shared access to the selected freelancer and further instructions on how to do it. Basically we are searching a description for certain text and then manipulating the extracted text a little to get rid of %'s. Thanks and please...
I need someone who is an expert at making custom sheets and formulas within Excel. I'll tell you what I need done before I'll award you and if you can do it then we'll go from there. keep in mind, it is an advanced function that I need implemented, so don't apply unless you really are an EXCEL <...
3How much force in body weights (force/body weight) was produced just prior to takeoff in both jumps (i.e. the propulsive force) ...(force/body weight) was produced just prior to takeoff in both jumps (i.e. the propulsive force) in each jump (*hint extract your maximums using the force plate data, and you will need to normalize your peak force value)?
I need a freelancer that is an expert in using Microsoft Excel. I have five spreadsheets containing around 5000+ entries that I would like to combine into one master spreadsheet. The final master spreadsheet must not contain duplicate entries and all entries must be in uniformed order throughout. i.e columns all in same order.
I have a different way to calculate food costing and managing recipes than this attached example. But I am not an expert in Excel and need the formula / coding behind this worksheet (which is locked). Can you help!
Well title is self explanatory. I need an ETSY SEO expert, who can prepare listing for my products and can deliver me in excel format. Optimized title with high volume and low competition keywords Well organized description including relevant keywords Relevant tags. 250 products - SEO friendly title, Description and Tags to be written. Written
We are a private development firm. Need to hire an excel real estate modeling pro that can take the current pro forma to the next level to layer in a rental model and a "roll up" portfolio model from single assets that are under development to a portfolio of assets under construction.
I need a data mining expert to compile a list of Strata Management and Building Management Companies with good, Quality Data, I will need the companies , Name, Email, Address and Phone Number on an excel spreadsheet at least 500 records from the Sydney Area.
I need an excel expert to help format a large spread sheet and to enable me to produce reports
I need an excel expert to add the rows up in copied website data. I know how to use the sum formula but for some reason it won’t work. I would also like the person to extract this data weekly from the website for me and send it through to me.
I will be posting this for the third time. The last two coders could not provide assistance and I lost money. I request the following: READ THOROUGHLY 1. An automated way to compare two sets of data and remove duplicates in Excel 2016. 2. It must be a working sample for me to approve paying you. I have already paid two coders prior to completion