Excel vba open spreadsheet start macromunkák
1) Üzleti folyamat specifikáció alapján és a kész termékre vonatkozó elvárások megértését követően az alkalmazás Excel frontend és funkcionalitások tervezése. A megrendelő és a fejlesztő közösen alakítja ki a koncepciót. Becsült munkaóra (BMó): 40 2) A működési koncepció implementálása Excel/VBA/.NET VB környezetek felhasználásával. BMó: 60 3) Fejlesztői kód dokumentáció. BMó: 20 4) Teszt esetek kidolgozása a megrendelővel közösen, azok végrehajtása, dokumentálá...
Szia! Van egy lista excelben facebook felhasználókról. 11.000 sor. Magyar keresztnevek szerint kellene szűrni a listát úgy, hogy minden keresztnév és annak becézett formái, beleértve az ékezet mentesen rosszul megadott neveket is, egy külön munkalapon legyenek. Kérlek jelezd vissza, hogy tudnád e vállalni a munkát. Köszönöm!
Szia! Van egy lista excelben facebook felhasználókról. 11.000 sor. Magyar keresztnevek szerint kellene szűrni a listát úgy, hogy minden keresztnév és annak becézett formái, beleértve az ékezet mentesen rosszul megadott neveket is, egy külön munkalapon legyenek. Kérlek jelezd vissza, hogy tudnád e vállalni a munkát. Köszönöm!
A projekt: Valós idejű szegmentáció megvalósítása egy online felületen Excel algoritmus alapján. Webes felület létrehozása, melyre a partner kutatócégek továbbíthatják a kutatásban részt vevő kérdőív kitöltőket. Az oldalunkra továbbítva a kitöltőknek meg kell válaszolnia néhány kérdést, majd a válaszokon egy Excel alapú algoritmust lefuttatva különböző szegmensekbe soroljuk őket és ezután a kutatócég kérdőívéhez visszairányítjuk ezzel az információval. Mivel eddig a szegme...
xazoo xazoo xazoo xazoo xazoo xazoo xazoo xazoo xazoo xazoo xazoo xazoo xazoo xazoo xazoo xazoo xazoo xazoo xazoo xazoo
QAWFafAFafsaffgsgfsagfsafsa vdklmnásldknsad'nksa;dl dfb'lsa bks b'ls bvlk;SBVKsbvSBVSnb'sBKL SA B SAB SA BDSA B SAB ASDBADSB BDSA SA DS SD BDS dsfbsB
Vállalok adatrögzítést Excel táblázatba, Word-be. Másolásokat, írásokat. Diagram készítést, tanácsadást magyarul a segítséget kérőknek.
Adatfeltöltés, táblázatkezelés, függvények, kimutatások, statisztikák és diagramok közzététele. Teljes körű Excel ismeret.
Adatfeltöltés, táblázatkezelés, függvények, kimutatások, statisztikák és diagramok közzététele. Teljes körű Excel ismeret.
Gyorsan gépelek tízujjas vakírással ismerem az excel táblázatot és gyorsan tudok adatokat is a táblázatba vinni. Másolási feladatokat is szintén gyorsan el tudom végezni. I type fast familiar with the Ten Thumbs blank face and quickly excel spreadsheet data can be carried over to the table. I can also quickly perform copying tasks.
Gyorsan gépelek tízujjas vakírással ismerem az excel táblázatot és gyorsan tudok adatokat is a táblázatba vinni. Másolási feladatokat is szintén gyorsan el tudom végezni.
Otthon elvégezhető távmunka. Információ gyűjtés, adatok bevitele a táblázatba, keresés az interneten, Excel táblázat készítése, segítés az ügyfélszolgálat munkájában.
Otthonról végezhtő számítógépes munka. Tapasztalatom van a LINUX programban, Open Office alatt végezhető szövegszerkesztésben (KÖMAL folyóirat).
I am looking for a moderately detailed Apple spreadsheet to track the revenue and expenses of my sales trips. This spreadsheet needs to cater to a weekly update frequency. Key Components: - Categories of Expenses: The spreadsheet should include various categories of expenses such as Transportation, Accommodation, Meals, Groceries, and Deals. - Revenue Tracking: In addition to expenses, it should also allow for tracking of revenue generated on these trips. - User-friendly: The spreadsheet should be simple to use and update on a weekly basis. Ideal Skills and Experience: - Proficiency in Apple spreadsheet software - Previous experience creating financial tracking spreadsheets - Ability to create user-friendly and intuitive spreadsheets.
...reports and handle GMB setup tasks promptly. Excellent communication skills and attention to detail. Deliverables: Daily Report with 20–30 researched businesses, including key details and GMB optimization gaps. Fully optimized Google Business Profiles for clients, completed within agreed timelines. Budget: Monthly Budget: $300 (approximately $10/day for research and profile setup). Rate structure: Open to hourly or project-based payments within this budget....
I need assistance to extract data from a PDF document into an Excel spreadsheet for 200 organisations. The data includes organisation names, emails, telephone numbers, and postal addresses. Key Requirements: - Proficient in data extraction and Excel - Previous experience working with PDF files - Attention to detail to ensure data is accurately transcribed It is essential for the freelancer to have the ability to carefully transcribe the information from the PDF to the Excel spreadsheet without errors.
I'm looking for an Excel expert to create a training management sheet for me. Features of the Excel sheet should include: - Tracking of employee details - Logging of training topics - Scheduling and recording of training dates The primary use of this Excel sheet will be monitoring progress of employees throughout their training. Therefore, the sheet should be designed in a way that makes it easy to track individual progress and overall training effectiveness. Ideal skills for this job include: - Advanced Excel skills (formulas, pivot tables, data validation) - Experience in creating training or attendance tracking sheets - Understanding of training program metrics
I'm looking for an experienced professional to assist with reconciling my business bank account using Microsoft Excel. This task involves reviewing deposits, withdrawals, and transfers. Key Responsibilities: - Bank Account Reconciliation: You will be responsible for ensuring all transactions are accurately recorded and accounted for. - Invoice
My current ICTFAX installation on a Linux server has issues. While I can send faxes with...features, and user registration are not working correctly. The original service provider has become unresponsive, and I'm looking for an experienced professional who could either fix my existing setup or install a reliable open-source alternative on my server. Critical Features to Fix or Add: - Mail-to-Fax and Fax-to-Mail functionality - User Registration System I am open to both options - repairing ICTFAX or switching to a new web app. The ideal candidate for this job should have extensive experience with ICTFAX and Linux servers, as well as expertise in installing and managing open-source web applications. Please note that I am not interested in any contracted services o...
...camera ha bisogno di molti armadi per riporre i nostri vestiti, mi piacerebbe una soluzione ad ante scorrevoli dove si nasconde nell'ultimo metro una scrivania per lavorare in smart working. - La casa deve avere anche dei soppalchi posizionati in alcuni punti del controsoffitto per riporre valigie ecc. - Una disposizione open space per lo spazio abitativo. I candidati ideali avrebbero una forte esperienza nella progettazione architettonica moderna con un portafoglio di case open space. Il tuo ruolo comporterebbe la creazione di piani e visualizzazioni dettagliati, lavorando a stretto contatto con me per garantire che il progetto finale soddisfi la mia visione. Non ho molto budget per realizzare il lavoro quindi ho bisogno che non ci siano troppi lavori di falegnameri...
...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
We need to have the 2024 Rate card converted to an Excel sheet. They have discounted rates by 12.5% for Platinum Winter and 15% for Gold Winter, as shown in a column.
I need a logo for my welding and fabrication... reflecting the nature of the work we do. Key Points: - The design should be modern and sleek, while still embodying a classic and traditional rustic and industrial style. - Creativity is key, as I have not specified particular elements to include in the logo. However, the designer's understanding of the field may inspire the incorporation of relevant elements. - As for color scheme, I'm open to suggestions. However, a mix of metallic shades and earth tones could work well. Skills and Experience: - Proven experience in logo design, particularly in the industrial sector. - Strong understanding of both modern design principles and traditional rustic aesthetics. - Excellent communication skills for discussing design ...
I'm looking for a talented motion graphic artist to create an engaging video for my song cover. The final product will be used on both YouTube and Spotify, so it needs to meet the specifications for bo...final product will be used on both YouTube and Spotify, so it needs to meet the specifications for both platforms. Key requirements: - Experience in creating motion graphic videos, ideally for music - Understanding of the rhythm and mood of hip hop music - Ability to create visually captivating content that will hold viewers' attention on both platforms The exact style of the motion graphics is open to your creative interpretation, as I have not settled on a specific approach. I am looking for someone who can bring a fresh perspective and create a compelling video that c...
I'm looking for a C# plugin for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provide optimized DAX code for each. A list of these measures should also be in a combo box. My primary data sources are SQL DB and Excel, so experience with these is crucial. The plugin needs to work with both imported data and DirectQuery modes.
I'm seeking a professional who can assist me in migrating my e-commerce site from WooCommerce to a better platform. The current WooCommerce platform has become bloat...who can assist me in migrating my e-commerce site from WooCommerce to a better platform. The current WooCommerce platform has become bloated with too many plugins, which has led to performance issues. I need a new platform that is efficient, easy to navigate, and doesn't require excessive reliance on plugins. We are considering these options : 1.) Hydrogen by Shopify 2.) Sylius 3.) BigCommerce Open SaaS (Headless Option) 4.) OroCommerce If you have others we will consider those also. ALL options MUST be self hosted ! I am looking for a professional who can deliver a high-quality, efficient site that meets...
I'm seeking a top-tier web designer to cre...provide: - Expert-level design capabilities - Strong web development skills - Understanding of SEO principles (for geo-specific targeting) - Ability to deliver high-quality work that can be showcased in your portfolio. The gallery section will need to be flexible and adaptable, potentially incorporating features like a slideshow view, grid view, and zoom-in functionality for the artwork, though I'm open to your professional recommendations. The main focus is on design, but I also require comprehensive SEO support and Google My Business setup. Your ability to deliver 'everything that's asked of and more' is essential for this project. This is a unique opportunity to demonstrate your top-tier talent and create a...
I'm nearing the completion of a Dotnet core application designed to send prompts to an Open API and retrieve responses in HTML format for a viewer. I need some assistance with the final touches. - Main Task: - I need help primarily with the integration of the application with the Open API, specifically focusing on error handling and retry logic. - API Details: - The Open API I am working with is a RESTful API. I am looking for someone who is experienced with Dotnet core and has a strong understanding of RESTful APIs. Prior experience with error handling and retry logic in API integration is a plus. Your help will be invaluable in ensuring the final product is robust and reliable.
Kérjük, regisztráljon vagy jelentkezzen be a részletek megtekintéséhez!
...Amazon PAAPI, eBay API, or AliExpress product data extraction. Knowledge of automation tools like Zapier or Make (Integromat). Strong understanding of affiliate marketing workflows. Preferred Skills: Experience with Python or other scripting languages for API integrations. Knowledge of Odoo’s XML-RPC or for custom integrations. Ability to suggest and implement scalable solutions. Budget: Open to discussion based on experience and proposed solution. Timeline: ASAP If you have the skills and experience to deliver this project, please submit your proposal with: Examples of similar projects you’ve completed. Your proposed approach and tools. Estimated timeline and cost....
I am in need of a freelancer that can assist me with copying data from a protected Excel worksheet to a new, unprotected spreadsheet. Details: - I do not have the password to the protected worksheet - I can edit the worksheet, but cannot remove the protection - I need all data transferred from the protected worksheet to the new spreadsheet Ideal skills for this job would include proficiency in Excel, data entry, and an understanding of data confidentiality. As I cannot remove the protection, the freelancer will need to handle this task with discretion and professionalism.
...me identify trends in our QI project data. This will involve working with an Excel spreadsheet sourced from Redcap data. It is a NICU breast milk QI project. Data collection includes: Mother's age, mother's race, infant gestational age, insurance type, Breast pump useMilk volume at 3 different time points, volume goal of 500ml/day, Lactation clinic appointment. Scatter plot, run plot, effects of intervention: Yes/no lactation appointment attended, and does this correlate with milk volume. Key Responsibilities: - Analyze data to identify trends related to process improvements - Present findings in an accessible and clear manner Ideal Skills and Experience: - Proficiency in data analysis, particularly with Excel - Experience with QI projects - Ability to...
...Ideal Skills & Experience: Strong project management and organization skills. Experience with branding, marketing, and social media management. Proficient in financial tracking tools like Excel or Google Sheets. Familiarity with website development, online payment systems, and POS systems. Great communicator and skilled at keeping others on task. Resourceful with research and able to present clear recommendations. Scope & Budget: Scope: Ongoing, with a focus on the gym setup and other key projects in the first few months. Estimated Hours: 15–20 hours per week to start, with the potential to scale up. Budget: Open to proposals (please specify your hourly rate or fixed-price options). Preferences: Experience Level: Intermediate to Advanced. Location: C...
I'm looking for a unique, custom design for my lake home. The key elements of this project include: - A design style that blends seamlessly with the natural lakeside environment - An open floor plan to maximize the use of space and encourage a free flow between different areas of the home The home should feature: - Large windows that offer stunning views of the lake and allow plenty of natural light to fill the home - main floor living with second floor guest space - attached garage with both lakeside and roadside access - maximum of 40 feet wide Ideal candidates for this project should have: - Extensive experience in home design, particularly with lake homes - Experience designing for small or narrow lots that maximize living space - A keen understanding of how to incorpor...
Freelance Opportunity: AP Script Expert for Excel Sheet Automation We are looking for a skilled AP Script Expert to help automate processes in Excel sheets for our business. The ideal candidate should have expertise in creating, editing, and debugging Google Apps Scripts to streamline data handling, calculations, and report generation. Requirements: Proven experience with Google Apps Script for Excel/Google Sheets automation. Ability to create custom scripts to automate repetitive tasks, manage data, and enhance productivity. Knowledge of integrating third-party APIs (if needed) with Google Sheets. Strong problem-solving and debugging skills. Effective communication and ability to meet deadlines. Scope of Work: Analyze the current Excel workflow and id...
...Status Updates: Requests should have statuses: Pending Under Process (after Engineering Manager approval) Completed Status changes should trigger notifications. Dashboards & Reporting: Basic dashboard with the following insights: Request counts (by status, department, and priority) Average lead time (from submission to completion) Filter requests by department, category, status. Export reports to Excel/PDF. Access Control: Only authorized roles can approve/reject requests. Unauthorized users should see appropriate error messages. Custom request forms based on department/role. Technology Preferences: Web-based (accessible via PC & mobile). Simple UI with minimal complexity. Hosted online for real-time access. Suggested stack: Node.js (), MongoDB (or simple JSON storage...
I am looking for a professional contractor to link my bedroom ensuite with my house via a covered walkway. The link does not require a door into the courtyard. Key Specifications: - Type of Connection: The connection should be a covered walkway with flat roof. - Material: The walkway should be constructed predominantly with glass or in wooden joinery or open to ideas. - Style: It should adhere to a modern aesthetic. The ideal candidate will have extensive experience in designing and constructing modern, high-quality glass structures. A keen understanding of safety standards and building regulations is essential. A portfolio showcasing similar projects will be advantageous. The successful bidder will be able to deliver a structurally sound, visually appealing internal walkway th...
We are looking for a Full-time independent Node/React js freelancer with the following skill set for one of our clients. SUMMARY: - Over 6.5 years of professi...Created Typescript reusable components and services to consume REST APIs using Component-based architecture. TECHNOLOGIES: Node.js | Angular | React.js | | Java script | TypeScript DATABASE SQL | PL/SQL| MySQL | PostgreSQL | MongoDB | Amazon DynamoDB PM TOOLS: GIT | SVN | JIRA Monthly Remuneration: INR 75-80K Duration : 3 Months with very high possibility for extension. You should be open for an interview with a highly technical CTO. Please apply with your complete profile & examples of your best work. This position is ONLY for Full-time freelancers based in India. Agencies please don't waste your & o...
I'm looking for a QuickBooks Online expert to assist with matching over 201 open bills to transaction ledgers. The task involves handling multiple currencies as well. Ideal Skills and Experience: - Proficiency in QuickBooks Online - Experience with bill matching - Familiarity with multi-currency transactions - Attention to detail - Timeliness and efficiency
I have a project which involves processing a spreadsheet of 4100 EANs. The primary task will be identifying the SKU and size from the data. The EANs are currently stored in an Excel (.xlsx) spreadsheet. - Skills Requirement: Proficiency in Excel and data mining is essential. Experience with SKU and size identification will be a significant advantage. - Task: Extract SKU and size information from the provided EANs data. Please note, the specific SKU and size information that needs to be extracted has not yet been defined. A flexible approach and readiness to adapt to evolving project requirements will be key.
13 Editable supplement labels in Photoshop files, fully open with all aspects editable.
I need assistance with an Excel file. The city name is currently located in the middle columns and needs to be moved to a different column. All of the data is in one sheet. The ideal freelancer for this project should have: - Proficient Excel skills - Attention to detail - Data management experience
I'm looking for an Excel expert to help with my homework focused on analyzing scientific data. The main goal is to conduct a thorough data analysis using various statistical techniques. Key Responsibilities: - Analyze provided scientific data using Excel - Apply various statistical analysis techniques Ideal Skills: - Proficient in Excel with strong data analysis skills - Experienced in conducting statistical analysis - Familiar with scientific data sets
...Operational analysis Which areas of operations do you want to focus on? - Balanced scorecard (BSC) of the given company based on template -> Which perspectives do you want to include in the balanced scorecard? - Financial, Customer, Internal processes, Learning and development perspective Extended description of the task: Describe the vision, mission, goals and strategies of in Excel 1. Describe the financial perspective of the company selected in point 1), taking into account the following indicators: profitability (2-3 indicators, e.g. ROA, ROE), debt (1-2 indicators, e.g. total debt ratio), liquidity (1-2 indicators, e.g. current liquidity), cash conversion period (1 indicator) and risk management (1-2 indicators). 2. Describe the perspective of the customer selecte...
I'm looking for an expert Java developer who can assist me with a project focused on creating a specific web application. This involves using Visual Studio Code (VSC) and developing weekly content to complete the assignment. Key Res...implementing user authentication and database interaction features. - Excellent content creation skills. - I have attached the assignment details (its in 3 parts), sot the students should be able to provide 3 submission. - I have attached the weekly contents in excel sheet. I will need you to be good in creating weekly contnets meeting the topic lsited in the excel sheet but at the same time implementing the skills and knowledge toward completing the assignment. Please only contanct me once you go through the assignment and the excel...
...tools (we prefer After Effects). - Ability to create custom graphics and storyboard designs. - Strong skills in adding music and sound effects to elevate the video. - A creative and collaborative mindset with attention to detail. - A portfolio showcasing your best work, particularly custom animated videos. WHAT WE PROVIDE - A detailed script and professional voiceover. - Clear instructions and open communication to ensure smooth collaboration. WHAT WE ARE LOOKING FOR - Individuals or teams with a passion for creating visually stunning, engaging animated videos. - Commitment to meeting deadlines and delivering high-quality work. - A willingness to establish a long-term working relationship for future projects. THE QUALITY WE EXPECT https://www
...Provide screenshots from theatre websites showing ticket prices and seating plans for verification. Include screenshots for different price ranges, days, and timeframes (advance, standard, last-minute). Show Name: Clearly state the name of the show from which ticket price data was collected. Note whether the show is a long-running production or a special/limited run (if evident). Deliverables Excel Spreadsheet Detailed table for each theatre showing: Ticket price ranges by seating category (premium, mid-tier, budget). Seating category proportions (estimated). Dynamic pricing variations (day-of-week, seasonal, and time-based trends). Show name for each dataset. Summary sheet for ownership groups with: Aggregated ticket price ranges. Pricing trends by group and time of purch...
...enter the details of a new opportunity Required fields: title (string) description (text) status (enum: Open, In Progress, Closed) customerName (string) opportunityType (enum: Help Request, Handover, Cover Request) startDate: (timestamp, applicable to Handover and Cover Request only) endDate: (timestamp, applicable to Cover Request only) createdAt (timestamp, auto-generated) updatedAt (timestamp, auto-generated) List Opportunities A table or list displaying existing opportunities Each item should show the title, status, customerName, type, and createdAt. In addition it should be possible to see the full details of an opportunity. Update an Opportunity A way to change an opportunity’s status (Open → In Progress → Closed) Bonus Features (Optional but Encourag...
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 need a professional who can help me extract data...POS system on a daily basis. This data extraction will specifically focus on orders, with an emphasis on breaking out taxes and fees separately instead of having them lumped together as 'fees'. Key Requirements: - Data needs to be extracted daily and made available for download from a secure server. - The extracted data must be formatted in Excel. Ideal Skills and Experience: - Proficiency in data extraction from Clover POS system. - Expertise in Excel for data formatting. - Experience with secure server data handling. - Ability to meet daily deadlines. Please note, the goal is to have a detailed, clear and precise breakdown of each order, with taxes and fees itemized separately. This is essential for my accoun...