Vba open close excel workbook word macroεργασίες

I have a data entry task that needs to be completed on my computer using TeamViewer. Requirements: - The data entry involves mixed data (text and numbers) from scanned documents. - The final format of the entered data should be in an Excel spreadsheet. Ideal Skills: - Experience in data entry is preferred. - Proficiency in Excel is crucial. - Familiarity with TeamViewer is a plus. - Attention to detail is key, as the data is coming from scanned documents.

I'm seeking a freelancer skilled in data analysis to help me prepare for an upcoming viva. The tasks will involve: - Data cleaning and preprocessing - Creating dashboards and visualizations - Running complex queries and reporting Proficiency in the following tools is essential: - Excel - Power BI - SQL Experience in these areas is crucial, as I need to demonstrate a solid understanding of advanced data analysis techniques during my viva. I look forward to working with someone who can help me master these skills and improve my chances of success.

I'm in need of a talented graphic designer who can create a sleek, minimalist logo, favicon for my website. Given the nature of the project, your p...project, your portfolio should ideally showcase a variety of minimalist designs, and you should have a keen understanding of how such logos can engage web users. Key Requirements: - Expertise in graphic design and branding, with a focus on minimalist styles - Understanding of web design principles and how logos function on websites - Ability to provide a range of color options, given that I'm open to suggestions - Strong portfolio with examples of previous logo designs, specifically minimalist ones - Excellent communication skills, able to understand and incorporate my feedback I will take time to review bids. I would need...

i have two of my suppliers websites that i need product data scrubbed and put into an excel sheet. All the images need to be saved to a file with product code label.

I'm seeking a detail-oriented freelancer to help with uploading auto parts to my Shopify website. The task involves: - Working from a product list with SKUs provided in both Excel and CSV formats. - Downloading product images and descriptions from a specified source. - Uploading the images and text into Shopify, creating product listings, and saving them as drafts. Skills Required: - Proven experience with Shopify product uploads. - Proficiency in managing and organizing product data using Excel and CSV files. - Strong attention to detail to ensure accurate uploads. Ideal Candidate: - Familiar with managing SKUs and product variations. - Can start immediately and complete the task efficiently. Deliverables: - All products uploaded and saved as drafts in Shopify. Ple...

I'm seeking a professional to create a Google survey/form for customer feedback. - The survey should include multiple types of questions: multiple choice, open-ended, and rating scale questions. Ideal Skills: - Experience in market research and customer feedback analysis. - Proficiency in creating user-friendly surveys on Google platform. - Excellent understanding of formulating diverse question types to gather comprehensive feedback. Looking forward to receiving your proposals. Thank you!

I'm looking for a professional with expertise in ANSYS to help me extract data related to deformation and displacement from the program. The extracted data should be delivered in Excel format. Please note, I might require some post-processing depending on the quality of the raw data.

...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...

...the data, where applicable. What I’ll Provide • Detailed step-by-step instructions for each task or project. • Guidance on methodology and tools to use. • Feedback to refine the process and expectations. What You Bring • Strong experience with stock market analysis and financial tools. • Familiarity with financial metrics like P/E, EPS, ROE, and others. • Proficiency with platforms like Excel, TradingView, or other data analysis tools. • Ability to quickly adapt to new tools or workflows. • Excellent communication and organizational skills. • Ability to meet deadlines and deliver high-quality work consistently. Preferred Qualifications • Previous experience in financial research or investment analysis. • K...

THE MOST IMPORTANT THING is understanding the data and good English communication skills. I have an existing project that requires a variety of data cleaning, streamlining, and analysis. The ideal candidate will be proficient in Excel Macros and VBS, with coding skills to tackle complex tasks. If any humans are actually reading this - I am looking for someone I can communicate well with and who can talk through a solution with me and then implement it. Will start with a simple data transformation operation to see how we work together. I will offer the winning bidder an hour of paid time to discuss my project and see how we communicate and if we agree I will assign a task to begin. Thank you

https://www.freelancer.com/projects/excel/Excel-Tax-Rate-Reversion-Formula/proposals

In Microsoft Access database, I need some VBA to attach 3 forms to 3 SQL queries that already exist. I've started the forms, but they are not complete. Each query requires input from the user. I want the input to be captured on one form with the input fields required. On click of the button causes an Event that triggers the SQL with using the data input from the form. Key Requirements: - User Input: dropdown menus, checkboxes, and text fields. - Dropdown Menus: 3 or more dropdown predefined. - Event Triggering: SQL query using the data input from the form. Skills and Experience: - VBA - Microsoft Access - User-friendly forms - SQL (not required, but could be helpful)

