Melakukan sejumlah pekerjaan Excel Mampu mengoperasikan Ms Excel Mampu mengoperasikan Ms Word Mampu mengoperasikan Adobe Photoshop ++Design Grafis,membuat logo pada Adobe Photoshop dan Corel Draw ++mengoperasikan Ms Excel dan menguasai VBA project dan formula pada excel.
Membuat aplikasi VBA- excell untuk tracking portofolio saham dengan ketentuan sbb: 1. Menggunakan Real time data (1-5 min) 2. Update data saham secara otomatis ke portofolio saham 3. Dapat melakukan penambahan dan pengurangan transaksi saham pada portfolio 4. Dapat melaklukan sorting berdasarkan Nama saham, keuntungan (jumlah atau %), berdasarkan
I would like to have someone who is proficient in excel and VBA to build a simple calendar scheduler and student enrollment forecast in my excel with the data set i have. On top of that, i need someone who is good with formulas such as index-match to assist as well.
Standalone VBA macro that will compare any two csv files based on a key column (in this case 3rd one) and create a new csv with differences (could be changes to existing rows or new rows). Needs ability to define the delimited (comma or semi-column) and ability to convert date fields into numbers
Does anyone know how to write a small VBA code to automate a process of pulling data from a website into a spreadsheet please .. Has to be through VBA so if you don't know how to write a VBA doe please don't apply for the job ..
I have an excel vba solution that produces a text file from a spreadsheet. This text file is currently imported into MYOB AccountRight Time Sheet module and the Payroll is then prepared in AccountRight. I need a VBA programmer that will take the text file and send it into MYOB AccountRight In The cloud. So no need to do the importing. ...
Hi Milan S. You did a few projects for me a while back and they were great. I have another, if you're interested. Here's the project description: I need an Excel VBA macro that, when a button called "Midnights" (placed on a sheet called " Operator Sheet") is pressed: * It deletes the contents of cells B3 through BT on a sheet called "Shift...
Hi there, I'm currently working on a VBA code which aims at extracting the data of a particular searched address(like area, zestimate, rental zestimate, tax & year of tax). I'd like you to develop code within the next 10-12 hours. The code if accepted may lead to various other project proposals by the client. Only serious bidders required
They need a button for their Word 365 application to show a button that will present the templates they have for their. The idea is to distribute the button to their employees and set up the templates. thank you
Hi, Need Product Import CSV in WordPress (WOOCOMMERCE integrated with one more element)
Hi, I am using an excel documents that has a few input sheet and based on various formulas, several output files are generated. These output sheets has a few charts. The initial coding is done, however I need someone to finish it. Should be a 15-30 min job if you are efficient in vba coding.
Hi there Excel and Word Power Users! I would like to have someone write me a macro that I can use in Excel. See the two files attached. Users will fill out the Excel Template. They will enter in the Value and Headers Columns. They can enter up to 26 row in a single File Number. There can be up to 10 File Numbers. On a button push from Excel, the ...
Hi, I am looking for a person who can create a simple macro for me in MS Word wherein I have the documents in Q&A format and I want to BOLD all the questions, and keep answers non-bold along with other test. Again, just the paragraphs with Q heading needs to be BOLD. It's a simple job for someone well versed with MS Word. Thanks!!
We need a VBA developer that can interface the Excel engine with our Access database so we can run reports for our clients. We would most likely need only a few hours of work every month. Someone with applied mathematical skills and knowledge of Bloomberg would be a plus.
...Imports" I want VBA Code to upload each of them. When they are uploaded, I want to add the Date the information was uploaded added to the second to last column and to add the UserID to the last column (in each of the three tables). The code shouldn't run all three uploads - I want code for each. I am assuming you don't need the excel sheets and you
Hello, I have a project that i would need ASAP I have a csv file and I'm trying to replicate some visualizations in D3.js I can send the R visuals in the chat Also, this should run locally on my machine
I am using Octoparse as a web scraper and the client does not allow batch exporting so I have to export the results of each task manually which is time consuming. I need someone to code the Octoparse API to export the data automatically. It's not a big job, but I have no coding experience so I can't do it on my own.
Hello, I have a lot of email addresses in excel. I need an excel VBA to send emails with a pdf attachment automatically. The text of every email is a template, but the VBA must chose the salutation correctly. Thanks for your help.
Wir betreiben ein Portal (noch in der Entwicklung) und wir suchen für eine Import-Funktion von Daten aus xls oder csv in die Datenbank unter Wordpress einen Programmierer. Es gibt einen Code, der jedoch eingeschränkt funktioniert und dieser muss verbessert oder neu geschrieben werden. Es sollen mehrere Zeilen mittels eines Imports in die Datenbank kopiert
I need to attach images from a folder from my PC (I want it to be prompted while running the macro regarding which folder to select) basis multiple Option Numbers (please refer file). The macro should look for images from the folder and insert it on the left side of the column (Specified for image) and the rows should auto adjust basis image height
...not need my Google-form. Create your own with a text-field for the e-mail and a button and make sure the script sends that e-mail to a fixed e-mail-address. 2. Excel-VBA: Again - I only want the code - I will install it and tweak it myself. The program should fetch the Google Forms data and put it in Excel. The data to be fetched is filtered by the e-mail
I have an e-commerce site with products and categories already in place. I have a new file from a new distributor that I need imported and categorized. Example I need all products that are organic to be put under the organic category and sub categories they belong to.
I need a VBA script written that can insert row data into MS Word and MS Powerpoint and then add an entry into MS Access. The script should prompt the user for the row's primary key (number) and then retrieve that data from the table and insert it into the word or powerpoint document at a specified bookmark location. Simultaneously, a new entry in another
I have over 4,000 PDF files that are all in the same format. I have to get certain data from each PDF and put into a row in a csv file. The data is on the 2nd page, and always in the same position within the PDFs. I am looking for someone who can do this within 72 hours. I can provide the sample PDF to interested freelancers. Please indicate
Develop a macro enabled excel file that has the following functionality: 1. Reset all sheets 2. Reset individual worksheets 3. Import a HTML file 3.1 Import 2 tables into a sheet 4. Export / save the file – name based on several Inputs
to create a utility using vba, functionality of the tool - open and parse a source file (PO file, attached), PO syntax can be found from [log masuk untuk melihat URL] - for each message to be translated, ie. the message after "msgid "/"msgid_plural", call a function convert(msg) -> just return msg in this function
I need a utility that can read a CSV file and allow a user to map fields to several fields available in Quickbooks online using the quickbooks online API. The fields need to include an employee identifier, Date, Payrollitem,Hours and more. API Reference [log masuk untuk melihat URL]
Hi, Im a student looking into simple VBA Excel project. Need help on generating Sudoku 16 by 16 grid. Requirements:- - random puzzle generator with 4 levels of difficulty - comes with a solver/solution - hints or guide to solve puzzle in Bright Colours and Bold Numbers - start and stop timer - VBA Excel format - fastest timer ranking (optional) Additional
We need someone who pulls us from a Magento database all categories. The information must be stored in a CSV file. It is important that each category is listed with all its parent categories. The following representation is required: child category id; child category name 1; parent category name 2; parent category name 3; parent category name 4 ;……;
Bonjour je veux créer une petite macro pour développer mon réseau linkedin
Please refer to the spreadsheet: I need to look at status, if the status is "Executed" then ignore and go to the next row. It then needs to find the latest date entered for that row, in row 2 this would be 16/11/17, it needs to then put into an array the contract number "2", then comments "Finalising contract" then the date 16/11/17 followed by the latest date header...