Vba emailnotify projectPekerjaan

Transformasikan template google sheets saya dari VLOOKUP menjadi Apps Script/VBA

Projek ini sudah dikerjakan namun memiliki beberapa kekurangan terkait dengan aplikasinya. aplikasi ini digunakan untuk menyusun layout produk. ada banyak variabel dan kompleks di file berikut. kosongdelapan1229223642

Pekerjaan akan kami selesaikan secara bertahap selama sepekan. Dan tiap hari akan kami laporkan progressnya. 2 pekerjaan yang akan dikerjakan. 1. Dikembanbkan dengan sxript VBA Excel 2. Dikembangkan dengan script PHP & Mysql

Pembuatan aplikasi kasir dengan VBA

Hi All, Let me give you short rundown of the project. We have an existing excel VBA Program for room hotel booking. The program is very simple, as it only managed 4 rooms (in this case cabins). And it does the scheduling and booking quite well. We want to upgrade the existing excel file to be able to perform the following tasks: 1. Create authority level on who can edit and who can view the file, makes it more secure and less prone to input error. 2. Allow for easier multiple cabins booking, as of right now if the customer wants to book all four cabins, we need to individually input the booking. 3. Create a simple POS System for the cabins restaurant, this consist of simple food and beverages. Make it easy for us to add or discard items in the menu as it frequently change...

Saya membutuhkan aplikasi android/VBA untuk menginput pengeluaran harian perusahaan (petty cash) yang nantinya akan diexport ke excel untuk pengolahan data lebih lanjut. Sistemnya seperti aplikasi moneypro. Tinggal klik saja biaya yang cocok untuk nantinya diinput nominal biayanya.

Kami biasa mendapat laporan harian dari banyak peer kami. Kami perlu megkoleksinya lalu merekapnya di sheet terpisah dengan tampilan output tertentu dengan satu tombol klik sudah bisa merekap banyak file dalam 1 sheet xls.

Gambaran program : 1. Barangnya adalah ikan 2. Data Ikan : Nama Ikan dan Size (jadi, 1 jenis ikan bisa mempunyai bbrp size) 3. Alur prosesnya : a. Ikan segar ditimbang (output : KG).. kmdn dibekukan. b. Ikan beku dikemas dlm karung/koli (output : KG dalam 1 koli & Jumlah Koli) .. kmdn masuk gudang. (Note : tulisan ".. Kg" ditulis di karung). c. Ikan kemasan karung dijual/keluar gudang (output : KG dalam 1 koli & Jumlah Koli) 4. Data yg diinput & OUTPUT yg bisa diprint : - Nilai KG (saat proses timbang, saat dikemas dalam karung dan saat keluar gudang ) - Jumlah KOLI (saat dikemas dan saat keluar gudang) Demikian gambarannya, cukup sederhana.. Contoh data dan penjelasannya saya sertakan dalam attachment file Excel. Terima kasih.

English I work in the Ministry of Public Works PUPR as an analyst for Roads and Bridges. I want to do data scrapping on the website monitoring (website requires login, I will give the login data later to the bidd...to do data scrapping on the website monitoring (website requires login, I will give the login data later to the bidding winner) so that the data will be entered and updated automatically into my Excel document using the VBA Excel code Indonesia: Saya bekerja di Pemerintahan Kementerian PUPR sebagai analis Jalan dan Jembatan. Saya ingin melakukan scrapping data pada website emonitoring (website membutuhkan login, data login akan saya berikan nanti pada pemenang bidding) sehingga data tersebut akan masuk dan terupdate otomatis ke dalam document excel saya menggunakan kode...

Bantu saya menyempurnakan aplikasi saya dengan membuatkan - username otomatis pada form penjualan dan pembelian - menyempurnakan hak akses - membuatkan list meja yg aktif

hallo pak saya yg dari facebook itu mau dibuatkan aplikasi asuransi data polis Excel VBA

Mengaktifkan scroll mouse (bukan scroll bar) pada userform, scroll harus kompatibel dengan win 64.

Proyek ini bertujuan untuk simplifikasi waktu pembuatan laporan dari data excel ke data word dengan menggunakan VBA Makro

expert dalam menggunakan hyperlink exel (googlesheet) mengerti pembukuan untuk proyek mengerti pembukuan kantor (jurnal umum,buku kas, neraca saldo,laba rugi,neraca casflow) bisa di kerjakan dalam 1 minggu dengan templet yang sudah ada )saya akan memberikan templet untuk pemb...neraca saldo,laba rugi,neraca casflow) bisa di kerjakan dalam 1 minggu dengan templet yang sudah ada )saya akan memberikan templet untuk pembukuan kantor serta templet untuk pembukuan proyek) untuk pembukuan kantor hanya jurnal umum dan kas proyek yang ter isikan, yang lain harus otomasis ngelink untuk lapangan pada umumnya sudah jadi tinggal di link ke pembukuan utama kantor tidak menggunakan VBA, karena di googlesheet tidak bisa contoh file ada di bawah, tp untuk real nanti saya kasih yang link ke google...

