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. There are
result in column F needs to be the elapse time from column D minus E in hours and minutes. Also need the actual formula to copy and past myself on other similar calculations. I can only supply column D and E as shown.
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
...accounts so that you have accurate financial statements • Employee data : we have data in detail information in excel • Setting up customers and vendors : We have 3 customer & 10 vendors only . we can provide the data in excel .need help to setup in quick book • Connecting QuickBooks Online with our bank and credit card accounts to ensure all income
...when the lead time for specific component will exceed the “promise date” and to be proactive highlight it orange and somehow subtract 14 days from the lead time so it will give an information before it’s too late. I’m not so advanced and I’ve been trying to look up some guidelines but I couldn’t finish that on my own, so I hope you can help me
We are ...searching for a German linkbuilding expert which will pay per link and article publishment. We need a German linkbuilding expert that can do the outreach and will deliver us the link, anchor text and publishment date in excel which we will send directly to our client(s). If the first assignment goes well we have an unlimited amount of work.
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.
Do you have 2-3 years Accounting experience, expert Excel skills, and a hunger to learn new skills and processes? Then you might just be who we need for a newly created pivotal role in our Financial Operations department. Guided by department objectives and priorities this position is primarily responsible for maintaining the partners' capital and loan
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
...you’ll be doing... You’ll be combining your natural ability to solve issues with your desire to help our customers. As a member of our Business Operations team, you’ll be the expert providing post sale account support to our Wireless business sales customers. Your role will be critical in diagnosing and troubleshooting account issues while educating customers
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 ...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 a visual for each month. You will see an example of the 2018 end of the year in the first tab, however, I want to make it automated for 2019. Any help in the right direction is appreciated.
Hi, We have an inventory of 700 products in excel file split in many sheets. - For some sheet ( about 600 products ), you will need to scrap the image link on a specific website ( only the images link, we already have all other data ) We need a shopify expert to build the CSV ready-to-upload file from this data. - We have a template to use for the
Hi, We have an inventory of 800+ products in excel file. We have all the specs, name, sku, image link etc... We need a shopify expert to build the CSV ready-to-upload file from this data. - We have a template to use for the description. All specs must be integrate to this template. You also will have to link many products data together before to
I'm trying to import a .txt file 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
...is [login to view 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 do have to be able
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 dynamic. It ...
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 do not
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 expert from tec...
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.
...are looking to hire an absolute expert with PHP to take over our existing PHP app. We found a few bugs that need to be fixed and also want to add new features. Very lightweight php system we have, any expert can handle this. Some of the features we will need to add: - update to latest Google Map API - Add export to Excel function - Filter