As a student seeking online work, I'm looking for a freelancer proficient in data entry, particularly in managing spreadsheets. Key Responsibilities: - Oversee and manage various spreadsheets - Generate reports from the data Ideal Skills: - Strong attention to detail - Proficient in Excel and other spreadsheet software - Experience in data entry and report generation Looking forward to your proposals.

...hyper-realistic 3D rendering for the hero section of my website. The animation should depict a user scrolling on their mobile phone in a dark setting, with a warm glow coming from the device. The animation should convey engagement, with small values like +1, +4, -1 popping up in sync with user interactions. Key Requirements: - The style of the 3D rendering should be photorealistic. - The angle should be a close-up of the phone screen and hand. - The color scheme should consist of warm tones (yellow, orange) emanating from the device. This animation is intended for a recommendation engine, illustrating the addictive potential of my customer’s service. Ideal candidates should have a strong portfolio in photorealistic 3D animations and a good understanding of creating engag...

I'm seeking an experienced architect to create sealed plans for a very basic open retail storefront under 800 sq ft.

I have financial data in an Excel spreadsheet that needs to be mail merged into a Word document. This document will then be converted into a PDF following a pre-defined template. Ideal Skills and Experience: - Proficient in Microsoft Excel and Word - Experience with mail merge - Able to convert documents to PDF - Attention to detail for template adherence This is a straightforward task for the right candidate. Please do not attempt to calculate or process the data prior to merging.

I'm in need of an Excel expert to create a dashboard that links information from 2-4 external workbooks. The external workbooks contain data related to tracking our key performance indicators (KPIs), specifically focusing on operational efficiency. Key Requirements: - Link 2-4 external workbooks to a central Excel dashboard - The external workbooks contain data on production output and employee productivity Ideal Skills: - Proficient in Excel, particularly in creating dashboards and linking workbooks - Experience with KPI tracking and understanding of operational efficiency metrics - Attention to detail to ensure accuracy in data representation and tracking This project will enable us to effectively monitor our operational efficiency, providing us with insights...

I am looking for a professional to assist with my bookkeeping tasks using Microsoft Excel. This will involve data entry and organization, managing accounts payable and receivable, and performing bank reconciliations. Ideal skills for this job include: - Proficiency in Microsoft Excel - Experience in bookkeeping and managing accounts - Attention to detail for data entry and bank reconciliation

I'm in need of a seasoned professional who can assist me in procuring low-cost multi-layer printed circuit boards based on an existing Gerber file and an Excel file bill of materials. Phase I: - Obtain a cost estimate for the PCBs and the components based on the provided files. Phase II: - Evaluate the delivered PCBs. - Proceed with the assembly of the components. My technician will handle the testing and reviewing of the assembled boards. Ideal Skills: - PCB sourcing - Cost estimation - Assembly - Multi-layer PCB expertise - Supplier negotiation

Spécialiste en SIG, Cartographie et Architecture Je suis Géraud AÏDOFI FINANGNON, expert en ArcGIS, QGIS, et ArchiCAD, avec une maîtrise des outils Word et Excel. J’accompagne mes clients dans leurs projets de cartographie, d’analyse spatiale et de conception architecturale, tout en offrant des services bureautiques de qualité. Services proposés : • Réalisation de cartes et analyses SIG. • Plans et conceptions architecturales. • Gestion et traitement de données sur Word et Excel. Faites-moi confiance pour vos projets professionnels et collaborons dès aujourd’hui !

We're looking for experienced site developer who was engaged in projects related to social media sites ( Wordpress not suitable). Programming language of your professional choice. Project should be done within 2-4 months. We expect to receive complete website, source code, documentation, and quick tutorial on how to moderate the site. We already have domain and designe for desctop and mobile. We may need help wuth updates in the future.

I'm looking for an expert in Excel who can help me build a comprehensive spreadsheet to track my business expenses from multiple sources including bank accounts, credit cards, and receipts. Key Features: - Daily updates: The spreadsheet should be designed to accommodate daily expense tracking. - Duplicate charge detection: The system should help identify duplicate charges automatically. - Note-taking: I need to be able to record notes directly in the spreadsheet. - Categorization: All expenses need to be categorized so I can sort and see total costs for different categories over different time periods (time periods should be customizable). Ideal Skills: - Proficiency in Excel: You should be extremely comfortable with Excel and be able to create complex formulas...