Jadi proyek ini tujuannya adalah untuk mepersingkat waktu input data excel dgn VBA Makro dan kalo bisa data tersebut langsung terhubung ke word, untuk contoh hasil atau hasil ketik manualnya adalah sebagai berikut

Saya punya data X dan data telepon yang dimasukkan ke excel. Data X ini perlu untuk bisa dikirimkan secara otomatis ke WA cukup dengan menekan tombol saja di worksheet Excel

hallo pak. Jika bapak lagi butuh bantuan untuk menyelesaikan project tentang excell. mungkin bapak berkenan hire saya. saya bekerja di salah satu perusahaan, dan saya pernah buat training formula excell dan pernah membuat payroll calculation dengan vba excel. terima kasih

I need VBA macro button to combine hundreds of workbooks contain several sheets into one sheet only. You can see the sample of raw workbooks (kd10s file) to extract into one sheet in tblairjoman.xls. You can download to see what kind of data that i need. If you can, please attach of the result your vba macro button that fits my demand then i'll give you award and complete the job and payment. NOTE : sheet 1 is for data compilation, sheet 2 contains vba macro button with link folder workbooks to extract. If you dont understand, please dont bid.

Salam kenal. Saya Sandro. Saya tertarik utk membuat "quick report" pengukuran vibrasi yg berbasis VBA macro excel. Jadi saya punya tool pengukuran vibrasi yaitu fluke 805. Tool ini dilengkapi dg template yg berbasis vba macro excel utk menampilkan nilai2 pengukuran vibrasi dan grafik trendingnya saat tool ini dikoneksikan dg komputer. Saya punya ide modifikasi pada tool ini utk membantu mempercepat penyajian laporan. Modifikasinya adalah 1. menampilkan nilai2 dan grafik tadi pada "form data hasil pengukuran vibrasi" yg formatnya sdh ada di perusahaan saya. 2. Sistem ini jg nantinya diharapkan dilengkapi dengan formula utk memberikan "rekomendasi dan analisa" secara otomatis dr nilai2 pengukuran yg ada. Berikut saya lampirkan form, template ...

Salam kenal. Saya Sandro. Saya tertarik utk membuat "quick report" pengukuran vibrasi yg berbasis VBA macro excel. Jadi saya punya tool pengukuran vibrasi yaitu fluke 805. Tool ini dilengkapi dg template yg berbasis vba macro excel utk menampilkan nilai2 pengukuran vibrasi dan grafik trendingnya saat tool ini dikoneksikan dg komputer. Saya punya ide modifikasi pada tool ini utk membantu mempercepat penyajian laporan. Modifikasinya adalah 1. menampilkan nilai2 dan grafik tadi pada "form data hasil pengukuran vibrasi" yg formatnya sdh ada di perusahaan saya. 2. Sistem ini jg nantinya diharapkan dilengkapi dengan formula utk memberikan "rekomendasi dan analisa" secara otomatis dr nilai2 pengukuran yg ada. Berikut saya lampirkan form, template ...

Salam kenal. Saya Sandro. Saya tertarik utk membuat "quick report" pengukuran vibrasi yg berbasis VBA macro excel. Jadi saya punya tool pengukuran vibrasi yaitu fluke 805. Tool ini dilengkapi dg template yg berbasis vba macro excel utk menampilkan nilai2 pengukuran vibrasi dan grafik trendingnya saat tool ini dikoneksikan dg komputer. Saya punya ide modifikasi pada tool ini utk membantu mempercepat penyajian laporan. Modifikasinya adalah 1. menampilkan nilai2 dan grafik tadi pada "form laporan rekomendasi dan analisa vibrasi" yg formatnya sdh ada di perusahaan saya. 2. Sistem ini jg nantinya diharapkan dilengkapi dengan formula utk memberikan "rekomendasi dan analisa" secara otomatis dr nilai2 pengukuran yg ada. apakah Anda bisa membantu say...

