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 functionality to this macro or create ...
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.
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,.
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
...- DONE 5. Data could be in merged cell, so paste all the rows wherever merge occured.- TO BE DONE 6. Search may be for a keyword or a small sentence of 2-3 words. - DONE 7. Code should be password protected. - DONE 8. The data sheets will keep on adding in future. There should be no limitation to it.- DONE 9. If data is not available in Column A but
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.
Hello 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
Very simple requirements: 1) create excel vba code that will open a text file (e.g. [đăng nhập để xem 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 [đăng nhập để xem URL] - SHOWS YOU THE INPUT FILE (sample) afte...
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
Olá, Trabalho com varejo e atacado, venda de roupa feminina. Estou precisando de uma planilha em excel VBA, para otimizar meus processos de vendas e demonstrativos. Vi na internet muitas planilhas muito semelhantes a que eu preciso, precisando somente de algumas pequenas alterações, mas infelizmente quem as vende não faz alterações. a seguir as i...
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