Excel vba assign macro to button programmatically일자리

...you stuck closer to the finish line, unsure what you need to do to get your paper up to commercial or academic publishing standards? I can help! I am a widely published writer of nonfiction, journalism, and science research with a wide variety of publications under my belt. I especially excel in first-person investigative journalism, memoir and biography, mainstreaming science for press releases and articles, and polishing scientific papers pre-publication (especially mechanical engineering, biomedical engineering, Sports science, Ergonomics, Biomechanics). I can advise on a wide variety of styles from mass market to specialist publications and especially enjoy 'punching up' research for public consumption. If any of these sound l...

VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화

C# WinForm 기반의 Windows 응용 프로그램중 특정 기능 ListView/ListBox/DataGrideView 등의 Cell안에 Custom UserControl (Button 및 그림 및 체크박스등이 탑재된 UserControl)을 집어 넣고 리스트화 시킴. 단, TalbeLayoutPanel 등 Panel 컨트롤을 사용하면 안됨. Panel컨트롤은 32767 사이즈의 한계가 있어 컨트롤이 탑재되지 않음.

Description: I’m looking for a highly skilled Personal Assistant to support me in a wide range of tasks, including business operations, marketing, research, data management, and administrative work. You should be organized, detail-oriented, and proactive, with a strong ability to handle multiple responsibilities efficiently. Key Responsibilities: - Administrative Support: Manage schedules, emails, travel arrangements, and other organizational tasks. - Marketing Assistance: Help with digital marketing tasks, content creation, market research, and campaign coordination. - Business & Research Support: Conduct research, prepare reports, and analyze business or industry trends. - Data & Excel Work: Organize and manipulate data in Excel, including formu...

I'm looking for an ...only performs financial calculations but also allows users to customize its interface with themes. A standout feature of this app is a button that saves user-selected calculations to their Google Drive file. Key Requirements: - Customizable interface with themes - Capable of performing financial calculations - Save user-selected calculations to MS SQL Server - Simple, intuitive, and engaging design - Financial Report - Daily, Monthly, Yearly - Application should be comparable with any device Ideal Skills: - Expertise in mobile app development, particularly Android and iOS - Experience in designing customizable user interfaces - Competence in implementing MS SQL Server - Proficiency in creating financial calculator apps - Ability t...

...instructions on how to create a thumb drive with it (Rufus is available and experience with command line) - see to it that all necessary drivers for that computer are being found This is the current situation: ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ The laptop computer has an Intel Core i7-660U @ 2.60 GHz · Skylake U, a 6th-Generation CPU. Dell explicitly has Windows 7 drivers for this model on their website (). I already have successfully created two USB thumb drives with W7 that both are able to boot the laptop: One using legacy boot and one using UEFI boot. In the BIOS, legacy boot and UEFI boot is switched on, as well as AHCI. Eithe...

...Android and iOS that allows users to engage in live-streamed game challenges, such as chess, card games, and dominoes. Users can place monetary bets, and winnings are distributed as follows: 40% to the winner 10% to the loser as a consolation prize 50% to the app 2. Core Features: A. Games & Live Streaming Support for games like chess, card games, dominoes, and more. Live streaming system within the app, allowing users to play in real-time. Options to create private and public game rooms. B. Betting System & Financial Distribution Before starting a challenge, each player deposits an amount as a participation fee. The total amount is collected in an in-app wallet. After the game ends, the winnings are distributed as follows:...

I'm seeking an expert in customer service queue management systems. You will be helping me solve queuing question. Ideal skills and experience for the job include: - Excel - Proven track record of improving queue efficiency - Strong problem-solving skills - Excellent communication skills to explain complex concepts in a simple way

For a shared Excel file on Sharepoint, need two scripts (or a way to do the following): 1. On opening the Excel file, hide any row in which all dates in the row are more than 7 days from the current date. 2. On opening the file, any cell that has a date with text in bold and the date is today or before, will have the cell background turn white and the cell text turn red.

I am looking for draftsman to complete some house plans with CAD and dimensions for the attached excel sheet. Please get in contact of you have any queries Regards

