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 ...registry settings, Office version detection, 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.
Hopeful...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 this. I will supply the full spreadsheet to interested bidders. Please let me know if you have any questions. Thanks for bidding!
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.
...done, first person to finish gets the money. Code currently is written so it will copy and automatically add data from table1 to table 2 in another sheet. I have added extra columns (columns V through AD) to table1 which need to be copied across to table2, the vba code simply needs to be adjusted to do the same copying mechanism already in place
I have an Excel spreadsheet in which there is data related to shipment dates and customer name..... I want to create a report :- I will give FROM DATE and TO DATE List should be populated below... Alll should be presented well.... It is 10 minutes work for EXPERT MY budget is 10$ only.
I need help editing my code to create a combo box that will load in a list of pre-defined set of ID's from a sheet and allow a user to select any one of those ID's. Based on which ID the user selects, they can enter a number and have that number save next to the correct ID to keep track of information. The gui is called "FeedPredictor"