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
Sheet 1 : declaring the values like %EMP_ID1% - 100 , %EMP_ID2% - 101 , Sheet 2...the values like %EMP_ID1% - 100 , %EMP_ID2% - 101 , Sheet 2: Lot of datas Work: VBA Macro should search %EMP_ID1% in sheet 2 and replace with 100 Note: If we change %EMP_ID1% to 700 from 100 in sheet 1 it should automatically change in all sheet when we run VBA.
Need someone who has good expertise with fetching data through rest apis and charts. All work need to be done in 3 days at max.
The freelancer will receive an Excel list with prices to 31 stocks over a period of 3 years. You are asked to create an application, that performs analysis, using Excel and VBA. The number of analysis methods used should be dynamically selectable. The uploaded image shows an example for the GUI. The application should include the methods of technical
when a (certain) email is received, combine the attached pdfs (two or more) into a single pdf, save and name the new pdf based on the original email and save & sen...a single pdf, save and name the new pdf based on the original email and save & send the new pdf as an email attachment. Email program is Outlook, looking for rule based and vba solution.
i have a multiple vendors files in excel with huge date. i want to club all sheets into my own data sheet and and select my requirement in dashboard and report would generate as per my selection . Example ; Product 1 is there in three different vendor list and it should generate report with Product1 details of all vendor and highlight the lower
I need an excel spreadsheet that will track certain things in my business. I have 4 business locations I have many people that sell items at each location I need to track how many items were sold, by location, category, and salesperson I need a sheet that shows each breakdown with a chart I need a sheet per salesperson to input their sales per location
Got a VBA macro that's pulling duplicates into excel. There are no duplicates on the original website. Some problem is causing it to repeat some data. Need you to fix this behavior so that the macro only gets the data as is.
...integrate all the things I have found personally which is plenty and I have to be able to own the programme and change and add things all the time. Right now I am doing all this on Excel sheets and I have found stocks with amazing data, patterns and relationships in the past. I know it can be done much better via a smart programme with good graphic presentation
I am looking for someone smart, who can write Excel vba code, starting immediately. Details will be shared with selected candidates.
I have some work, in an Excel spreadsheet. Looking for VBA into spreadsheet. Want to capture data (back and lay prices)from Bet Angel (Betfair) at chosen optional specific time intervals eg maybe every 5 minutes or 1minute. Therefore eg 1.00pm capture back prices of all horses and put in cells A1-A10 1.05pm now capture back prices of all horses