...need an experienced Excel professional to create a 5-tab spreadsheet based on a study I have. (Toddler Parameters, Toddler Budget, Infant Parameters, Infant Budget, Total Budget tabs) - The first two tabs will be for data input and analysis results, respectively. Information for the parameters are found on the study, (Total staff, salary, total students, overtime, ) parameters should include all costs and revenues. - Text descriptions will be the primary parameters to be plugged into the spreadsheet. - The spreadsheet should feature automated calculations and data validation to ensure accuracy and ease of use. Categorys in the toddler and infant budget tabs should be label by months (Jan - Dec) screenshot of examples of what it should look like are also b...

I need help modifying an Excel spreadsheet to ensure names and addresses are formatted correctly for UPS shipping software. This project mainly involves changes to the layout and overall formatting of the spreadsheet. See attached files from Unishippers as to format needed and spreadsheet that needs to be changed

I'm in need of an HTML and CSS expert to help me create a specific footer layout for my Wordpress site. The footer needs to be responsive and match a reference photo I will provide. Key Requirements: - A row of links, with one column containing two links - A specifically styled button - Use of link placeholders, as I will add the destinations later The footer needs to be optimized for: - Mobile - Tablet - Desktop The button in the footer doesn't require any interaction. You will not need to implement any hover or click effects. Ideal Skills: - Proficient in HTML and CSS - Experience with Wordpress - Strong understanding of responsive design - Able to deliver precise pixel-perfect layouts - Familiarity with creating link placeh...

I need a comprehensive report based on two tasks: 1. A detailed analysis of Qlik's e-book "Turn your Excel Reports into Stunning Dashboards." This should include what you learned and insights on data visualization, dashboard design, and excel integration. 2. An exploration of a business application from the Microstrategy website. You'll need to choose an industry, select a business application, and write a report on the insights gained from the associated video. The final report should be 4-5 pages long, formatted in APA style, and include at least three references. Ideal candidates will have strong skills in data analysis, report writing, and familiarity with APA formatting. Experience with Qlik and Microstrategy is a plus.

...skilled Excel VBA developer to create a utility that interfaces with both Serial Communication and IP data, sending the parsed information directly to specific columns in an Excel worksheet for further processing. Key Requirements: - The data being received is mixed, comprising both numeric and text elements. - A significant portion of the project involves data visualization, so experience in working with graphical representations of data in Excel is a must. - The selected freelancer will need to program the utility so that it reflects the parsed data in specific columns of the worksheet. Ideal Skills: - Proficiency in Excel VBA - Experience with data parsing from Serial and IP sources - Strong understanding of data vis...

...(EasyEDA) I am looking for an experienced electronics engineer to review, finalize, and improve an existing calculator project that was previously developed but has some unresolved issues. Project Scope & Requirements: ✅ Verify & Correct BOM (Bill of Materials) The current freelancer could not provide the correct part numbers needed to manufacture the board via PCBWay. Ensure all components match the design and are available for order. ✅ Review & Fix Firmware (EasyEDA) The firmware/code was provided, but I am uncertain if it works correctly. Need a firmware expert to review and adjust any necessary fixes. Ensure all button functions are correctly mapped. ✅ PCB Adjustments & Optimizations The project was converted from a dual-PCB design ...

...Using VBA in Excel I am reaching out to seek your expertise in creating an interactive Excel model that includes dropdown boxes and filtered tables using VBA. The goal is to replicate a system where selecting an item from a dropdown box (e.g., a country) automatically filters a table to display relevant data. Key Requirements: Dropdown Boxes (Combo Boxes): Create dropdown boxes that allow users to select specific criteria (e.g., cities, statuses). The dropdown should be populated with a predefined list of items. Interactive Filtering: Upon selecting an item from the dropdown, the corresponding table should automatically filter to display only the rows that match the selected criteria. The filtering should be dynamic a...

I need someone to create a quick stock summary sheet. I will provide an Excel file with the 2024 sales data, along with an example format. Your task is to locate the corresponding buy data from the 2020-2022 period using the transaction records I provide and complete the final 2024 Excel sheet based on the given format. Do not use AI please. I will send the buy data ,once you are selected

