Excel vba expert needed write jobs
Please read before proposing. REQUIRES MAC FORMATTED VBA!! You will write a Macro for Office that will work on an Apple Mac. It must work on Apple computers with Office for Mac Version 16.16.1 We have an Excel workbook with multiple worksheets. Each worksheet contains several formatted sections. The Macro needs to do the following: 1) Select the
to make an excel work sheet easier
I need VBA code to be able to scrape on demand data from the website [login to view URL] The code needs to be able to scrape NCAA College Football and NFL games week after week. I will need the output to be produced cleanly into an Excel spreadsheet so that I can link/extract data, run formulas, etc. from another worksheet.
A complex VBA based project (similar to FIFO but has lots of complexities). This project needs be started right now and have a tight deadline. If interested please let me know, we can discuss the project in detail.
i have 2 column of dow jones daily price ( high and low ), i need to mark the high and low ( peak and trough ) by giving different cell background color....
The purpose of this project is to demonstrate your knowledge of management science techniques, your understanding of VBA coding, and ability to develop a DSS system.
We have a few medium to complex excel macro (depending on your level of Excel Expertise) that needs to be created or modified based on our existing macro. Background: We have two worksheets in a given workbook file. We need to have various "column transpose" and lookups from sheet2 to sheet1. This is an ongoing progject meaning, if we need to add
A complex VBA based project (similar to FIFO but has lots of complexities). This project needs be started right now and have a tight deadline. If interested please let me know, we can discuss the project in detail.
I have a program that opens / closes 100s of files searching for key information. The pro... The problem is that they are 'gz' files zipped so i have to manually transfer all the files in my R: (zipped files) to my C: (unzipped), i would like someone to look at my VBA to see if there is a way to incorporate in a unzip function as it is opening a file.
Need a VBA expert for create form and report
A complex VBA based project (similar to FIFO but has lots of complexities). This project needs be started right now and have a tight deadline. If interested please let me know, we can discuss the project in detail. Thanks !
Hi all Effectively, I am looking for a piece of VBA and/or python code attached to a spreadsheet that will automatically extract data from websites (3-5) so that when copied into excel they are in a consistent and comparable format. Advance excel VBA skills are required. Further information (format, websites) will be provided after,.
...through the powerpoint when using section navigation through slides. Need sample code for powerpoint which hooks into navigation from slide to slide to be able to add logging vba code: - handling of slide names tages for logging - hooking into enter slide, leave slide, ... steps Details best clarified via chat. Will add additional information based on
I need an Excel VBA Tool that can extract airfare and other flight information from Google Flights. The tool should run using an interface (mask) that lets me choose the following: - Departure Airport (code) - Destination Airports (codes separated by a comma) - Departure Date - Return Date - Class of flight (multiple selection must be available for
Following points in this macro are running well except points no. 5. & 9. Very small project. 1. Search tool to be placed in a folder along with multiple data excel workbooks. - DONE. 2. Tool should look for a keyword in all the existing workbooks in the folder only and copy paste the entire row in the search tool. - DONE 3. It should paste the workbook
...through the powerpoint when using section navigation through slides. Need sample code for powerpoint which hooks into navigation from slide to slide to be able to add logging vba code: - handling of slide names tages for logging - hooking into enter slide, leave slide, ... steps Details best clarified via chat. Will add additional information based on
I get data from an api. 99% of data is appearing only 1% is missing. the code had been working perfectly since a year. This error happened today. May be i deleted something? please check whats the issue and fix it. "Team Viewer" is important, I won't send the code file.
...Freelancers! We have an excel workbook which contains three sheets connect to each other using VBA. There are lists and buttons in the sheet which do have some associate functionality and ultimately reflects the changes in data tables. We would like to implement the same using trello power-ups API so that our users don't need to access the excel file. While bidding
Very simple requirements: 1) create excel vba code that will open a text file (e.g. [login to view URL]) 2) code will then do the following: 3) look for person's name in the line (e.g. Dr. FirstName Last Name) 4) remove the firstname and leave only Dr. LastName) 5) save text file without any further edits [login to view URL] - SHOWS YOU THE INPUT FILE (sample) after_edits
Hello, looking for someone who can do form in access almost done with that just need to add some more work in it.
Can anyone write a script to automate data update/upload to ms project from ms excel. I have standard forms and need to update the project data through outlook inbox or by any other means.
I’ll try to explain this the best I can. I want to setup 3 loops to pull data for college basketball games. I'm experienced in VBA but I'm having trouble creating a loop that does not error out after 15 games or so. There is some kind of security on the ncaa's site that prevents this type of data scraping I'm told. The workaround which has been mostly
I need an excel vba expert to write a two phase code for me, with the first phase being to import data from two different workbooks based on a userform where a certain value is entered, and the second phase to import data from another workbook based on certain letters that are entered for the value talked about in the first phase
I am having a hard time creating a macro to ‘call’ a SharePoint. I am needing a VBA Excel macro code to ‘call’ a SharePoint so I can chose a file within the SP and have it automatically populate to a tab within the Excel spreadsheet.
I need someone who is confident in writing efficient code and is willing to work for 2-3 days. Potential for constant work.
Hi, I receive constantly a data sheet that is always in the same format. The problem is that it is not a proper table and I need to amend it man...receive constantly a data sheet that is always in the same format. The problem is that it is not a proper table and I need to amend it manually. I would like to have a little VBA code that does it for me.
Requirement to create an excel configurator
i have some work within vba macro expert with script .if you think you can do it ,bid it The rest of the words will be called Inbox, and the project details .my budget is low thank you
Hi, I am looking for a person who know how to make automatically ppt to vba
I need some VBA code written to grab the FILL COLOR of a specific cell and then add all of the values that meet that FILL COLOR.
The site is: https://pubchem.ncbi.nlm.nih.gov/compound/Triasulfuron#section=Top Input will be a list of chemicals. You need to search for that chemical and extract the data in the attached format. Note that the download tab contains a list of files that need to be downloaded for each chemical. Out of this only the patents file needs to be downloaded for each compound. Please bid only after you ...
i have some work within vba macro expert with script .if you think you can do it ,bid it The rest of the words will be called Inbox, and the project details . thank you
I need to loop through each row and for any cells that meet the "if" condition, then the cell value 6 columns to the left is displayed....to the left is displayed. I already have the entire code written that can email me the cell values, just needs small modification. Should only take 5 minutes for experienced VBA programmer. Need this done in 1 hour.
download the data from sap and automate the report and share to all recipient.
I have a input excel file which i need to split into multiple excel files that i need. See attachment and video for more detail
We are searching for a experienced developer who has knowledge in both MS Access VBA and one other language such as Python/Rails/PHP. The goal of this process is to achieve the same functionality as before. Please don´t write a long list of accomplishments in your application but rather give me a short explanation how you would handle that problemset
The site is: https://pubchem.ncbi.nlm.nih.gov/compound/Triasulfuron#section=Top Input will be a list of chemicals. You need to search for that chemical and extract the data in the attached format. Note that the download tab contains a list of files that need to be downloaded for each chemical Please bid only after you have gone through the attachment
...workaround so please read carefully...I am budgeting for one day's worth of effort. We will need screenshare. I will need for you to give me the VBA script based upon the review of the website. I will enter into excel and get the [login to view URL] I'm on VPN this is the only way. I have to accomplish as if I was running my own scipt. Because this is a VPN, I do
Hello, I would like to build a tool in excel that will allow me to color code different point series on a graph depending on a category I select.
I have 4 excel macros running on windows 7 that need to be rebuilt so they will run correctly on windows 10 system. Issues to be resolved: 1) auto run the Excel tasks every 3 hrs (using Windows Task Scheduler - or other app(?) if Task Scheduler is not stable) 2) avoid memory leaks 3) ensure that data imported from source CSV's is fully loaded before
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates. State your approach to this task and I will hire you.
Hi, I would like to sort some files according to age, size, length and weight, etc. The drop down functions should indicated ranges which i will provide. Also after completion, i should know how to add and delete those ranges. It should be a fairly simple project.
...following files: - Current stock (CSV) -Sales of the last 14 days (CSV) -Article Database (EXCEL) The first two CSV files I read about the query function in Excel. I then made a little "program", if you want to call it that, tinkered. I also worked a bit with VBA. However, the tool is very limited. The queried files must always have the same file path
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates.
Seeking skilled Excel/VBA developers to create complex tax workpapers. Financial modeling expertise a plus. These are very sophisticated models with dozens of tabs and thousands of rows per tab
We will provide a set of input files in a folder. Each of the input files need to be read from the folder and based on logic, needs to be converted into another format (excel sheets)
... - We want the project owners to input their update into SharePoint and pull that into this workbook, mapping to the data elements in the dashboard - We want to leverage a VBA button to produce a PowerPoint slide of the dashboard to automate our deck production. We hope you will accept our offer and look forward to hearing from you soon. Please let
Non-profit business needs spreadsheet to track weekly contributions that will link to Annual total page for each parishioner. Also, spreadsheet needs Master worksheet that allows the addition of names that will automatically update each subsequent worksheets.
