This assigment contains technical analysis on Excel via VBA and GUI. Along with the exercise that you can see attached, I will send you data corresponding to it. The workload for this assignment is approximately 3 hours. It is essential to be proficient in Excel and VBA, and building GUIs.
...wanted someone to who is an expert in MSexcel, macros/ VBA who is ready to come to the office(Koramangala, Bangalore, India) occasionally and work with the project managers. Snapshot of the requirement: • Coding development in VBA (Excel) ((Procedures, Functions & Classes) and advanced Excel functions. • Should have good knowledge of SQL(Procedures
hi there, I'm looking for VBA expert to design a spreadsheet where it can find all combination of a targeted sum. The VBA code should be able to calculate over 8 millions combinations and repetition not allowed, plus showing the quartile for each possible combinations. Other computer language is also computed. Example: Targeted Sum is 52 weeks combinations:
Hello. I am looking for someone who is knowledgeable with excel and vba script to scrap some data from webpage to excel and filter it based by product and email.
Working for a start up - need someone who can help automate the task of pulling data out of our microsoft access database and into an excel doc. We actually have this process working but to reduce the pain of copying and pasting data in and our of the database we want someone to make it happen automatically.
Hi, I would need an Excel VBA macro. It needs to be quick (running for less than 1 min), and the spreadsheet can have many rows (100k+) As you can see the attached excel file has header in row 2 and some extra headers in random rows, First thing the macro should is getting rid of any extra header rows, i.e delete them (delete in a way that no blank
Hi, Im looking for a an MS Access vba code to read an xml file and show th enumber of records, (ususally only about 5 reocrds in the file) and display the CDATA element and store the records in a MS Access table, may include some comments.
Existing PowerPoint plugin requires some refactoring, porting, bug corrections for latest Win10 Office 2016 or 360 versions....installer creation, small tool-bar menu button and wizard sequence. This is not new a new project development, it is for adjustment and porting an existing plugin. VSTO and VBA skills for PowerPoint are critical. NDA required.
...fairly quick. I have an Excel spreadsheet with a column where each cell contains a few comma-delimited words/phrases. Some are in English, some are in Russian (Cyrillic character set). I need these split into two columns: one for the English, one for the Russian; both comma-delimited. The purpose of the project will be to provide a VBA macro that will do
Hi, I would need a quick VBA macro, The task is relatively straightforward: As per attached, there is an excel file with data only in two columns, A and B. For column A you have data for all of the rows, For column B you only have data for some of the rows, The macro should loop through the spreadsheet and copy the content of column A to column
creating a new options to select by department or cost center or both
Kolkata based EXPERT VBA teacher who can help someone learning VBA on freelance basis.
Hi H John D., I am not as VBA-competent as I would wish, and I want you to engage you to help me understand what VBA coding might be possible to move entries in various Excel worksheets' fields to a single database and allowing for updates of data in subsequent entries into those worksheet fields (essentially allowing for an audit trail, which would
Hello my name is Bob and I would like to build a VBA application in order to perform technical analysis for a given set of stock prices. The model should allow for as much flexibility as possible meaning that the user can choose different stocks and perform different analysis methods for those stocks (which I will specify further in the later stage)
Build a script (python) that downloads S&P500 and Russels 3000 companies international revenue an convert it to excel. VBA is fine too, just an automated script that can show me the international exposure of S&P500 and russels 3000 companies
Various excel models are developed, now the same are to be consolidated into Excel-VBA models.