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
...functionality in office 365 below is almost similar functionality like we are looking for [log masuk untuk melihat URL] When someone click on list it will as below thing for main item. o New JD o Location o Status o Rate o And we can add as many column
I need two scripts which pulls the list of content types. I need a report with URL of lists and also content types. one script for on perm powershell one script for cloud office 365 cSom
Would like to set up a Sharepoint site along with Sharepoint lists and forms with workflows to gain financial controls over the organization. We are currently under-using Office 365 and would like to maximize to the fullest potential.
I need a new .exe tool which should allow me to import the excel data into an existing sharepoint list.
I have a project with Excel vba vlookup that needs modified. The tables are large and the vlookup is very slow. When I read documentation, the suggestion is to use a double vlookup, which I am not able to get the syntax right,. This is the line that is working, but slow: LookupResult = [log masuk untuk melihat URL](LookupValue, LookupRange
Vreau sa creez o funcție (VBA) care sa convertească un fișier txt în Excel la apasarea unui buton. (function)In acelasi timp sa se poata Introduce manual calea de unde se ia fisierul txt respectiv, unde va pune fisierul excel, anumite informatii adaugate manual. Am anexat mai jos cum arata fisierele text (2 tipuri de format) si de asemenea cum trebuie
I would like to hire an Excel Expert to correct a faulty Excel VBA Sub. I want to 1) Transpose a column to a row, 2) Multiply that row times a conforming matrix, and 3)Transpose the result to a column. Attached is an Excel spreadsheet with some data and some defined ranges. It contains a macro triggered by the only button on the spreadsheet. There are
The idea is creating a list of companies and the primary key is the registration number with the ability to amend the list or create a new list. and then to import excel files contain a large list of companies and in case one of the companies were inputted in the before it showed show as red flag. (More like a vlookup table) So, we will have two interfaces
Looking for a SharePoint expert to design forms and workflows in Nitro studio (alternative for Nintex) on SharePoint 2016 (expecting 40-60 hrs or more) with beautiful business intranet features - A class is looking for (20 hrs?) Budget is
we have an enterprise sharepoint farm which having more than 200,000 visitors per month. we are looking for advanced,experianced consultant/troubleshooter who can maintain it and fix its issues and ensure that its allign with the best practice. the project abd its maintainance/support period should cover all issues which may happen for 3 monthes/ renewable
Boa tarde, O meu nome é Gil. Estou á procura de alguém que faça um ficheiro excel para controlo de produtos. As funções que gostava que tivesse, são: Tabela de produtos, inserção de produtos na tabela, remoção de produtos na tabela e consulta de produtos através de filtro.
Develop sharepoint online on Office 365 for recruitment/business processes. Develop forms/lists/work flow/security/backup.
We have multiple internal talent management dashboards for our managers, as well looking to develop dashboards externally for our talent ac...develop dashboards externally for our talent acquisition clients. All dashboards are being created in Microsoft BI. We would also like to transfer the underlying data from sharepoint excel spreadsheets to MySQL.
Need to create an issue tracking/Program Tracking pages in share point 1. Input projects/Programs 2. Do periodic updates on them 3. able to view current status 4. Able to track historical data 5. Nice UI. this should be a share point site.
Wir telefonieren für einen internationalen Kunden und benutzen aktuell ein Telefontemplate in Microsoft SharePoint. Da wir umsteigen wollen auf SharePoint online 365 müssen wir dieses neu erstellen.
Here is everything you need to understand in the video: [log masuk untuk melihat URL] Please see attachment which contains all the files you'll need to get started Here is a link to access all the files: [log masuk untuk melihat URL] Let me know if you have questions, Thanks, Jai
Hi there, I have SharePoint online (cloud). Want to connect using VS2017 package, SSIS. I want to connect to my SharePoint list (svc - I have the URL and can see the download) with an Odata source. Want to then load all this data into an SQL table. Only apply if you have had extensive knowledge with this SSIS and have used to odata connection for a
Server side script to find list view threashold from the farm. Csom Script to find threshold from the site's list. The script should get site URL, list URL , List Title , ListView count.
Urgent - VBA Mac Not Windows - I need a VBA macro to run on MAC to search a folder and all its subfolders for a combination of files like excel and word files and copy all files found to a new folder. Your code MUST run on MAC.
I have a SharePoint 2016 single-server dev environment we're I'm continuously getting errors on the SharePoint Configuration Wizard and it fails. I've uploaded the error log. Just need help fixing and finishing installing.
I need a programmer. I had an excel file of renters for a residential & commercial building. I prepare this file monthly. It consists from columns with Flat numbers, it’s kind (residential or commercial), renter name and rent And the era paid for rent at its time it is in Hijri calendar from...to... You can get and update all information from last month
Thi...support assigned Sharepoint Tasks. Needs to be experienced in PowerApps, InfoPath, Microsoft Flows, Gathering Requirements, Fluent in English, and creating business process. Tasks will be assigned via Jira Software. Need to be able to print an InfoPath Form without headers, footers, global navigation, current navigation, and no web addresses.
I'm looking for someone who can create VBA Word 2016 templates for a law firm, based on our needs as they come about. We have current small access db, that some of our templates pull from, that can be used when needed.
I am looking for a Excel Online Developer who can help me load some excel tools (workbooks) that have data connected to a SQL server that refresh when opening. I am attaching one file as an example. Also, if you are a Sharepoint expert that would be great.
##Advanced VBA skills and high experience automating excel will be needed to understand the code written so far, debug and complete the work according to spec## A VBA programmer has done most of the work according to the attached Statement of Work, however due to personal issues he has not been available in weeks to complete the work. This has been
Excel Macro VBA - assistance with VLookup in VBA Hello The purpose of the macro is to process each row, and when there is a certain condition, correct the entry in the cell. I am using (attempting to use) VLookup to access the values in the 2nd sheet and correct the values in the first sheet of the workbook. Receiving the following error when running
build a macro which will copy data from one excel workbook to another. for each row in one excel file the macro should create two lines in the other excel workbook. in the column A of the new file CA should be written in the first line and SL in the second one. also in column E should be filled with text "y" as many as rows
I am looking for an Excel VBA programmer. I need to develop a Warehouse Management System in Excel with the help of VBA programming. The task is to setup a Master-Data file (Excel) that should function as a database. I need you to create an excel for every team where they are able to store data in Master-Data and retreive information from the Master-File