Excel vba refresh web query handle data 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.

lojnjg gyguuuuuuuu gg jbjiiihhtft kiyoio

2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.

Offline typing job,data entry job

I have a Pine Editor script that I believe is in a good...around Pine Script and TradingView to help me get this script running smoothly. Key Requirements: - Troubleshoot and debug script errors: The main issue I'm facing is error messages when I try to run the script. I need someone to go through the script, identify the root cause of these errors, and help me fix them. - Pine Script proficiency: The ideal freelancer for this project should have a good handle on Pine Script, as it's essential for understanding and improving the script. - TradingView experience: Since the script is set to work within TradingView, experience with this platform is crucial. This project is of a beginner complexity level, so someone with a good grasp of the basics should be able to help me r...

I'm in need of expert landing page designer for my two businesses. The landing pages are aimed at providing visitors with comprehensive information regarding the services I offer. Key Requirements: - **Content Development**: The content for the landing pages is currently unavailable. Therefore, I need a designer who can also handle content creation. - **Design Style**: The landing pages should be designed in a professional and sleek style. Ideal Skills and Experience: - Proven experience in designing and developing compelling and professional landing pages. - Strong content creation skills. - A portfolio that demonstrates a history of successful landing page designs. Please bid only if you can fulfill these criteria. A comprehensive understanding of user experience and SE...

We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web

...with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a ...

I'm seeking a dedicated social media manager to handle my entertainment account across all major platforms. Your primary objective will be to enhance our online presence, driving engagement, increasing followers, and boosting website traffic. Key Responsibilities: - Manage and post engaging content across Facebook, Instagram, and Twitter - Increase followers and enhance engagement - Drive traffic to our website - Promote brand awareness effectively The ideal candidate should have: - Proven experience in social media management for entertainment or similar accounts - A clear understanding of different social media platforms and their best practices - Strong analytical skills to measure and optimize the effectiveness of the social media strategy - Excellent written communicatio...

As a client, I'm in need of a skilled web developer to create a comprehensive e-commerce website for my business. The primary goal of this platform will be to sell products online. To ensure that the business runs smoothly, I need the site to have integrated shipping with carriers. Key Requirements: - E-Commerce Functionality: The site should be able to handle transactions securely and efficiently. - Integrated Shipping: The platform should be capable of integrating with shipping carriers to handle delivery of the products. Ideal Skills: - Proficient in E-commerce Development: Experience in creating secure and functional e-commerce platforms is crucial. - Familiarity with Shipping Integration: Ability to connect the website with shipping carriers for seamless s...

I require an Adobe Premiere proficient video editor to handle a 2-5 minute music video in a clean and simple style. The task must be completed within 24 hours, and I need to be delivered an editable Adobe Premiere version as the final work. As I have not specified any particular visual effects or transitions, use your professional judgement to best meet the clean and simple style preference. My budget falls between 35 to 50€. Ideal freelancers will have experience in music video editing and be able to operate swiftly and efficiently. The video is for a class project and I have the files as XML

I have a live Amazon seller account. As a part of managing my account, I am looking for a professional to handle 'A to Z' management services. The ideal candidate should: - Experience in sourcing, does not have to be in shoes as I already have someone for this task - Be experienced in managing Amazon accounts - Be proficient in A to Z account management, including product listing optimization, customer service management, and inventory management - Have a good understanding of Amazon's policies and guidelines - Be able to strategize and implement plans to increase product visibility, sales, and customer satisfaction Looking for someone who can take this responsibility off my hands and help me grow my Amazon business.

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria fo...

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

I'm in need of a skilled professional to help me create a data mining script. The task involves mining emails, data from a certain website and delivering the data in a raw text file format. Key Requirements: - Develop a data miner script that can effectively scrape email data from websites. - Ensure the script can handle multiple sources and is scalable for future needs. - Deliver the mined data in a raw text file format. Ideal Skills: - Proficiency in web scraping and data mining techniques. - Experience with developing scripts for text data mining. - Strong knowledge of scripting languages suitable for scraping like Python/BeautifulSoup, R, etc. Please provide samples of your previous similar projects or port...

I'm looking for someone skilled in finding trending electronics in China for my online shop. Key Requirements: - **Product Type**: Electronics - **Sales Channel**: Third-party platforms (e.g., Amazon, eBay) ...Evaluate and establish relationships with reliable Chinese suppliers. - **Cost Analysis**: Negotiate cost-effective deals without compromising on quality. The ideal candidate should: - Have a keen eye for spotting innovative products - Be experienced in sourcing electronics from China - Understand the dynamics of selling on third-party platforms - Possess strong negotiation skills - Be able to handle the logistics of international product sourcing. Please provide details on your previous experience in electronics sourcing and any success stories you've had with ...