I am in need of an expert in operations research and mathematical modeling who can develop a multi-objective, multi-period location-routing model, based on several critical assumptions like heterogeneous vehicle and differents ty...products. Ideal Skills: - Proficiency in developing complex models for multi-objective optimization. - Strong understanding of both location and routing optimization. - Proficiency in GAMS programming. For this task, I expect the following deliverables: 1. Review the proposed model and adjust the formulation as needed to ensure valid results. 2. Refine the mathematical model in GAMS and validate it using test instances in Excel. 3. Implement the multi-objective weighting method to solve the problem and assess the relative importance of ...

Lizenzverwaltung & Song-Datenbank ✅ Übersicht aller Songs mit relevanten Daten (Titel, Künstler, Veröffentlichungsdatum, Label) ✅ Hinterlegung der Lizenzbeteiligung ✅ Erfassung von Umsätzen für jeweilige Abrechnungs...Berechnung ✅ Berechnung deiner Lizenzanteile basierend auf den Umsätzen ✅ Berücksichtigung unterschiedlicher Beteiligungen pro Song 3. Einnahmen-Tracking & Berichte ✅ Darstellung deiner Einnahmen über verschiedene Zeiträume ✅ Filter- & Suchfunktionen für schnelle Auswertungen ✅ Grafische Darstellung der Umsätze & Trends 4. Export & Rechnungsstellung ✅ Export der Abrechnungen als CSV, PDF oder Excel ✅ Erstellung von Lizenzabrechnungs-Anforderung an Künstler/Labels 5. Benutzerfreundl...

I'm looking for a skilled Excel expert to create a comprehensive tracking sheet for my daily store visits. The sheet should have a tab for each day, and a master tab that compiles all customer information and interaction feedback. Requirements: - Track customer interactions during each store visit. - Record specific details about each customer interaction, primarily comments and feedback. - Categorize feedback into follow-up items. Ideal Skills: - Proficiency in Excel. - Experience with data tracking and analysis. - Ability to create user-friendly and organized spreadsheets.

I'm looking for an Excel expert who can create an intuitive spreadsheet for tracking job preparation based on asset availability. Key features: - The spreadsheet should track various statuses such as: - Not Started - In Progress - Completed - Asset not available - Mobilized - Ready for mobilization - Color-coded cells indicating the status of job preparation and mobilization. Ideal skills: - Proficiency in Excel - Experience with project tracking tools - Good understanding of color-coding for status tracking With this tool, I'll be able to easily monitor the progress and prepare accordingly.

I’m looking for a talented and passionate freelancer to create a 5-minute mixed media storytelling video about the spectacular collapse of Nokia, once a titan of the mobile phone industry. The video will be in French, formatted as an Instagram Reels, with a bold, impactful tone, witty and dry humor laced with satire, and a sharp business lesson that sticks. Fluency in French is a must for this project. Project Details: Length: 5 minutes. Script Provided: A detailed outline and full script in French, featuring a shocking hook (“4 out of 10 phones were Nokia”), fun facts (the CEO laughing at the iPhone), sarcastic punchlines, and clear visual cues (archives, memes, graphs). Style: A seamless blend of live-action (on-camera + voiceover, in French) and an...

New CI project or similar framework to manage some reporting requirements. We are currently doing the process manually but would like to automate. 1. Attach to an existing database and display a main grid of records 2. Create additional tables in DB as needed to accomplish tasks 3. Each record will have several actions that can be done to each i. update status ii. Attach documents iii. view details iv. update 4. System will also have ability to run reports that will export into excel as needed. 5. We will have several other functions i. manage user...

I need an Arduino expert to program my device to count button presses and send data to Ubidots via a Wi-Fi module. Key Requirements: - Count: The project involves counting the number of times a button is pressed. This data will need to be sent to Ubidots for monitoring. - Wi-Fi Module: The data transmission will be done through a Wi-Fi module. Experience with this specific module and its integration with Arduino is a plus. - Ubidots: Prior experience with Ubidots is highly desirable. I want the data to be accurately and timely sent to the platform. Ideal Skills: - Proficiency in Arduino programming - Experience with Wi-Fi module integration - Familiarity with Ubidots - Problem-solving skills to troubleshoot any potent...

