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 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
Have got a new server have installed ubuntu server edition and need to setup from the beginning, including setting up all settings etc, need to make SSH connecti...server have installed ubuntu server edition and need to setup from the beginning, including setting up all settings etc, need to make SSH connection to the server . Or FTP
I requi...the following; 1) Login to a FTP server and download (Get) a group of files from a server folder and store them in a temporary folder on a local computer 2) Login to a second FTP server and upload (Put) the same group of files to a server folder The above must be done using the SFTP (SSH) protocal and a .ppk/.pem file for authentication
I have 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
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.
...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, including Salesforce Ability
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...
...with FTP server and do the following: 1. Send Command button (to send a command to server) and display response ex RCMD CALL PGM(WOC006) PARM('123') RCMD CALL PGM(WOC005) PARM('123' 'c:[url removed, login to view]') 2. download file A button download file generated in the following format (with most recent date) [u...
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.
...need fine tuning. Just a simple work. Just to summarize 1. Autofilter and create new worksheets based on the filter value with keeping the same format of the original file. 2. Loop the process until the filter fields get over. 3. AutoFill Destination Range("A5: A6") to the end of the column. Note (To be done) 1- Filter Range will vary