Vba seomozPekerjaan

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

In the zipped folder, it contains - sample of 2 months dummy data - each file contain IND and ENT sheets, some files may only contain either or - "consolidate" excel file is the sample outcome for reference The VBA should work as per below - an input to insert month (free text) e.g. 202301, 202302 etc - choose destination folder and files (in some of the months it contain unnecessary files) - IND sheet to consolidate only IND data from selected files - ENT sheet to consolidate only ENT data from selected files - 'Summary' sheet to provide number of rows overview for both Challenge - whether consolidation outcome can be done in 1 excel - whether it would work with a password encrypted files (please advice any workaround)

I want to design a vba code where i can send text or whats app message

EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.

...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within AutoCAD itself. - You should...

**Project Objective:** We are looking to automate the management of absences within our company using VBA Excel. The goal is to simplify and optimize absence tracking, reporting, and data analysis to save time and improve accuracy. **Project Description:** The project involves developing an automated solution in Microsoft Excel that includes: 1. **Absence Data Entry:** - Interactive forms for entering absences (sickness, vacations, authorized absences, etc.) - Data validation to ensure accuracy and consistency. 2. **Automatic Absence Calculation:** - Automatic calculation of absence days per employee. - Tracking different types of absences and their quotas (paid leave, sick days, etc.). 3. **Report Generation:** - Creation of weekly, monthly, and annual reports. ...

We seek an Excel expert with experience in developing Bill of Materials (BOM) and I... - Detailed sales tracking with automatic inventory quantity adjustments. - Low stock level notifications via highlighted rows in the spreadsheet. - The system should allow easy expansion for adding new sales data, inventory items, saved BOMs, assemblies, types or categories. **Skills Required:** - Demonstrated experience in BOM and Inventory system development. - Advanced Excel Macros and VBA skills. - An analytical approach with a focus on delivering simple and functional solutions. Candidates are encouraged to share examples of previous similar projects. This project aims to deliver a straightforward solution that supports our small home business operations effectively. Budget: Maximum o...

I'm in need of a VBA script that can generate textual reports from Excel spreadsheets. Key Requirements: - The VBA script should focus on generating textual reports, without the need for incorporating charts or graphs. - The data source for the report generation will be Excel spreadsheets. Ideal Skills and Experience: - Proficiency in VBA coding and automation. - Strong understanding of Excel and its data manipulation capabilities. - Prior experience in report generation through VBA is highly preferable.

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report even if missing phot...

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, nor... logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsoft Fabric and Excel (VBA) • Potenti...

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 – 300 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 knowled...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I am looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro...the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issue...

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data A...Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA would be an added advantage. If you are interested in this project, please include any relevant experience in...

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requir...with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issue...

...Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed documentation on how the automation works, including instructions for use and troubleshooting. Testing and Support: Initial testing of the automated system and support for any issues that arise during the first month of operation. Skills Required: Proficiency in VBA for Excel and Outloo...

Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...