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
...been challenged to produce new tools, processes, train and manage a small team. With all these new responsibilities, I am unable to keep up with the ever increasing workload and in my growing despair, I’m finally waving the white flag and seeking the help of someone who can help me with the Excel tools I’m trying so desperately to create. I am looking
...workbook collects data and on collection when running it makes selection as in the races sheet. I no longer want to collect data from certain sources so needs all the links removing so as not to get debug error and remaining data collected will give me the figures I need without errors the data changes daily Please look at races sheet D42 t...
I have a number of PDFs - with about 100 000 people's first names, last names and email addresses on them. I need to have them extracted on to an excel sheet.
...logon, no captcha are necessary, but a research by name (each request has only 300 results on several pages), research should be 'begin by aa', then by 'ab', 'ac',etc...'zz' to have all contacts (30K). please provide source code (and project, visual prefered) and documentation if necessary c# is prefered than python (if documentation if enough, ok ...
Epic As a project manager I wish to have a macro enabled RACI chart where I can document the tasks, roles, and responsibilities on a “RACI” worksheet. On a “Role” worksheet, a list of names, roles, email addresses along with other personnel information is entered. On an “Email” worksheet, the results of the macro would be displayed in four (4) categories;
Example of excel workbook attached. for each workbook sheet: Extraction algorithm: loop on all 1st column cells - subsequent empty cells or cells starting with "#" are managed as range of cell separator - when a cell is not empty: . the first line is managed as title row . subsequent rows as data rows . until reaching the next empty/"#" cell (end
...S., I have another Excel VBA project for you, if you're interested. There is an Excel worksheet that resides on a server at work. It is shared by many people, we only want one person at a time to be in it, and some people stay logged into it for hours even if they aren't at their desk. That keeps the rest of us from being able to do our work....
Python script required to OCR and Extract details from Bank Forms. OCR done through tesseract library does not read the characters / words from bank forms which has boxes to fill characters (sample forms attached). For OCR, tesseract is still to be used but algorithm is required to meanigfully extract information like Name, Date of Birth, Add...
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. please see http://developer
Hi - I want someone to build me extension or tool to parse web page. I need 5-6 piece of information to be collected and all the pages have same format/ pattern. Once again to let you know I prefer chrome extension over anything else.
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 Lead S...
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
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.
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...
...would like to produce a list of contacts from a pharmacy chain, which makes each store's contact information public on their website. Here is the link to the pharmacy's store locator: [log masuk untuk melihat URL] The way to find stores on their store locator is by postal code. If I were to do it myself, I would have to spend hours
...email regarding the surveys needed to create, we are supposed to read the email understand the information and create a survey on the fly. example email they send are women between 18 and 45 living in Texas men who are earning 40k to 80k annually men who live 5km from zipcode 50081 it is a free and unstructured text from the above information we should
I am building a website in MVC Vs2017 but need some help with the Oauth 2.0 to connnect to "Clover Pos" Oauth2.0
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.
Fix Remnant Description in a way that extracts the size info properly The goal is when we get a perfect size extraction the remnant should be perfect
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
...If someone fill in this form we want an e-mail sent to us with the e-mail-address they entered in one of the google-fields. You do 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
...and I want to find their address, phone number, website address. It could be done by some script/ tool to do automation on google. If you simply put company name google shows it's address phone number and website on right hand side with some other info. I need those to be pulled in CSV / excel format. I don't need script and I want you t...
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
...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 in your bid how
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
Angular 6 http service/s component 3 content boxes. 3 dropdowns Select of each dropdown populates content box with content returned from api/json payload. Pass in WordPress page url from dropdown list, populated from a local json file. Dropdowns contain: 12 page content urls (will render markup inside a div) 1 seo tag url (will render tag in the head
...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 help from programmer...