We are looking for a fresher to join our startup as an Inventory Management Assistant. This role is perfect for someone who is eager to learn about inventory control, stock management, and supply chain processes in the fashion and apparel industry. As a growing garments brand, we need a dedicated individual who can help us keep track of stock, manage entries, and assist with order fulfillment. Key Responsibilities: ✅ Inventory Tracking & Management: Maintain accurate stock levels, update inventory records, and ensure real-time tracking of available products. ✅ Amazon & Meesho Listings: Add and update inventory on Amazon, Meesho, and other e-commerce platforms to ensure stock accuracy. ✅ Stock Entry & Updates: Regularly update stock counts in spreadsheets o...

As agreed!?

I'm looking for a professional web developer to create a project management website similar to Trello. The primary focus of the site will be on facilitating project management. Key Features: - Task Assignments: The site should have a feature allowing users to assign tasks to team members. Integrations: - Google Drive: The website will need to integrate with Google Drive for file storage. Ideal Skills: - Web Development: Expertise in creating interactive, user-friendly websites. - Integration Skills: Experience with API integrations, particularly with Google Drive. - Project Management Knowledge: Understanding of project management principles to ensure the website meets user needs.

...the product page and eCommerce checkout sale Handles quotes, orders, and conversion to invoices sale_management Enhances the sales workflow with advanced quotation features account Manages invoices, payments, and follow-ups sign Allows customers to sign the order online payment Enables online payment via Odoo-supported gateways mail Automates email notifications (quote sent, order confirmation, reminders) crm Handles automated follow-ups if no order is placed within 7 days stock Tracks and records disposal weights and volumes for final billing website_form Enables the customer input form on the product page ? Project Flow & Features The following steps detail the end-to-end process from product selection to final invoicing: 1️⃣ Dynamic Product Configurat...

I have some work, in an Excel spreadsheet.

I'm seeking an Excel Online expert to help me set up individual spreadsheets for each of my collaborators, linked to a global billing spreadsheet. Key Requirements: - Create separate, individual Microsoft Excel Online spreadsheets for each collaborator. - Each spreadsheet should have 'Edit permissions' for the respective collaborator, allowing them to input their own data. - The data from the global billing spreadsheet should be reflected in the individual sheets automatically and in real-time, without the collaborator having access to the global spreadsheet. Ideal Skills: - Proficiency in Microsoft Excel Online. - Experience with setting up complex spreadsheet systems. - Knowledge in automating data updates across spreadshe...

I'm looking for a designer who can add finishing touches to 6 rough sketches intended for 1.5 inch button pins. The design should be cartoonish, utilizing a bright and vibrant color scheme. The button pins will need to incorporate elements of fantasy creatures. Ideal skills and experience for the job include: - Proficiency in cartoonish design - Experience in designing for merchandise, particularly button pins - Ability to work with bright, vibrant colors - Experience with designing fantasy creatures - Strong attention to detail for finishing touches

...General Overview: - The website will serve as an online presence for a café, allowing customers to view menu items, make orders, and facilitate payments through a single-page layout. 2. Design Requirements: - User-Friendly Interface: The website should have a clean, modern design that is easy to navigate. - Responsive Design: The website must be mobile-friendly and function smoothly on various screen sizes (desktop, tablet, and mobile). - Branding: Use the café's logo, color scheme, and typography consistently throughout the site to reflect the café's identity. 3. Sections of the Website: - Header: - Café name and logo. - Navigation links (if any are necessary, e.g., to social media). - Me...

Data gathered to an Excel file. Data gather to excel file

