Optimizing excel vba code työt
FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...
Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I'm looking for a MATLAB programmer with expertise in developing advanced algorithms. The ideal candidate should be able to develop a program based on the water cycle algorithm for optimizing a given function.
...We do not currently have a Google Ads account set up. Goals: - Increase online sales through effective Google Ads campaigns - Configure Google analytics manually by setting java code on the website - Successfully configure Google ads with the flyer provided by us, create a landing page on our website and host it. Target Audience We are IT coporate and our target audience is B2B in India and Middle East Skills and Experience: - Proven experience in setting up and managing successful Google Ads campaigns - In-depth knowledge of Google Analytics to track and analyze campaign performance - Expertise in optimizing ads and targeting to maximize online sales - Ability to conduct keyword research and create compelling ad copy - Familiarity with conversion tracking and remark...
Seeking a skilled and experienced Data Analyst to sift through unspecified data sources. As the data type, desired insights, and current storage system have not been specified, I am looking for someone highly flexible and adept at handling all types of data, formats, and analysis needs. Ideal Skills and Experience: * Proficiency with Excel, database, BigQuery, JSON, and CSV file formats * Experience working with sales data, financial data, and customer data * Ability to identify sales trends, perform customer segmentation, and analyze profitability Please note that the specifics will be provided upon project commencement. We look forward to hearing from data analysts who can adapt to different data types and uncover valuable insights.
I'm in need of a professional wh...experience in this area is a must. Key requirements: - Set up a directory website using Brilliant Directory software - Implement SEO strategies to the website - Ensure the website is SEO-friendly - Optimize the website for: - Keyword optimization - Local SEO enhancements - On-page SEO improvements Ideal Skills: - Proficiency in Brilliant Directory software - Proven experience in creating and optimizing directory websites - Strong SEO knowledge and experience in improving SEO performance - Ability to meet the requirements of the project in a timely and efficient manner. If you have the necessary expertise in Brilliant Directory and SEO, and you're confident you can deliver a user-friendly and SEO-optimized directory website, then I'...
I'm working with an existing Excel spreadsheet that contains date data. I need help with sorting and filtering these dates. PROBLEM: I have different data set (mm/dd/yyyy and dd/mm/yyyy) in the same column exchanging every 100rows or so...data set is about 70000rows I dont want a solution I want you to teach me how to resolve this because this is something ill do for some time now and i need to know how i can do it by myself. Key Requirements: - Sorting and filtering the dates in the spreadsheet effectively. - Ensuring the sorted and filtered data can be used for additional calculations within the same spreadsheet. Ideal Skills and Experience: - Advanced proficiency in Excel, with a strong understanding of date functions. - Previous experience working with large data...
Have video n main source code. Not able to get output. Data download from api
...startups is crucial. Next to this, a strong understanding of digital marketing and lead generation tactics is required. • Tone of Voice: The copy should embody a corporate and professional tone. The content must speak to industry professionals, therefore, a strong understanding of technical language and jargon, adapted to a professional tone is key. • Task: Your task will consist of reviewing and optimizing the existing translation, ensuring that the messages are effective and compelling enough to generate leads among the target audience. • Skills: Excellent Spanish writing and editing skills are critical. Knowledge of SEO targeted content optimization will be an asset. If you understand the balance between technical complexity and engaging storytelling in a pro...
I'm seeking a skilled freelancer to assist me with basic data analysis in Excel. Ideal Skills and Experience: - Proficiency in Excel - Experience with basic formulas and functions - Strong attention to detail - Good communication skills
I'm in need of an experienced and skilled Node.js developer to handle various maintenance tasks on a full-time and long-term basis. Key Responsibilities: - Regular maintenance tasks, including fixing bugs and errors, updating libraries and dependencies, and optimizing performance. Ideal Candidate: - Proficient in Node.js with a solid track record of similar projects - Previous experience in handling maintenance tasks - Strong problem-solving skills - Good communication skills - Ability to work full-time and commit to a long-term engagement Please share your experience in your proposal. I prefer instant messaging for communication.
I'm seeking an expert in performance marketing with proficiency in social media and search engine marketing. The goals of this project are: - Increase website traffic - Boost conversion rates Key responsibilities will include driving traffic and optimizing conversions for our highly targeted local audience. Required skills and experience: - Familiarity with performance marketing, conversion, and online customer acquisition - Experience with A/B and multivariate experiments - Proficient in social media marketing and search engine marketing - Knowledge of local audience marketing strategies Successful bidders should have a proven track record of increasing website traffic and boosting conversions. If you have a knack for improving ROI through performance marketing, I want ...
I'm seeking a talented designer who can make a 3D rendering for my rental units. Your tasks will be: - Create a visualization rendering of individual units. The central focus should be the interiors. - Bring the renderings to life with high attention to det...renderings to life with high attention to detail including lighting, textures, and shadows. Ideal skills: - Strong proficiency in 3D modeling and rendering software. - Demonstrable experience in creating high detailed 3D renderings focused on interiors. - Ability to adhere to a specific design brief and create visually appealing and realistic renderings. This project will be a great fit if you excel in creating lifelike 3D representations and have a keen eye for detail. I look forward to seeing your previous work in ...
...Management, including formal definitions and simplified definitions. These definitions must be aligned to Parent Company's terminology. 2. Provide a diagram that explains the desired lifecycle of IT Asset Management and how Cybersecurity, ICT Operations, Data office and Business Unit fit into this flow via clear RACI. This must aligned to Parent Company's lifecycle descriptions. 3. Complete an excel based GAP analysis of desired Asset Management state vs current, based on Parent Company's expectations and standards. 4. Define a recommended plan for addressing these GAPS in a viable way. The ideal candidate for the project should: - Possess vast experience in IT asset management - Have intricate knowledge of Documentation Process and Workflow diagram - Have proven...
...Updates: I need someone to ensure the website is running smoothly and is up-to-date. - Website Analytics Tracking: It's very important for me to keep track of the website's performance. Therefore, I need someone who can provide insights on user behavior and help me make data-driven decisions. In addition to these tasks, I'm looking for someone who can also provide SEO help. This may include optimizing the website's structure, content and more. Ideal skills and experience for this project include: - Proven experience in website management, preferably with subscription-based websites. - Strong background in SEO and experience in implementing strategies that drive traffic and improve visibility. - Proficiency in analytics tools to help me make informed decisio...
I'm in need of a profess...experience in this area is a must. Key requirements: - Set up a directory website using Brilliant Directory software - Implement SEO strategies to the website - Ensure the website is SEO-friendly - Optimize the website for: - Keyword optimization - Local SEO enhancements - On-page SEO improvements Ideal Skills: - Proficiency in Brilliant Directory software - Proven experience in creating and optimizing directory websites - Strong SEO knowledge and experience in improving SEO performance - Ability to meet the requirements of the project in a timely and efficient manner. If you have the necessary expertise in Brilliant Directory and SEO, and you're confident you can deliver a user-friendly and SEO-optimized directory website, then I'...
I'm in need of a talented freelancer to help optimize the speed of my WooCommerce online store. Specifically, I'm looking to enhance the loading time of the homepage, which is currently performing well, but can be further improved. Key Requirements: - Expertise in optimizing WooCommerce sites, particularly focusing on improving page loading speed. - Proven experience in speeding up homepage load times without compromising the design or functionality of the site.
I am looking for a proactive and detail-oriented lead generation assistant to help me with data research and email outreach/follow-up. The main focus will be on the B2B sector. Key Responsibilities: - Conducting thorough data research to find relevant contacts...research to find relevant contacts and organizations in the B2B sector - Managing email outreach and follow-up with these leads Ideal Skills and Experience: - Proficiency in data research and collection to identify potential leads - Experience in email outreach and follow-up to engage and nurture leads - A good understanding of the B2B industry and its dynamics - Ability to deliver leads in an Excel/CSV format If you have a track record in delivering high-quality B2B leads and can assist with these tasks, I'd like to...
My company and I are looking for an experienced freelancer to develop an Excel tool for Electrical energy savings. The tool should be able to calculate energy savings, graphically represent data, and compare different scenarios all according to the formulas and calculations I will provide. We prefer to communicate technical details via telephonic discussion. The freelancer should have experience creating similar tools and should present a proposal for development.
croatian text below (please translate it in your language if necessary) Mi trazimo freelancer-a koji ce definirati i izvesti tendera u Europi za igradnju jedne kuce sa tri stana i 3 PGM u Hrvatskoj - Grad Zagreb. Sudjelovanje pri raspisu natječaja i ugovaranju radova uključuje: - Priprema natječajne dokumentacije (nacrta i troškovnika) - Ispitivanje i vrednovanje p...u Hrvatskoj - Grad Zagreb. Sudjelovanje pri raspisu natječaja i ugovaranju radova uključuje: - Priprema natječajne dokumentacije (nacrta i troškovnika) - Ispitivanje i vrednovanje ponuda te izrada usporedbe cijena prema pojedinačnim poslovima - Sudjelovanje u pregovorima s ponuđačima i izrada prijedloga za ugovaranje - Sudjelovanje pri odabiru izvođača Format predaje: Dokumentacija u excel...
To create a canvas powerapps screens similar to the Excel provided to Florian.
I need a skilled Power BI developer to support me with key aspects of my project. Your tasks will include: - Data modeling and visualization - Creating insightful dashboards - Generating detailed reports You'll need to connect and work with data from Excel spreadsheets and SQL databases. So, competency and experience with these data sources is crucial for this project. I'm looking for an intermediate Power BI developer. You should have a solid understanding of Power BI functionalities and the ability to translate data into clear visual insights.
We are seeking a skilled individual who is proficient in using the Google Play Console to publish apps. As our app developer, you will be responsible for uploading, managing, and optimizing our app listings on the Google Play Store. Responsibilities: 1. Utilize the Google Play Console to upload new app versions, including APK files, screenshots, descriptions, and other necessary assets. 2. Ensure compliance with Google Play policies and guidelines to prevent app rejection or suspension. 3. Manage app metadata, including titles, descriptions, keywords, and categories, to optimize visibility and searchability. 4. Monitor app performance metrics, including downloads, ratings, and reviews, and implement strategies to improve user engagement and retention. 5. Collaborate with the devel...
As one aiming to maximize my productivity, I'm in need of a proficient data entry professional who can assist in data transcription, processing, and validation. This task revolves around: - Handling a medium scale data volume, approximately between 100-1000 records. - Processing data I have currently stored in an Excel Spreadsheet. Freelancers with the following skills are ideal for this job: - Expertise in Excel and data entry practices. - Experience in data validation. - Strong attention to detail. Your primary responsibility would be to ensure the accuracy and usefulness of my data efficiently. Your proficiency and speed are key to the success of this project.
My project revolves around the conversion and enhancement of specific JPEG images. The enhancements needed pertain to retouching, color correction, background removal in addition to change of format. Ideally, I require someone skilled in photo editing and proficient in using Excel, to transcribe these reformatted images into an Excel document. I would like my JPEGs converted into the Excel , if you have a keen eye for detail and the necessary expertise, I would love to hear from you.
I'm in need of a digital marketing assistant to help with social media management and SEO tasks. Key Responsibilities: - Social Media Management: Primarily focusing on Facebook and Instagram. You'll need to schedule posts, engage with followers, and track performance metrics. - Search Engine Optimization (SEO): Your role will involve optimizing the website to increase traffic and generate leads. This will include keyword research, on-page optimization, and link building. -Google Ad Campaign management Ideal Candidate: - Proven experience in social media management and SEO. - Knowledge of Facebook and Instagram's algorithms and best practices. - Familiarity with SEO tools like Google Analytics, SEMrush, and Moz. - Excellent communication and analytical skills. - Ab...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
I need assistance with data cleaning, data analysis, and pivot table creation in Excel. Project specifics: * Work with a large dataset containing more than 1000 rows * Data type: Mixed (both numerical and text) Ideal freelancer skill set: * Proficiency in Excel data management and analysis * Proven experience with pivot tables * Strong understanding of data cleaning processes * Attention to detail and maintaining accuracy Great results in this complex project will open up opportunities for longer-term work in our data management and analysis team. Are you the Excel expert I'm looking for?
...developer capable of creating a tool to store data in bulk and automatically remove duplicates each time new data is added to the existing database. Storage of large datasets: The tool should allow for storing a large quantity of data. Duplicate removal: It should be possible to remove duplicates in the Excel files to maintain a clean and organized database. In addition to these features, it would also be necessary to be able to edit data in the tool and export the changes made to an Excel file. Furthermore, an archiving feature would be desirable, allowing for downloading of the used data for future reference. I would appreciate it if you could confirm whether you are able to develop such a tool and provide me with a quote at a reasonable rate. Thank you in advance fo...
I'm seeking a proficient AI researcher. The main focus is to research all the AI tools and suggest best tools for the following activities, 1. PPT, Excel & word document creation 2. Prompt engineering for Chatgpt & similar 3. Project management : Auto schedule creation, task tracking, followups, resource management, report generation, auto reply for emails, risk management 4. Sentiment analysis of text 5. Engineering document creation : System Requirements, SW Requirements, Architecture creation, software detailed design, software coding, Test case creation. 6. Images, Animation creations Your primary task will be to understand different AI tools, create a list of all the AI tools, its corresponding usage for both free & paid tools. The industry targeted is automo...
I am seeking an experienced freelancer to assist in setting up and optimizing a Google My Business profile for my service-oriented business. This project involves the comprehensive management of key components including: - Creation of a detailed and appealing business profile. - Optimization of business information to increase visibility and appeal to potential clients. - Managing and responding to customer reviews effectively. Ideal candidates should have hands-on experience in the setup and management of Google My Business profiles, and a deep understanding of the service industry. Your application should highlight relevant past work experiences and the strategies you would use to achieve optimal results for this project. Let's take my business to a higher level of visibili...
We are seeking a talented full stack develop...work in a fast-paced, collaborative environment. Preferred Qualifications: Previous experience with invoice generating applications or financial management systems. Familiarity with cloud-based solutions and deployment platforms such as AWS or Azure. Understanding of agile development methodologies and version control systems like Git. Ability to provide valuable insights and suggestions for optimizing application performance and scalability. How to Apply: Interested candidates are requested to submit their proposals along with examples of previous projects showcasing both front-end and back-end development expertise. Please include the phrase "FullStackInvoice" at the beginning of your proposal to ensure you've read th...
...the restaurant. You must be proven and able to show samples of work that has got results consistently. Your responsibilities will include: - Designing and creating eye-catching and engaging Image, Video and Carousel ads that effectively communicates our brand voice. - Implementing strategic targeting to reach local residents and attract them to our restaurant. - Tracking ad performance and optimizing for maximum results. Ideal Skills and Experience: - Expertise in Facebook advertising. - Experience in designing attractive and effective ads. - Excellent understanding of ad targeting. - Proven track record of increasing brand awareness through Facebook ads. I'm particularly interested in freelancers who can demonstrate successful campaigns they've run for similar b...
We are in search of a meticulous researcher adept at data compilation within Excel sheets. Your primary task will involve sourcing, researching, and organizing data for a designated list of company names provided. The role entails gathering contact details and accurately inputting them into the provided spreadsheet under relevant column headings such as email, phone number, address, country, buyer name, buyer Linkedin profile link and buyer contact number. The scope of the project requires data collection for a minimum of 1000 companies, predominantly from the United States, along with other specified countries. Upon data entry, you will be responsible for sorting and categorizing companies based on size (large, medium, small), while ensuring the removal of duplicate entries for cl...
We are seeking a skilled software developer to create a custom invoice generating application tailored to our specific needs. The application will interface with a digital weighing scale to capture weight inputs, which will be used in conjunction with manually entere...and hardware integration. Please include the phrase "CustomInvoice" at the beginning of your proposal to ensure you've read the entire job description. **Deadline:** The project deadline is 10-12 days Timely delivery is crucial to us. **Additional Notes:** We are looking for a developer who can not only meet our technical requirements but also provide valuable insights and suggestions for optimizing the application's performance and usability. Collaboration and effective communication are key t...
I'm currently experiencing difficulty with my HTML website. There are broken links, incorrect formatting issues, and a general need for assistance with the HTML code. The "Admissions" section of my site is particularly afflicted by these broken links that require immediate attention. Ideally, I'm looking for freelancers who can bring rich experience in HTML and web development to the table. By demonstrating your experience in your application, you’ll increase your chances of landing this project. Let's get my website running smoothly again.
I urgently need help with my Google ad account. It has been suspended and I'm facing troubles retrieving it back. As per Google, the suspension is due to a policy violation. Here are the tasks to be carried out: - Analyzing the situation and understanding the exact reason for this policy violation. - Offering immediate resolution strategies. - Optimizing and creating new campaigns to avoid future issues. - Providing a consistent performance analysis and reporting routine. Look forward to working with someone who has proven expertise in Google ad policy, account recovery after suspension, and deep understanding of campaign creation and optimization. Should also possess excellent problem-solving abilities and communication skills. Your added value in performance analysis and r...
We are a fast-growing tech company(Imobisoft) looking for a talented Front-End Developer to join our team. As a Front-End Developer, you will be responsible for designing and implementing user-facing features, optimizing web applications for maximum speed and scalability, and collaborating with back-end developers and designers to improve the overall user experience. Requirements: Proven work experience as a Front-End Developer Proficient in HTML, CSS, JavaScript, and other front-end technologies Experience with responsive design and mobile-first development Knowledge of front-end frameworks such as React, Angular, or Vue.js Strong problem-solving skills and attention to detail Excellent communication and teamwork skills Responsibilities: Develop user-facing features and build re...
As a business operating in the manufacturing industry, I'm looking to boost our website's performance through improved SEO. Key Goals: - Enhance website visibility in search results - Drive increased organic traffic to the website...website - Boost our website rankings in search engines Target Audience: - Primarily B2B, so the SEO efforts need to cater to this audience. Requirements: - Proven experience in SEO, ideally within the manufacturing or related industries - Understanding of B2B SEO tactics - Proficiency in utilizing SEO tools and techniques to achieve the outlined goals Your proposal should outline your plan for optimizing our website, including keyword strategy, content recommendations, and link-building techniques. Please provide examples of previous succ...
I need a custom QR code label designed for my product. The QR code will encode my sqid Key requirements: - QR Code: The primary element of the label, encoding the specified SQID - Company Logo: Incorporate my company's logo into the design. - Product Details: Include the product name, MRP, size, and product code in the label design. WILL BE USING THIS IN MY BARTENDER Ideal Skills and Experience: - Proficiency in graphic design, specifically for labeling and packaging. - Experience in creating custom QR codes. - Ability to incorporate multiple elements into a cohesive design. - Attention to detail to ensure all product information is accurately displayed.
I'm seeking a proficient PowerBI expert who can create a simple dashboard with 2 tables and 6 card. Data is in excel and requirements will be shared in a doc file with all details. Needs to be build today.
...Functionality: The website should incorporate a shop page to facilitate online sales of our IT services. Ideal Skills and Experience: - Proven experience in redesigning websites, particularly corporate or B2B websites. - Proficiency in WordPress website development and customization. - Strong understanding of web design principles, UI/UX best practices, and responsive design. - Prior experience in optimizing websites for speed performance. - Past projects involving e-commerce functionality on WordPress sites will be a definite advantage. If you have the skills and experience required for this project, and a portfolio that demonstrates your proficiency in similar projects, I would like to hear from you....
