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)
...[url removed, login to view]) and identify the type of card and show the logo of that card. Then, it should encrypt the middle eight number, and save the card to the order info page 4444 XXXX XXXX 4444 (decrypt) Exp: 12/20 CVV: 101 On the admin, it should have the settings to: 1. Set the title for the payment page
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
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.
...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
Make automation robot to grab informations and put into SQL DB 1) Build SQL DB with all informations grab on 2 sites 2) Sites that will get the informations: [url removed, login to view] and [url removed, login to view] Prefered languages used: VB .NET See attach for more detais
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...
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...
...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 in arial font, • Header row to repeat on each table • Header row bold font