Create a VBA for Excel subroutine that will loop thru a single column of data column A, extract 4 pieces of data from the HTML Data and create new worksheet with that data in a column. One column for each set of data. See attached file for sample data in the input tab and what I would like in the output tab.
I'm looking to hire a part time (10 - 15 hours/week)resource, who will be able to write codes in Excel VBA and MySQL and will have in depth knowledge of developing a SQL database. There is no specific project. This person will be given the projects on the go and will be expected to meet deadlines and suggest improvement to the current company processes
To write excel macro set for simple scheduler. User will enter tasks into input sheet and click 'generate calendar' to generate output sheet. There shall be option to print to pdf. Detailed Brief is attached (turn on comments for more information)
I want to make a table like this but I do not know the right size to fill 1 plywood board with the size of 122cm x 224 cm, I want you to sketch for size 2 table, how long x width behind, how wide the middle and others. For the bones I chose like the letter L, break this table and measure every material that exists.
I want a VBA script which will do the following: 1. Open a csv file, 2. Read in the file contents containing the following columns: Date, Time, Latitude (in degrees decimal), Longitude (in degrees decimal, Heading (in degrees decimal), Course over Ground (in degrees decimal) and Speed over Ground (number) into a 2-D array 3 Calculate the differences
...some work, in an Excel spreadsheet. Looking for the 200 most asked questions (non basic questions) about Excel or VBA and fill the questions and make an answer in a document (excel, word, html). The answer should be original and come from the expert and not a copy or plagiarised from a web site. It should include screenshots of excel or copy of formulas
...got in this scenario, "our Emails are sent using phpmailer class. And an queue id is assigned to a log table entry for each sent email. We want a script written in python which search through the email log directory on Centos/Ububtu server and update the mail status based on queue id by php mailer class." , this person also must know php, and also must
I am looking for a guy who can develop the following VBA macro: In an excel file column D, I have some URLs. For those URLs, I need to get the host name of the URLs printed without subdomain, http// and www in column E. This step needs to be repited for all lines in the xls file.
...Qualifications: Hands-on experience administering [url removed, login to view] Expertise in working with large sets of data in systems and spreadsheets Strong MS Excel, Access, SQL skills Moderate to advanced VBA for Excel Ability to work with data import toolsets (training available on specifics) Experience with Customer Relationship Management software, inc...
I want to build an Excel VBA in in which I can print Template Form from Data Table and Also attach PDF wit it.
I had a freelancer draft a addin/pluginn done for me. Its working in many areas but there are errors in some functions which needs to be fixed. Additionally i want to do some upgrades in the features as well. The freelancer i used to work is not reachable for the last 2 days (otherwise if i had the same freelancer its a matter of minutes to fix the error) and i have a deadline so i need someone wh...
VB Excel script Hello, 1. due to loads of spam generic bids, please write "i will explain in short how i my macro will work" 2. and also then explain me how the macro will work to make sure i get what i need 3. JOb description: In general, this is a macro taht is similar to the existing "extended filter" method in excel. but as a script
I need a small project to compare between tables in 1 Excel report sheet and copy only the matched name rows into a new sheet, in the same order with the same headers. I need it in 1 day. Please don't put higher price.