I need help with economics. Three projects to be finished in a timely manner. Masters in economics is preferred.
We have a financial modelling calculator that is having issues when transferring data in from an external source (CSV file). The original programmer is no longer available to trouble shoot. We are in need of a programmer going forward so there may be more work to follow if this task is completed to our satisfaction. ASAP Update: AUS/NZ preferred
I would like to automate a report based on a series of questions my empoyees fill out out. I need a way to auto generate a sample phrase into a word document based on a yes no question. So the employee checks of yes or no on a form. If it is no then then word will generate a response. If the employee checks yes they will have the options to check a/b for an answer and that will generate an answe...
I need you to develop some software for me. I would like this software to be developed for Windows.
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a macro/script to delete those values and align all other entrys in mutiple sheets.
Code to copy from a worksheet with multiple pivot tables, timeline slicers, and a pivot chart into a new workbook and retain formatting (freeze pane). We need to copy the date from the pivot chart to the a new workbook based on every filter in the pivot chart
Try to code in VBA but it's not working. Trying to select on range of 2 original columns and match a new column and replace it with one of the original columns.
Convert a Single Excel Macro VBA Calculator file with buttons and simple math formulas to an Android App to be used on Android Phones.
I have an Excel spreadsheet that uses the worksheet_calculate function within VBA to monitor changes to a cell on Sheet1, which in turn triggers a timer whenever a change is made to that cell; worksheet_calculate is used instead of worksheet_calculate because the cell contains a lookup formula that references a table on another sheet within the workbook
Manufacturing business wants to take a daily download excel file from GE Appliance website and create a Macro/VBA tool for non-excel users. The tool would look up our internal part number and box count from a table and output a pick sheet for shipping with customer part number, our part number and number of boxes. Should be able to select time range
Need the file automated. I can provide a full walk through on how its currently done, but would like to automate the file! I have to filter every interval and it pastes data. I would like to avoid filtering every interval.
I have a very complex macro which takes a csv of all our orders and put it in a neat printable html format. It isnt doing one of the things its supposed to properly so I need that fixing and I also need to give it some extra functionality.
- Updating of pivot tables to ensure that numbers change when cells are updated - Advanced filtering - Having a data entry sheet and using VBA to transfer the new data to the bottom of the existing data set - Improve user experience by making future data entry convenient
...sheet also contains a named cell (again... local name... same on each sheet) with the title of the table. I want the macro to paste the tables into word with the table title separating them, captioned as a table in word. Ie the macro would do the same as if I: 1) insert a caption with the ‘table’ label 2) the append with the title copied from the value
...the usability of the tool, we will need the excel spreadsheet to host a number of specific VBA's to improve usability and functionality. I need a VBA programmer for approximately one week with proven VBA credentials to further assist in the development of the excel spreadsheet. It will be for Mac and PC, 23 bit and 64 bit, 2010 - 2016. VBA's with the
We are looking for Freelancers that can help us in building a solution where we can upload/downlaod information from an MS Access database to WooCommerce and back using the WooCommerce API. [login to view 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 imag...
Need VBA code to select a row in external SysListView32 and send right click to it using sendmessage or postmessage API. Assume hwnd of SysListView32 is known.
I need a dash board build in Excel. When I paste the data, it needs to process it onto a dashboard showing me sale details as I require. Also I ...board build in Excel. When I paste the data, it needs to process it onto a dashboard showing me sale details as I require. Also I need the data to extract details from master file to sub files on click.
Hi my name is Sotiris Kazabakas, I need an excel with some pop-up alerts and sound alerts. You will find more on the word ...Kazabakas, I need an excel with some pop-up alerts and sound alerts. You will find more on the word that i have uploaded which includes a description of what i need the excel file to do. For any questions do not hesitate to ask.
Hello, I have an Access database with an existing f...Access database with an existing form. I need someone to develop a script that exports the form as individual pdf files for each record in the database. The name of the pdf file will be derived from a field in one of the tables. I will upload an example Access database shortly. Thank you, Simon
some one to program my JiTBit Macro Recorder to 1. Wait for Image/message 2. Based on Image Macro to Respond e.g Yes/No 3. Only respond of corresponding perimeters are met e.g. (price level) 4. Wait for time to elapse before restarting the process. This is simply my repeating a task where I would have to be in front of my PC to monitor. Can be
I want to prepare a excel workbook in which, I w...Accordingly, in a second sheet an analysis will be prepared. The labour rate will be intered in first sheet as an input. Each and every time a new PDF need to be generated with given file name format and need to be saved. Similarly the loop need to be executed up to the last entry in the first sheet.
I wish to create a vba project under excel to modify the table Table contains an unspecified number of rows, which will change on every run Original table A B C D E -------------------------------------------------------------------------- 1 | 1 | 1234 | 43373 | 6030.769231 | DESCRIPTION
Macro to be written in the Personal File First File is output from MYOB. Second file is output from Ordermentum. Compare the two files using invoice number is primary criteria. - If there is a discrepancy in the final amount or tax amount, highlight the relevant row of the first file in red (This includes cases where the item is not existing in
I have two workbooks, each with multiple worksheets. I need the information from one worksheet (as it is inpu...workbooks, each with multiple worksheets. I need the information from one worksheet (as it is inputted) to populate to another based on a couple of variables. Best done in VBA. I will provide the working files to the successful candidate.
...an Excel Macro every X seconds within a specific workbook. Please don't bid if: You are not sure how to handle the constraints listed below, You don't explain the basics of how you intend to build the script in your offer. The script must ensure that the following constraints are met: -Excel must be usable between each launch of the macro. The sheet
...prices. Our business has grown from 20 odd products to over 180 products and the spreadsheet is now cumbersome, easy to “corrupt” and difficult to navigate. We seek a VBA expert to re-write our software to correct the above issues. ie standardised entry forms for stock, standard template for new product entry, time trial database & linking, labour cost