I'm looking for a freelancer who can create a professional Word document template for a report. The template should be sophisticated and suitable for a professional setting. Key elements of the template: - Cover page - Custom multi-level lists - Collapsible titles - Brand fonts and colors - Formatted tables and figures - Rich Text content control on Cover Page - Rich Text content control in Header & Footer The ideal candidate should have experience in creating Word document templates, with a keen understanding of professional design principles. They should be able to incorporate specific elements such as brand fonts and colors, and logo placement effectively. Familiarity with using Rich Text content control is also a plus. Ultimately, I need a template that is n...

I'm looking for a...looking for a web scraping expert who can extract wine data from Tajan. The data to be scraped includes: - Bid prices: Picture 1 - Auction dates: Picture 1 - Wine details: Picture 2 See an example as an attachment Website: Needed data: all wine events from March 2020 until the end of 2024 Auction item: Wine The scraped data should be delivered in a Spreadsheet (Excel/CSV). A snippet of the data from 2013 is attached. This is a one-time project, so I do not require ongoing data collection. Ideal skills for this project include: - Proficiency in web scraping tools - Experience with data extraction - Ability to present data in a clear, organized manner Please provide examples of similar projects you've completed in your proposal. Thank you!

...should be incorporated within or around the circle. Symbolism: Digital Creativity: The logo should subtly represent digital creativity and innovation, possibly through abstract shapes or lines within the circle. Excellence and Leadership: The design should convey a sense of excellence and leadership, aligning with the brand's values. About Our Company: Mission: Rexo Studio aims to lead and excel in the digital world by providing reliable, expert, and optimized digital services that elevate our clients' online presence. Services: We specialize in graphic design, web design, and social media marketing. Our team combines creativity with technical skills to deliver innovative and effective solutions. Values: Our core values include reliability, expertise, excellence, an...