I need an expert in Android Java to develop a 3D Sudoku solver app with the following specifications: - **Difficulty Level**: The app should be able to handle hard level 3D Sudoku puzzles. Please keep this in mind when devising the solving algorithm. - **Features**: The app will solely focus on solving pre-defined puzzles. I do not require a puzzle builder component. - **User Interaction**: Users will input the Sudoku puzzles by typing the numbers. This means the app should have a user-friendly interface that allows for easy input of the puzzle to be solved. The ideal freelancer for this project should have: - Proficiency in Android development using Java - Experience with developing puzzle-solving algorithms - Strong understanding of user interface design - Proven track record wi...

As a growing architectural firm, we are seeking an experienced Revi...during the construction phase. Key Responsibilities: - Create Revit models from concept design to construction documentation - Coordinate with our on-site team to ensure accuracy of the model Required Skills: - Proficiency in various types of Revit modeling - Prior experience in residential, commercial, and industrial projects - Detailed understanding of various construction phases - Ability to handle medium-scale projects independently. Your expertise will help us bridge the gap between conception and construction, providing a more realistic and manageable understanding of each project. Candidates who can demonstrate a portfolio with a variety of building models aligning with our requirements will have an ...

...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...

I need an experienced data entry specialist to handle the efficient entry of both text and numeric data from various documents. Your responsibilities will include: - Extracting data from provided Excel and PDF files - Ensuring the accurate entry of approximately 100-500 records Those with a meticulous attention to detail, a high level of accuracy, and proficiency in Excel and Adobe PDF will be best suited for this job. Previous experience in a data entry role handling similar volumes of data would also be advantageous.

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

I require a professional data entry freelancer to help me with a PDF data extraction task. The project involves extracting and organizing information from a series of PDF files. The data to be extracted varies and includes both text data and numerical data, in addition to images or diagrams. The ideal freelancer for this project should be experienced in data entry and be comfortable working with PDF files. Key requirements for the project include: - Extracting text and numerical data from PDF files - Organizing the extracted data in an easily accessible format - Ensuring accurate extraction of information - Handling images or diagrams within the PDF files The extracted information will be used for further analysis and will signific...

...is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and log...

...Your three main objectives would be: 1. **Data Processing & Model Training:** - You'll need to clean and preprocess data within Stack AI - Also, train and evaluate models for maximum performance. 2. **Implement Google Search and ChatGPT Workflow:** - Familiarity with Google Search API and its integration into ChatGPT is a must. - Implement natural language processing to handle user queries - Design an intuitive and user-friendly interface to facilitate user interaction with the search process. 3. **Professional Recommendation Creation:** - Lastly, your task is to create a recommendation system using Stack AI that will offer professional suggestions to users. The ideal freelancer would have substantial experience with data cle...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

...samples. - User authentication: This should ensure that only authorized users can have access to information. - Data encryption: This will provide necessary security to protect sensitive data such as confidential business information and customer details. - Scheduling: The scheduling feature should be calendar-based, allowing users to easily follow-up appointments or tasks. - Credit card payments: The API should be able to handle secure credit card transactions without issues. similar to the attached Ideal skills and experience required are detailed knowledge of API development. Proficiency in at least Python, JavaScript, or Java is required. Additionally, a strong background in data security and e-commerce will be beneficial. A good understanding of cale...

I urgently need an experienced photo editor who...deceased classmate. The tasks involved in this project include: - Removing the current background from the photo - Adding a cap and gown to the person in the picture - Merging the modified photo with another one Please note that this project requires utmost attention to detail to ensure that the final product looks as natural as possible. As it carries emotional significance, it's paramount to handle this task sensitively and respectfully. Ideal candidates should have significant experience in advanced photo editing techniques such as object adding, background removal, and image merging. Please provide evidence of similar projects you've completed. A quick turnaround time is crucial, as the project needs to be completed ...

I'm in need of a data entry expert in Andhra or Telangana who can assist with medium-sized projects. The tasks are of 2 main types: Spreadsheet data entry and Manual Data Entry. The data is currently in the form of Data Filtering and Processing. The ideal freelancer should have: - Fast hands and typing skills - Proficiency in spreadsheet data entry - Experience in manual data entry - Previous experience in data filtering and processing - Availability to handle medium-sized tasks (100-500 entries) - Should be located in Andhra or Telangana, India Please bid only if you meet the above criteria. Looking forward to your bids.

I'm in need of an experienced Amazon FBA agent who can proficiently handle shipping tasks for my business. The ideal candidate would be well-versed in international shipping, particularly to North America. The scope of tasks includes: - Ensuring smooth and efficient shipping process - Troubleshooting any shipping issues - Timely updating on the shipping status Extensive experience with Amazon FBA is a must, in addition to strong skills in inventory management and listing optimization. Importantly, a good understanding of product sourcing is necessary. I'm seeking an expert who can add value to my business, boosting efficiency and productivity. If you fit the bill, feel free to apply!

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work...

Looking at implementing a hosted/private version of for multi-PDF generative AI. I'm looking to develop a state-of-the-art AI system that can analyze multiple PDF documen...analyze multiple PDF documents at once. Key Requirements: - The system must be able to analyze multiple documents to generate coherent and informative summaries Ideal Skills and Experience: - Proven experience in developing AI systems, particularly focused on content generation - Strong understanding of natural language processing and machine learning - Background in creating systems that can handle multi-document analysis - Previous work in generating content for professional audiences would be a plus Please feel free to reach out if you believe you have the right expertise for this project.

