Vba seomozPekerjaan

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. 4. M...

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...

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical kno...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

2 excel files with VBA macro as per customer requirement

One excel file with macro as per requirement

One excel file with macro as per the customer requirement

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and defect-f...

I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.

I need an Excel...Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, please provide example...

I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.

I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.

As the client for this project, I urgently require an expert in VBA.

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Dat...based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - Ease of use: The end-user will be working in Excel, so the implementation should be user-friendly and seamless within the Excel environment. Ideal Skills and Experience: - Proficiency in Excel: A deep understanding of Excel formulas and VBA scripting is essential for this project. - Experience with QR code generation: Prior experience with generating QR codes, especially within Exce...

Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting is key. If you can meet th...

I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

Development and Enhancement of Excel VBA Project Tracker.