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
...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
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, including
I want to build an Excel VBA in in which I can print Template Form from Data Table and Also attach PDF wit it.
...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 whom can takeover and make the project continuing. The payment will be in minor portions ($5 in each step) but i will pay for each small work i want it done and the total will be worth doing it. So basically
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.
I am automa...wanted, I have decided to I have code it myself in VBA. I know enough VBA to write the program, but I need help with implementation and syntax. So all I need are one or more VBA experts whom I can give my code to and have them correct it. I will outsource small jobs to anyone who is very competent in VBA and English. Fixed price only.
have created a macro and 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. (Range(&quo...
...It is related to exporting the comments, insertions and deletions in the document into word and excel. I have attached the following: 1) Current output I get from the document. 2) Existing Code Files (you can import them into Modules in MS Word VBA) Key Requirements are (changes required to the existing code): Document should be prepared