I need an experienced WordPress developer to work on specific page updates with Elementor and ensure they're completed by Monday morning. Key Requirements: - Implement design changes: The primary goal is to refresh the brand image, ensuring it's consistent with our current branding. - Efficient and quick: This is an urgent task, I need someone who can start today and complete it by Monday morning. Ideal Skills and Experience: - Proficient in WordPress: You should be well-versed in WordPress, particularly in working with Elementor. - Strong design sense: Experience with design and branding is crucial to ensure the updated pages align with our brand image. - Time management: The ability to work under tight deadlines and deliver high-quality results promptly is extremely im...

I'm seeking a talented graphic designer to refresh our website design for on mobile and desktop platforms . Must make the website quicker and incredibly user friendly. Key Requirements: - I need the website to have a clean, professional look that accurately reflects the informative content. - It should be user-friendly and intuitive to navigate, focusing on providing a seamless user experience. - The design should incorporate a consistent color scheme and typography that aligns with the overall branding. Ideal Skill Sets: - Strong understanding of user experience and user interface design. - Proficiency in graphic design software and tools. - Prior experience in designing and developing informational websites. - Excellent communication skills to ensure that the

I’m looking to hire a WordPress Developer proficient with Bricks Page builder on an ongoing basis (part time), to handle tasks such as; - Developing New Websites - Website Maintenance & migration - Managing website projects and client communication Requirements: At least 3+ years experience developing WordPress sites with a decent portfolio of at least 5 portfolio websites. Experienced in building websites with Bricks page builder. Should have a good eye for design. Preferred expert knowledge of WordPress, top WordPress plugins and tools such as Bricks, ACF or Metabox, CPTUI, Generatepress, Generate Blocks, PHP, CSS/HTML. Please send the links to websites you have built with Bricks page builder. Note: Bricks page builder is preferred.

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

I need a developer to implement a searchable combobox within the Lightning Web Component (LWC), interfacing with both Apex and Visualforce Remoting. Key Requirements: - The combobox will need to handle custom object data - The search functionality should be designed for contains matching. Ideal Skills and Experience: - Proficiency in Salesforce LWC development - Strong background in Apex, Visualforce Remoting - Previous experience with implementing searchable components on Salesforce platform - Familiarity with handling large datasets using Salesforce's Visualforce Remoting. Your main focus will be on building a responsive, efficient combobox that can handle the large data volumes we work with. The combobox should accurately and rapidly display ...

I am seeking a talented Procreate designer who can handle digital illustrations, graphic design, and is proficient in creating custom brushes and textures. The project is for a personal project, but I would like to have high-quality work that has a strong visual appeal. Key Responsibilities: - Develop digital illustrations and graphic designs for a personal project - Create custom Procreate brushes and textures to enhance the overall aesthetic - Implement cosmetic filters to bring a unique touch to the designs Ideal Skills and Experience: - Proficiency in Procreate - Strong background in digital illustrations and graphic design - Experience in creating custom brushes and textures - Familiarity with implementing cosmetic filters to enhance visual appeal - A keen eye for detail and ...

...looking for an experienced marketer who specializes in marketing campaigns that rely on data analysis. You as a digital marketer must be able to handle the data analysis that we will provide you with to target the right target audience. You as a digital marketer, you must be able to implement advertising campaigns based on the data analysis that we provided to you. You as a digital marketer, you must be able to implement advertising campaigns on Facebook, Instagram, Snapchat, TikTok, and Twitter. Ideal Skills and Experience: - You must have the ability to handle the data analysis that we will provide you to target the right target audience. - To have proven experience in marketing campaigns that rely on data analysis. - To have prove...

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant...

I have a PES file that needs to be converted into a satin stitch. The original design is available in another format, so you can work from that. Key Requirements: - Convert PES file to satin stitch - Multiple size outputs are needed Ideal Skills and Experience: - Proficient in PES file format - Experience with converting designs to satin stitch - Able to handle multiple size outputs Please bid if you have the skills and experience necessary.

I'm in need of a mid-level recruitment specialist to assist me w...recruitment specialist to assist me with recruitment tasks. Key Responsibilities: - Conducting initial screening procedures for potential candidates - Sourcing and identifying suitable candidates for the role - Assisting with the interview processes via email I'm looking for someone who has experience in recruitment, particularly at the mid-level. It's essential that the freelancer is able to handle the recruitment process with minimal supervision. The ideal candidate will be able to provide insights and suggestions on improving our recruitment strategy. The candidate should have a good understanding of recruitment best practices, be organized and have good communication skills. Experience in a si...

I'm in need of a skil...The project I have in mind is a custom web application that will require: - Search Functionality: The application will have a search feature that allows users to find specific content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that demonstrate your expertise in these areas. I'm looking for a reliable, communicative individual who can d...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I have an excel file, need add product categorie on a column - budget 100€