Salam kenal. Saya Sandro. Saya tertarik utk membuat "quick report" pengukuran vibrasi yg berbasis VBA macro excel. Jadi saya punya tool pengukuran vibrasi yaitu fluke 805. Tool ini dilengkapi dg template yg berbasis vba macro excel utk menampilkan nilai2 pengukuran vibrasi dan grafik trendingnya saat tool ini dikoneksikan dg komputer. Saya punya ide modifikasi pada tool ini utk membantu mempercepat penyajian laporan. Modifikasinya adalah 1. menampilkan nilai2 dan grafik tadi pada "form laporan rekomendasi dan analisa vibrasi" yg formatnya sdh ada di perusahaan saya. 2. Sistem ini jg nantinya diharapkan dilengkapi dengan formula utk memberikan "rekomendasi dan analisa" secara otomatis dr nilai2 pengukuran yg ada.

I have some work, in an Excel spreadsheet. Halo freelancer. Salam kenal. Saya Sandro. Saya tertarik utk membuat "quick report" pengukuran vibrasi yg berbasis VBA macro excel. Jadi saya punya tool pengukuran vibrasi yaitu fluke 805. Tool ini dilengkapi dg template yg berbasis vba macro excel utk menampilkan nilai2 pengukuran vibrasi dan grafik trendingnya saat tool ini dikoneksikan dg komputer. Saya punya ide modifikasi pada tool ini utk membantu mempercepat penyajian laporan. Modifikasinya adalah 1. menampilkan nilai2 dan grafik tadi pada "form laporan rekomendasi dan analisa vibrasi" yg formatnya sdh ada di perusahaan saya. 2. Sistem ini jg nantinya diharapkan dilengkapi dengan formula utk memberikan "rekomendasi dan analisa" secara otomat...

Membuat rumus Macro Excel untuk mempermudah pekerjaan administrasi di kantor saya. Rumus untuk perhitungan komisi marketing, komisi manajer, gaji karyawan, perhitungan pajak, stock barang.

VBA Canton Ville

Menulis artikel tentang excel, menginput data, membuat program vba excel sederhana

Informasi Manajemen Akuntansi Menggunakan VBA

Menyelesaikan entri data E-SPT (Pajak Keluaran) dalam hitungan detik secara otomatis. Ratusan data Faktur Pajak dengan format (*.xls) akan dirangkum ke dalam sebuah file (*.csv) sehingga mudah di impor ke dalam software E-SPT ver. 1.5.0.0. (keberhasilan 100%)

Saya perlu bantuan vba excel expert untuk salah satu proyek yang saya kerjakan. Proyek ini tentang menggabungkan dua Worksheets (Perusahaan dan Kontak) menjadi satu Report. Kunci pencocokan adalah nama Perusahaan Dalam satu nama company bisa ada 1 atau lebih nama kontak. Beberapa nama kontak yg terkorespondensi dalam 1 nama perusahaan perlu dipisahkan dengan line break. Jadi semuanya dalam 1 cell saja. Nama University dan tahu lulusan, alamat email, dan catatan juga perlu digabungkan per line. Tetap dalam 1 cell pada row yang matched. Begitupun no telp perusahaan digabungkan dengan no hp dari tab kontak (jika ada). Report harus dalam Format yang kami tentukan (warna, border, page break, orientation, dll) Proyek ini relative mudah, bagi yang expert mungkin hanya perlu...

I need an experienced Excel VBA programmer to modify my VBA Code macros. The job involves enhancing an Excel form and including a 'modify' function. Modify "Agency" file to be like "Testttt" file and include the Modify button. Key requirements: - Modify an existing Excel form - Include a 'modify' function in the form - Improve the overall performance of the form The ideal freelancer would have: - Extensive experience in Excel and VBA - Ability to optimize data modification processes - Skills in designing user-friendly forms The project also involves changing some aspects of the form's appearance: - Removing some fields from the form - Changing the layout of the form The successful freelancer will be able to deli...

...House API () with a Microsoft Access database using VBA. The goal is to retrieve directors' and secretaries' names and store them in a table, using company numbers from another table. Below are the detailed requirements: Requirements: 1- API Connection Setup: Establish a connection to the Companies House API using VBA in MS Access. Let me know what API type and credentials for authentication are needed. 2- Data Retrieval: Retrieve directors' and secretaries' names using the company numbers from an existing table in the MS Access database. Ensure the data is accurately parsed and stored in a new table (Optional). 3- Automation: Develop a VBA script to automate the data retrieval process. Additional Notes: Include instructions on how to use