Hi, Sumaya - would you be able to review anothe impact report for me? I'd need it tomorrow morning. This one would be easier, it's just a word document and you can review with track changes and add comments when needed (no need to explain each single adjustment?

I am looking to enhance my current Android mobile application. The specifics of the enhancements haven't been determined yet, so I am open to suggestions based on your expertise and experience. Ideal skills for this project include: - Android app development - UI/UX design - Performance optimization - Feature integration - E-commerce, Social Networking or Productivity app experience I look forward to seeing your proposals.

Job Title: Commission-Based Sales Agent for Wholesale & Retail Partnerships Description: I’m looking for an experienced sales agent to help grow my e-commerce brand, Orbis Earplugs, by securing wholesale buyers, subscription box deals, and retail partnerships. Orbis offers high-quality, certified earp...commission-based role with negotiable rates up to 30% per sale. You can work flexibly and on your own schedule. Candidates with experience in B2B sales, CPG, or existing networks in wholesale or retail are strongly preferred. Key Responsibilities: • Identify and secure wholesale buyers, retailers, and subscription box partners. • Build and manage a B2B sales pipeline independently. • Negotiate deals and close sales. Let’s discuss how we can work toge...

Word Macro to create dependent forms which did not get completed

I'm seeking help to apply for multiple DevOps job openings in the technology sector, primarily on platforms like LinkedIn and Indeed. I am open to remote roles as well as positions in any location globally. Key Requirements: - Proficient understanding of the DevOps role and its requirements. - Experience in job application processes on LinkedIn and Indeed. - Ability to tailor applications to increase chances of getting interviews. - Understands the technology sector and its job market. - Excellent communication skills to maintain updates. Your task will be to apply my resume to suitable openings, ensuring a broad yet targeted approach to maximize opportunities for interviews.

I'm looking for someone who can help me develop a Microsoft Word questionnaire that is dynamic. The document will need to have conditional logic to populate and hide additional content/questions based on previous answers. The word document will have the functionality to be converted into a pdf document with all relevant fields hidden/shown on the pdf as needed. Key Requirements: - Expert in Microsoft Word with experience in creating dynamic documents. - Ability to implement conditional logic to generate supplemental questions based on responses. - Proficient in creating a variety of question types including text input, multiple choice, and yes/no. The dynamic features of the document will be triggered by checkbox selections. I am looking for someone who can mak...

I'm seeking a skilled data processing programmer to help transform numerical data from CSV and Excel files. The primary focus of this task will be on data transformation. Ideal candidates should: - Have a strong proficiency in programming languages suitable for data processing such as Python or R. - Be experienced in working with CSV and Excel files. - Have a solid understanding of numerical data and data transformation techniques. Your expertise will help in converting raw data into a more useful format. Please bid if you have the necessary skills and experience.

...experiencia en VBA para Excel que pueda desarrollar un macro que procese múltiples archivos XML de comprobantes electrónicos de Ecuador (facturas, retenciones, notas de débito y crédito), genere reportes en Excel y convierta los XML a archivos PDF con formato legible. Requerimientos: Soporte para múltiples tipos de comprobantes electrónicos: Facturas. Retenciones. Notas de débito. Notas de crédito. Reportes a generar: Reporte General: Totales y subtotales de cada tipo de comprobante. Reporte Detallado: Listado detallado de los ítems comprados o servicios adquiridos. Conversión a PDF: Convertir los comprobantes electrónicos (XML) a archivos PDF con formato legible. Personalizaci&...

Segretaria da remoto con le seguenti caratteristiche: - 3 ore al giorno - spirito di gruppo - buona conoscenza di programmi di fatturazione (business in cloud) - solare ed empatica - dinamica e disinvolta - italiana di madrelingua italiana - conoscenze di tabelle excel

I'm looking for a freelancer who can build an Android application that uses Traccar - the open-source software location tracker - to track GPS mobile phone numbers. Key Requirements: - The application should provide real-time location tracking functionality - No user authentication is needed, making the app straightforward and easy to use Ideal Skills: - Proficiency in Android development - Experience with GPS tracking software, preferably Traccar - Understanding of real-time data processing Please note that this project does not require any social media integration or email authentication, keeping the user interface simple and accessible. Your bid should reflect your understanding of the project and your ability to deliver a high-quality product in a timely manner.

I'm in need of a skilled marketing agent or broker with experience in the real estate sector. The goal is to sell a commercial land plot I own in Bangalore. Key Details: - The target market is primarily real estate developers. - The land is located in a prime spot in Electronic City, close to numerous industrial companies. - A prominent selling point is the land's proximity to key transportation hubs. Ideal Skills and Experience: - Proven track record in selling commercial real estate. - Excellent networking skills, particularly within the real estate developer community. - Strong marketing and negotiation skills. - Experience highlighting and selling specific land features. I am looking for a professional who can effectively communicate the value of this land and reac...

I'm seeking a VBA expert to help me extend my current data collection project. The task involves: - Collecting soccer fixtures from Coral, including odds for home, draw, away, over/under and both teams to score markets. - Integrating this new data into my existing Excel file, which currently collects the same data from two other sports websites. The data from Coral is similar to the other sites, so no special handling is required. The ideal freelancer should have extensive experience with VBA and data collection, as well as a keen attention to detail.

...comprehensive report summarizing findings, assumptions, and recommendations. Present financial models in an easily interpretable format for stakeholders. Key Deliverables: Financial feasibility model in Excel or equivalent software. Detailed investment and cash flow projections with supporting assumptions. Sensitivity and scenario analysis results. Executive summary with key insights and actionable recommendations. Qualifications: The ideal candidate should possess: Expertise in financial modelling for real estate projects. Strong knowledge of residential real estate market dynamics. Proficiency in Excel and financial analysis tools. Demonstrated experience in conducting feasibility studies for comparable projects. Engagement Timeline: The financial feasibility mode...

Sou dentista e preciso de uma tabela que será apresentada com orçamento para pacientes. Com intuito de padronizar a nomenclatura e agilizar o processo, preciso que o valor apareça de forma automática ao preencher o procedimento. Essa tabela precisa ter um bom design e possuir um tamanho imprimível. Podendo ser usada o moledo abaixo

I am looking for an Excel expert to assist with data analysis tasks. I already have the data for analysis and need help in identifying trends and making predictions based on the data. The desired outcome is to gain insights from the data for decision-making purposes. Ideal skills and experience for this job include: - Strong proficiency in Excel and its formulas and functions - Experience in data analysis and visualization - Knowledge of statistical analysis techniques - Ability to interpret and communicate findings effectively

I'm seeking a skilled developer to create a Bz/Sz indicator specifically for TradingView. This will be a private, restricted access indicator. Key Requirements: - Expertise in TradingView's Pine Script language. - Proven experience in dev...seeking a skilled developer to create a Bz/Sz indicator specifically for TradingView. This will be a private, restricted access indicator. Key Requirements: - Expertise in TradingView's Pine Script language. - Proven experience in developing custom indicators. - Understanding of Bz/Sz indicator functionality. Please note, I have not specified additional functionalities for the indicator, but I am open to suggestions based on your expertise. I am primarily looking for a developer who can deliver a high-quality product that meets ...

I need a comprehensive web application for order management with a primary focus on order tracking. The application should be capable of catering to both internal staff and customers. Customers will scan the QR which will open the menu from which they can place the order. The admin (owner) will be able to view all the orders on the screen and update the status. Key Features: - Real-time updates: The system should provide real-time tracking of orders to users. - Order history: Users should be able to view the complete history of their orders. - Automated notifications: The system should automatically notify users about the status of their orders. Ideal Skills and Experience: - Proficiency in web application development. - Prior experience in creating order tracking systems is a plu...

I am looking for a proficient MERN stack developer to create a dynamic and robust website. As the specific purpose of the website hasn't been defined yet, I am open to suggestions based on your experience and expertise. The website could potentially be an e-commerce platform, a blog/content site, or a business/profile site. Key Skills: - Deep understanding of the MERN stack (MongoDB, , React.js, Node.js) - Excellent JavaScript programming skills - Proficient in building responsive and user-friendly interfaces - Experience in developing scalable web applications - Good understanding of RESTful APIs As of now, there are no specific integrations required for the website, nor will it necessitate user authentication at this stage. However, the ideal candidate should be able to imp...

I'm looking to create a WooCommerce multivendor site. The specifics on product types and vendor functionalities are not yet determined, so flexibility and experience in handling various scenarios will be a big plus. Key Skills: - Extensive exp...product types and vendor functionalities are not yet determined, so flexibility and experience in handling various scenarios will be a big plus. Key Skills: - Extensive experience with WooCommerce - Prior work on multivendor websites - Good understanding of both physical and digital product handling - Familiarity with vendor management systems - Knowledge in setting up various payment systems I am open to suggestions and professional input on how best to set this up. Please provide examples of similar projects you have completed in...

I am looking for a freelancer who can modify my dog file. The modifications will be focused primarily on the pier section. While the specific changes to the pier have not been determined yet, I am open to suggestions for enhancements. Ideal skills for this project include: - Proficiency in file modification software - Creative thinking for potential pier improvements - Attention to detail to ensure all modifications are accurate. If you're interested in this project, please provide examples of similar work you've done in the past.

General Description The main objective is to automate betting within a specific tab of a mobile application (Android and iOS). The system should: Search for odds within a predefined range in the application interface. Place bets with a set amount, ensuring no bets are placed if there is already an open one. Continue repeating the process, searching for new odds and avoiding duplicate bets. General Considerations No API available: Automation will rely on techniques such as OCR, scraping, or similar methods to extract information directly from the app’s screen. Compatibility: The tool must work on both Android and iOS devices, operating in the background on the same mobile device. Access Restrictions: The development requires functional access to the mobile application, which...

Read current economic data and forecasts from and transfer them to an Excel table. See appendix for a list of indicators. Countries: USA, Europe, UK, Australia, New Zealand, Switzerland, Canada and Japan. Only the first page of the Excel sheet will be important to me. I would like to see the indicator(s) from the selected countries superimposed in a diagram using a checkbox. updating the data from the website should be possible at "the push of a button"

I'm looking for a PowerShell script that can open Microsoft Teams and make a call to a specific account. The script should log into Teams automatically using credentials stored within the script. If Teams is already connected, it should bypass the need for credentials. Key Requirements: - The script should create a CSV file with details of the call after each attempt. Ideal Skills: - Proficient in PowerShell scripting - Experience with Microsoft Teams automation - Knowledge of creating and manipulating CSV files in PowerShell. Please note, the credentials for the Teams account will be stored in the script.

I'm looking for an expert in sales and partnership strategies, specifically focusing on B2B part...goal of these partnerships is to increase our market reach. Ideal Skills and Experience: - Proven track record in B2B partnership development - Strong sales acumen - Excellent networking skills - Ability to devise and implement effective partnership strategies - Experience in market expansion initiatives - Knowledge of various industries and sectors Your role will be to identify, approach and close potential B2B partners, both clients as well as agents and franchisees, that align with our business objectives and can help us reach untapped markets. You will also be responsible for creating and proposing partnership strategies that are mutually beneficial and can drive growth fo...

I'm in need of a skilled Data Entry Operator. The job involves working with text data from digital files, specifically Excel spreadsheets. You will be responsible for entering data into various computer databases and maintaining effective record keeping. Ideal Skills: - Proficient in Excel - Excellent attention to detail - Strong organizational skills - Experience with data entry no