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 need an excel vba expert to write a two phase code for me, with the first phase being to import data from two different workbooks based on a userform where a certain value is entered, and the second phase to import data from another workbook based on certain letters that are entered for the value talked about in the first phase
I am having a hard time creating a macro to ‘call’ a SharePoint. I am needing a VBA Excel macro code to ‘call’ a SharePoint so I can chose a file within the SP and have it automatically populate to a tab within the Excel spreadsheet.
Hi, I receive constantly a data sheet that is always in the same format. The problem is that it is not a proper table and I need to amend it man...receive constantly a data sheet that is always in the same format. The problem is that it is not a proper table and I need to amend it manually. I would like to have a little VBA code that does it for me.
We are creating an application using socket to print out a label on various locations. And we got stuck on making it dynamic by choice in a action form. There are 5 types of Animals, that only should produce 1 label. (6 animals total) The 6th Animal needs to send out 4 labels, so basically x4 the print template with increasing number from 1-4 on the
I have a project to design an A4 bookl...work to show off. Design inspiration needs to look like the attached. Not exact but something like that. Minimal, clean and modern look and feel. The document is like a workbook where you fill in each section. More detail once you get the job. I don't have a hard deadline so I'm looking for good work here.
...consistency of design and layout you must: • Ensure Columns are wide enough to display data properly and are evenly spaced. • Include a header containing the file name of the workbook. • Today’s date and a Branch name area must appear on the worksheet. (The branch name will be filled in when the template is used.) • Format the spreadsheet so it is clear
Find out why [login to view URL] is loading slowly. It was loading in under 10 seconds yesterday but is taking more than 40 seconds to load. You need to find the issue which is impacting the speeds and then code those changes/make those changes if required in our servers. Change. We were on T2-Large AWS till yesterday and have moved to T2-2XLarge from today. Database guy says SQL processes a...
...consolidated Group Daily Sales Summary Excel report from separate (and slightly differently formatted) Excel spreadsheets from each of 10 different brands. The Group Daily Sales Summary report Excel template (1 page) has already been designed and already uses the data from each of 10 separate Sheets in the same Workbook onto the consolidated Daily Sales
I would like to add data into Google Sheet from Solidworks. I'm using SolidWorks to make techn...data to Google Sheet and store files in Google Drive. I would like to have work done in two steps: 1. Populate new row in Google Sheet with data sent from Solidworks Macro (VBA, C#) 2. Save files to Google Drive and make link to the files in Google Sheet
The site is: https://pubchem.ncbi.nlm.nih.gov/compound/Triasulfuron#section=Top Input will be a list of chemicals. You need to search for that chemical and extract the data in the attached format. Note that the download tab contains a list of files that need to be downloaded for each chemical. Out of this only the patents file needs to be downloaded for each compound. Please bid only after you ...