I'm in need of a proficient VBA CorelDRAW programmer for the 2024 version. My project involves creating a VBA script that generates QR codes within a specific template of a certain size. The script should also arrange these QR codes for printing on various printer sizes, specifically a custom size of 48x96 inches. Ideal candidate should be skilled in: - CorelDRAW and VBA - Understanding of QR code generation - Experience with custom printer size arrangements - Ability to work with specific size templates (small, medium, large)

I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 points ...

...all extracted data is neatly organized and formatted for easy access within Excel. Provide clear, user-friendly functionality to paste or upload listings and automatically trigger the data extraction process. Skills Required: Strong experience with web scraping or API integration to pull data from Zillow, Redfin, StreetEasy, and other platforms. Proficiency in Excel automation, preferably with VBA or Python (pandas, openpyxl) to integrate the data extraction functionality. Familiarity with Zola NYC and NYC Open Portal to access zoning and building-related data. Knowledge of real estate terminologies and zoning regulations in NYC. Experience with data validation to ensure accurate and reliable data extraction. Ability to work autonomously and deliver high-quality, maintainable co...

Silakan Daftar atau Login tuntuk melihat rincian.

I'm seeking an Excel expert who can help me code a MACROS to automate a process in Excel. The task involves analyzing employee data and generating results related to loans and other similar dat...process in Excel. The task involves analyzing employee data and generating results related to loans and other similar data entries. Key Responsibilities: - Develop a MACROS script to automate data analysis on employee data. - The macro should be able to provide results for specific data entries related to loans and other similar metrics. Ideal Skills and Experience: - Proficient in Excel and VBA programming. - Prior experience in developing Excel MACROS for data analysis. - Understanding of employee data metrics. - Able to deliver efficient and effective solutions for data processin...

I'm seeking a proficient Excel developer with strong skills in VBA and Macros. The job involves creating an automated workflow to transform data from a single Excel file into three separate files. Key Tasks: - Importing data from one Excel file - Creating three files using VBA and Macros - Data cleaning - Data merging - Data filtering The data filtering will involve: - Applying numerical ranges - Text matching - Date ranges Ideal candidates should have a robust understanding of data transformation processes and extensive experience with Excel VBA and Macros.

Bonjour, nous avons deux fichiers Excel comprenant deux colonnes comportant des codes postaux français : colonne C "CP départ" et colonne D "CP arrivée". Nous avons besoin que dans la 3e colonne "Distance en KM" vous trouviez via google ou par VBA Excel la distance en KM entre ces deux codes postaux. Exemple ligne 2 du fichier "Tri 2024" : CP départ 54710, CP arrivé : 28500, distance en km : 408 km

Description: I am looking for a skilled developer to help deploy an existing solution that automates Word document text replacement using VBA and outputs a PDF file. I already have a fully functional VBA code and an HTML interface to generate the code. The project involves using this existing logic and expanding it to work seamlessly on a server-based environment. Key Requirements: PDF Output: The system should take user inputs through the existing interface (or an upgraded version) and automatically replace the specified keywords in a Word document. Once the replacement is complete, the system should generate and provide the user with a downloadable PDF file. Database Integration: Create a database to store keywords used for replacement. Provide an option to sele...

I'm seeking an Excel expert who can help me with a project needing to build a client pipeline excel sheet which provides the ability to multi select checkboxes from a drop down for certain columns. Also need to have the checkboxes grouped under a heading with indentation/ categorization The project requires the development of advanced macros and VBA scripts. Ideal Skills: - Extensive knowledge of Excel - Proficient in writing complex VBA scripts - Experience in creating advanced macros Key Responsibilities: - Develop an excel sheet with certain columns having the ability to list checkboxes and support multi selection. - this drop down multiselect checkbox list also will be categorized under a few main parent checkbox - upon multi selection and pressing o...

I'm looking for a skilled Excel VBA expert to create a macro that converts data from my Excel file into PDFs and sends them to multiple email addresses. The Excel sheet has several tabs, each corresponding to a different group of recipients. Key requirements: - The macro should be able to handle 4 or more separate groups of recipients, as per the different tabs in the Excel file. - Email addresses are provided in a comma-separated list format. - Each tab contains sales reports that need to be converted into PDFs. Ideal candidates should have: - Extensive experience with Excel VBA and macro programming. - Previous work with automating PDF conversion and email sending from Excel. - A strong understanding of handling and sorting data for different groups. Please note, th...