I have created a program that extracts the JSON object of a Figma design file (of web...Figma's restful API. Furthermore there is an another script already in place that enables parsing the JSON and updating the 'type' keys to a desired value, eg a key having type value 'FRAME' can then be updated to say 'Button', this mechanism is called tagging which is also done by other figma-based code extensions to improve code accuracy. Now I want a python script that takes this tagged design JSON as input and then translates it to HTML and CSS codes. Required components Header, Footer, Navbar, all form elements, text elements, media elements like images, videos and audios nested elements like Cards, tables, lists and other conta...

We are looking for a WordPress expert with Elementor experience to create a modern, corporate landing page for a global trading company specializing in agricultural and industrial commodities (corn, sugar, wheat, metals). Additionally, we need our logo to be vectorized to ensure high-quality scalability across different platforms. Project Scope: ✅ Landing Page Requirements: Theme: The design should be based on the Neve theme (or similar lightweight, fast-loading theme). Page Builder: Elementor (free or Pro version). Design Style: Corporate, modern, clean, and minimalistic. High-end B2B feel, focusing on international trade. Structured sections with proper UX/UI balance. Color Palette: Dark Green (#1E3A34) Gold (#D4A757) White (#FFFFFF) Page Structure: 1️⃣ Header:...

I'm in need of an Excel sheet specifically designed for calculating construction costs. The sheet should encompass: - Material Costs - Labor Costs - Total Project Cost In addition, I'd like the sheet to incorporate specific Excel functions and formulas such as: - Sum and Averages - Conditional Formatting Ideal candidates for this project should have a strong background in Excel, particularly with creating complex sheets for cost analysis. Experience in the construction industry would be a plus. Please bid with a brief overview of your relevant experience and examples of similar projects you've completed.

...multi-user app (one requires an administrator and other users) that acts as an exam preparation site for multiple courses. Frameworks to be used These are the mandatory frameworks on which the project has to be built. Flask for application back-end Jinja2 templating, HTML, CSS and Bootstraps for application front-end SQLite for database (No other database is permitted) Note: All demos should be possible on your local machine. Roles The platform will have two roles: Admin - root access - It is the superuser of the app and requires no registration Admin is also known as the quiz master There is only one admin to this application The administrator login redirects to the quiz master/admin dashboard The administrator will manage all the other users The admi...

I'm a university student seeking a mentor to help me navigate my data module. The focus is primarily on using Excel functions to sort numerical data. Key Responsibilities: - Interpret and explain the tutorials provided - Help me understand and apply Excel functions to sort numerical data - Provide guidance on data analysis techniques Ideal Skills: - Proficient in Excel - Strong understanding of data analysis - Previous experience tutoring or mentoring university students Looking forward to your bids.

...should integrate financial ratios and performance metrics for individual exporters, offering insights into profitability, liquidity, efficiency, and financial stability. The model should allow for accurate assessments of export trends, market health, and financial viability, with room for ongoing updates and scalability. The model should also support reworking and enhancement of an existing model to better suit the current requirements. Scope of Work: National Cattle Export Overview: Volume & Value of Cattle Exports: Forecasted data on national export volumes, values, and growth trends. Key Markets & Export Destinations: Breakdown of export destinations, pricing dynamics, and trends in demand. Government Policies & Trade Agreements: Consideration of how national po...

I am looking to implement some plugins for my website. The website is Wordpress based and is using a booking and scheduling plugin that I need to add additional features to. The booking and scheduling plugin installed uses Java, JavaScript and PHP. Geofencing enables employees to set a travel radius, determining how far they are willing to travel to meet customers requirements The calendar should display whether the customer is visiting a set location or if the employee needs to travel. A call/text button should also be available for both parties to facilitate quick communication. A store locator should help customers find the nearest available location. If no locations are nearby, they should have the option to ent...

I'm in need of a skilled software engineer who can help me fix my JSON parser (implemented in Excel/VBA). The parser is encountering crashes and unexpected behavior when dealing with a new format of JSON. Key Requirements: - Diagnose and fix bugs in the JSON parser - Ensure the parser can handle the new JSON format Ideal Skills: - Proficient in debugging software - Experienced with JSON data and parsers - Familiar with the specific issues of crashes or unexpected behavior

...experienced Excel macro developer to create a macro that will import data from a specific TXT file on my computer and format it to match my PDF example. I currently pull the data from an IBM and it is saved on my windows computer as "AP Data." I then need to be able to open an excel workbook and run a macro that will import "AP Data" and format it so it matches the PDF example identically. All numbers in the excel worksheet after import need to be formatted as accounting so something that appears on the PDF Example as 7.50- will change to (7.50). The print area needs to match the PDF example. There are page numbers at the top right of each page and that needs ...

I'm looking for a professional with expertise in Bartender Software. I need to create barcodes pulling from specific fields in a Master data spreadsheet. The spreadsheet is located in Egnyte and is co-edited using Microsoft Excel Online. The fields I am interested in include GTIN, Catalog Number, Lot Number, Serial Number, Expiration Date, and Quantity. This data needs to be pulled from filtered data based on a blank Allocation column (see attached spreadsheet) Ideal skills and experience for the job: - Proficiency with Bartender Software. - Experience in barcode generation and software integration. - Attention to detail to ensure accurate data pull for barcode creation. Please reach out if you have the necessary skills and experience.

...Features & Modules 1. User Roles & Access Control • Admin (Owner): Full control over system functions. • Staff (Employees): Can add expenses, view their reimbursements, and check vehicle file status. 2. Vehicle File Management • Ability to create a new file for each vehicle clearance using: o Chassis Number / File Number (Unique Identifier) o Client Name o Vehicle Details o Status: Pending, In Progress, Cleared o Total Expenses Incurred • Staff members can only add expenses if the file is active. • Admin has access to re-open a file in case a staff member forgot to add an expense. 3. Expense Tracking & Reimbursement • Staff members can log daily expenses for each file by selecting: o Chassis/File Number o Expense Type (Cus...

I'm seeking for a professional who can help me extract contact information from customer accounts on the website www.food-service.de....professional who can help me extract contact information from customer accounts on the website www.food-service.de. Key Requirements: - Extracting contact information from customer accounts on the website - Delivering the extracted data in an Excel spreadsheet Ideal Skills and Experience: - Proficient in data extraction and web scraping - Excellent attention to detail to ensure all relevant contact information is extracted - Experience with delivering data in Excel format Please provide a concise proposal detailing your experience and approach to this project. Show me scraping first 50 details like name,mail,cont...

I am in need of a skilled female Indian professional with expertise in Tally and Excel to assist with data entry and recording. The primary focus will be on tracking expense and income. Key Responsibilities: - Accurate data entry of expenses and income into Tally and Excel - General assistance and guidance in categorizing data Ideal Candidate: - Proficient in Tally and Excel - Excellent attention to detail - Able to provide guidance in data categorization - Female Indian professional

Necesitamos realizar un programa en Excel con macros en la cual se permita cargar datos de productos, datos de clientes y luego genere una cotización. Debe incluir: 1. Base de Datos de Máquinas o Código del producto o Descripción breve o Precio de lista o Precio de contado o Precio con pagos en 0-30, 0-30-60, y 0-30-60-90 días 2. Formulario de Cotización o Ingreso de datos del cliente (Nombre, Apellido, Teléfonos, Localidad, Provincia, Email, Fecha, Evento) o Selección de una o varias máquinas de un listado desplegable o Generación automática de la cotización en PDF (se debe imprimir en una hoja tamaño A4 que en el encabezado aparezcan todos los datos de la empresa con el logo, luego los datos cargados del cliente, numero de cotización, y después los productos cotiza...

...looking for a professional to help me implement an email campaign aimed at real estate agents to an existing database of newly selected prospects in the South African market using MailChimp. Key Components of the Project: - The main goal of this campaign is to generate leads. - To introduce Real Estate Brilliance as the authority in realtor training in SA. - The target audience is specifically real estate agents. - I have 13 emails and 12 free guides prepared that will be used in the campaign. - Automation of 13 email campaign - 1 email per week. - FREE Guide to be sent as an immediate follow-up email when the download button is clicked. - Linking the relevant company website page to the CTA button - The Agent Success System. - L...

I am looking for a freelancer who can provide me with an email list of AirBnB, VRBO (Vacation Rentals by Owner), and other short term vacation rental hosts in North Carolina,...with an email list of AirBnB, VRBO (Vacation Rentals by Owner), and other short term vacation rental hosts in North Carolina, South Carolina, Alabama, and Georgia. in the form of an Excel spreadsheet. All hosts are acceptable and there are no specific criteria for inclusion in the list. The ideal candidate should have experience in data mining and compiling email lists. Attention to detail is crucial to ensure that the list is accurate and up-to-date. The list should contain the following: Name, phone number, and email address, and should all be valid and up to date information. We...