Create a Word document linked to populated Access tables. The project involves inserting data via bookmarks & VBA into a Word Template document that outputs a new Word report. This output report should have no bookmarks or VBA while maintaining the required table and text formatting & styles.

I am a project manager handling diverse projects and need a professional Excel dashboard to track and manage my work efficiently. The dashboard should provide a clear, user-friendly interface and visual insights to monitor progress, timelines, budgets, and key metrics for the following: CSR Fund Tracking: Monitor inflows, outflows, and utilization of CSR funds across multiple initiatives. International University Collaboration: Track milestones, agreements, events, and communications with international universities. Hub and Spoke Model: Manage operations, performance, and data flow in this healthcare delivery model. Share4Care Online Fundraising: Track donor statistics, funds raised, and campaign performance. Ayurveda Marketing: Monitor marketing initiatives targeting both domestic...

...semplificare e velocizzare il processo di inserimento ordini riducendo gli errori manuali. Requisiti chiave: - Esperienza con SAP SuccessFactors e integrazione con Microsoft Outlook. - Capacità di creare macro o strumenti di automazione personalizzati. - Comprensione di come leggere e processare dati da file PDF. - Forti competenze in programmazione, preferibilmente con conoscenze di linguaggi come VBA, Python o simili. - Buona comunicazione e attenzione al dettaglio per garantire che il tool sviluppato rispetti le specifiche richieste. Responsabilità: - Analizzare i requisiti e proporre la migliore soluzione per l'automazione. - Sviluppare e testare la macro o il tool per assicurarsi che funzioni senza intoppi e in modo affidabile. - Fornire documentazione e...

I require an experienced VBA programmer to write a script for my Office 365 Excel workbook. The task is to automate the printing process of a specific worksheet based on a cell value in the 'Component Index' worksheet. Key Requirements: - The 'Component Index' worksheet contains the cell value that determines the number of pages to print. - The script should allow for changing the name of the workbook without interrupting the print process. - The automation should seamlessly integrate with Excel's regular print button. The ideal candidate for this project should be proficient in VBA programming and have extensive experience with Excel 2019 and Office 365. Knowledge of Excel's print processes and handling of workbook events is crucial. ...

I need a skilled VBA programmer to help me add a macro to my existing Excel file. The macro needs to automate some of my repetitive tasks, specifically: - Data entry: I want to streamline the process of inputting data into the spreadsheet to save time and reduce errors. - Data analysis: I need assistance with automating some basic analysis to derive insights from the data. The data for these tasks will primarily come from user input within Excel. Ideal skills and experience for this job include: - Proficient in VBA programming with a strong portfolio of Excel automation projects. - Excellent understanding of data manipulation and analysis within Excel. - Ability to work with user-generated input and create a seamless automation experience. I'm looking for someone ...

I need a VBA script in Excel that will help me to import data into Word. The main purpose of this script will be to merge data from Excel into a Word document. Key Features: - The Word template will include text data, tables and spreadsheets, as well as charts and graphs. - The imported data will need to be formatted with custom styles, not just standard formatting. Ideal Skills and Experience: - Proficient in VBA programming. - Strong understanding of Excel and Word integration. - Experience with creating custom styles in Word. - Able to work with diverse types of data.

Looking for a freelancer experienced in Excel and VBA to develop a tool that automates the creation of Sorare teams based on data from three sheets: "Sorare Bot," "Classifications," and "GW." The tool should: Generate valid 5-player teams for competitions following specific rules (positions, exclusions, etc.). Organize teams into blocks categorized by competition. Create a list of unused players with exclusion reasons. Include a button to update the "GW" sheet whenever the other sheets are modified. Skills Required: Advanced Excel and VBA expertise. Data processing and automation. Attention to detail for applying prioritization and exclusion rules.

I'm seeking an expert excel/vba programmer. I'm using an existing vba macro excel program that needs to be upgraded. It was created to automate the process of building a single inventory list from multiple vendors feeds. The website is now using the Shopify platform and requires data to be imported into different column names and for more columns added. Summary of work required: 1. Need to change the import process to a single form, where feed can be added, vendor profile selected, map file column names to names in the program, save profile and import feed. 2. Adjust Export functionality to use similar template with different columns for different export options. 3. Data in compiled list needs to be read only unless enabled for in-line editing 4. Need a butt...

- The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of us