Vbs update excel pivot table 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.
Yritykseni myy veneitä, uusia ja käytettyjä. Minulla on nyt yksinkertainen wordpress / elementor pro:n päälle tehty sivusto. Haluan sivustolle esim woocommercella tehdyn tuotekatalogin, jossa erottelen uudet veneet omaksi välilehdekseen, ja käytetyt omaan. Haluan itse pystyä päivittämään sivustoa, olen itse rakentanut nykyisen sivun, mutta kaupan integroimista ulkoasuineen en hallitse. UPDATE: I have a website , I have built it with wordpress 5 and elementor pro. I have basic knowledge about installing and maintaining the website but need help integrating woocommerce and building simple product catalog. For example this website of my competitor has quite simple catalog for used (brokerage) and new boats: Also this one ...
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.
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.
Morjesta mindwakerstudio! Biddaisitko tähän niin päästään hommiin! Deadline on 12.09.2014 Ja budjekti on $100
I need to update the theme on a website. Key Requirements: Update Theme on the website to match provided Figma File Update Home page to match provided figma file Create two additional pages that dont exist today Ideal Skills and Experience: - Proven experience in Wordpress website development, specifically for business purposes. - Strong design sense and understanding of user experience. - Excellent communication skills and the ability to provide regular updates on the project's progress. This website is already created you can see it at , it just needs to be updated to match new theme. Current wordpress using Astra theme
I need an experienced app developer to update my iPad app to fix a server connection issue. The app is currently unable to connect to the server, and this problem needs to be resolved. Once the update is complete, the app should be submitted to the Apple Store, and I require it to be compatible with iOS 12 and earlier. Key Requirements: - Fix the server connection issue preventing the app from connecting - Update the app to be compatible latest ios firmware - Submit the updated app to the Apple Store You should have: - Prior experience in iOS app development, particularly with server connection issues - Ability to navigate Apple's submission process and ensure the app meets their requirements - Proficiency in iOS 12 and earlier, and the ability to make the nec...
As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...
I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.
...performance of the site. - Additional Functionalities: I aim to introduce new features to the website, specifically: - User Registration and Profiles: The new website should have a seamless user registration process, allowing visitors to create accounts and manage their profiles. - Blog Section: The addition of a blog section is crucial. It should be easy to manage, allowing me to regularly update and publish blog posts. - E-commerce Capabilities: Integrating e-commerce functionality into the website is also paramount. This includes setting up a secure payment gateway and ensuring smooth transactions for users. The ideal candidate should have experience in: - NextJS and WordPress migration - UI/UX design with a focus on clean, minimalist aesthetics - Performance optimiza...
...existing residential floor plans. Scope of work: Update plans and make necessary modifications per information below. We want to make some changes to the attached plans. The main objective was not to compromise the roof lines and exterior. Scope of work- Masterbath- Bumpout for Tub with side roof. Will not affect main roof. Masterbath and Closet reworked and extended this area along with the garage back 5’-0” existing roof pitch will extend. Bedroom 3- Extended this area back 5’-0” and added a pitch roof to the existing roof line. Moved rear porch demising wall over 3 ft to expand the width of this room. Need to resize living room windows next to back door. Prefer Qty.3 3060 windows with 3080 door in living room. No need to update the wi...
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
...and I would like to retain this when it is migrated. Key requirements: - Preserve the design layout and content structure - Ensure that the website's navigation is intuitive and user-friendly - Install a contact form plugin to allow visitors to get in touch easily The primary goal of my website is to inform and educate visitors. Therefore, it's crucial that the new WordPress site is easy to update and manage so that I can continue to provide fresh, engaging content. Ideal skills and experience: - Proven experience in WordPress development - Strong understanding of web design and user interface principles - Ability to preserve and improve upon the existing design and content structure - Proficiency in installing and configuring WordPress plugins, specifically contact...
I am in need of a seasoned digital marketer who can proficiently handle SEO, social media management, and email marketing tailored to reach local customers. This role requires a keen understanding of how ...Craft and execute a strategic social media plan to connect with the local customer base * Email Marketing: Develop a captivating and result-driven email campaign The ideal freelancer: * Experience with SEO, social media management, and email marketing * Proven track record of lead generation * Understanding of local market demographics and trends * Strong analytical skills to track success and pivot strategies as needed * Highly creative in developing engaging and innovative marketing strategies. Take your digital marketing skills to the next level in this multi-faceted role. ...
Python Script Developer for Photoshop Automation & WordPress/WooCommerce Integration We are seeking a freelance Python developer to create a script that automates Photoshop tasks and integrates with WordPress/WooCommerce for product customization. The script will: Develop a Python script to automate Photoshop oper...Integration We are seeking a freelance Python developer to create a script that automates Photoshop tasks and integrates with WordPress/WooCommerce for product customization. The script will: Develop a Python script to automate Photoshop operations. Integrate the script with WordPress/WooCommerce to retrieve order details. Automatically open Photoshop and modify PSD files based on customer orders. Update text layers with customer input and save customized templat...
I urgently need an experienced freelancer to update my Shopify store and add / edit over 500 products from and www.betterbodies.com. The products should be properly categorized, have clear descriptions and images. Besides this, I need the added products to be linked to other platforms I operate on, such as eBay, Amazon, and Facebook Marketplace. Key Requirements: - Update all categories and collections - Add over 500 products from the mentioned websites - Ensure detailed product descriptions and high-quality images - Link added products to eBay, Amazon, and Facebook Marketplace Project Timeline: I'm looking for someone to complete this project ASAP. If you have experience in similar projects and can deliver quality results quickly, I'd like to hear from you. I...
I have a simple python script that interact with an API that takes data from said api and outputs it in a table. The service where I use the API also has a website where I can see in the same table format the exact same data. Pandas know how will help. My problem is that the data from API and from service is mismatching. Your job is too look and identify where the problem is. You will receive both program (simple streamlit app that runs locally) and login details to website to cross check.
3D modeling and two photorealistic renders showing the assembly of the table
I require a professional to format my entire scientific thesis in Microsoft Word. The document needs to be formatted to a high academic level. This will require the following: - Ensuring the entire document is formatted consistently for a professional and cohesive look. This includes font, headings, and spacing. - Creating and formatting a Table of Contents - Setting up headings and subheadings in the document according to the specified style. - Ensuring font, spaces and tables are properly formatted ensuring a professional look. The preferred formatting details are as follows: - Font: 12pt Times New Roman - Headings and Subheadings: Italicized with the same font size Ideal candidates for this job should have: - Solid experience in formatting academic or scientific documents. - ...
...installed. As a result of this update, both my Wordpress websites and Java application are not working. When attempting to access the websites, a 503 Service Unavailable error is displayed. Key Tasks: - Diagnose the issue: Identify the root cause of the malfunction and provide a detailed explanation of what caused the websites and Java application to stop working. - Implement a solution: Apply the necessary steps to rectify the situation and restore full functionality to both the websites and the Java application. - Testing: Ensure that the fix is effective by thoroughly testing the websites and the Java application. Skills and Experience: - Profound knowledge of Webmin/Virtualmin/Cloudmin with the Tomcat module is essential to understand the impact of the update. - Str...
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...
...from before that told me he could improve the module by take order dates and other dates already in the database to fill in missing data of the graph. Right now the graph just records order and financial information in the database and displays it on the graph. Where there is no data the graph just shows a straight line as shown in the demo screenshot. So I want the graph to show the data that its table is missing by getting this information from the WHMCS database. The end result would fill in the missing data of the straight line and also show the history on the graph from the start of the database, right now it only goes back 3 years because that is all the data it had collected since using this module. Hopefully this makes sense but let me know if I can clear it up. I also ...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...
We are seeking a highly skilled and experienced WordPress developer to handle the migration of an existing website to a new hosting provider. This role also involves updating the WordPress core software and all plugins, ensuring the security and integrity of the site, and providing ongoing maintenance. Responsibilities: 1. Migrate the existing WordPress website to a new hosting provider. 2. Update the WordPress core and all installed plugins to their latest versions. 3. Verify the security of all plugins and scripts. 4. Identify and remove malware to clean up the website, which is currently flagged on up to 8 malware sites. 5. Address and resolve any 3rd party malware reports. 6. Provide ongoing WordPress maintenance and security support post-migration. Qualifications: 1. Proven...
...full database of minimum 30 to 40 demo clients or sample clients in the GrowCRM system, covering all stages from leads to task completion, payment, and ticket management. Create demo data from beginning to end for the demo clients to demonstrate the CRM functionality at all levels, as per the services and offerings of the agency (). Create demo proposals for the sample clients. Update the main CRM provided once selected for the project with the created demo data. Preferences: Experience working with digital and web development agencies (added advantage) Knowledge of creating and making Standard Operating Procedures (SOPs) for CRM systems Prior experience working with CRM systems Requirements: Proven experience in technical writing, process documentation, or instructional
I'm seeking a qualified web designer to update my website's layout. Here's what I need: - Introduction of a Media Page: This page should display links and articles, creating a repository of press and online publications about my company. - Adjustment of Existing Sections: We'll need to discuss which parts of the site can remain as they are and which ones need alteration to accommodate the media content. Practical experience with web layout changes is a must, and knowledge of content organization is highly advantageous. Anticipate a job revolving around comprehension of detail and alignment with my company's visual branding. Take note that while changes are significant, preserving the overall feel of our original page is paramount. I'm looking forward ...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
I'm looking for a talented graphic designer to revamp the current cover of my parenting book. The current one isn't quite hitting the mark and I'm looking for someone who can bring fresh, appealing ideas to the table. I like this cover, but maybe you can improve it.
hello , i currently have my app in playstore up and running. but, i have created this app in drag and drop builder ( Kodular ). which have so much limitations as well, i am unable to push notifications for the new content. I am looking for someone who can conv...push notifications for the new content. I am looking for someone who can convert or build same app with same interface and structure . What you have to do ? - Convert whole app from kodular to android studio. ( don't want any trace of the app ) - optimize app and UI for higher fill rate of ads. ( i am using FB ads to earn revenue ) - I will share API key once project done. - Allow me to easily update news or content from my PC ( Easy Backend ). - Add one more page to upload my youtube videos into app or into content...
I'm looking for a skilled carpenter or furniture maker to create a custom wardrobe with an integrated dressing table. Key Requirements: - Material: The wardrobe should be crafted entirely from high-quality wood. - Interior Features: The wardrobe must include shelves, hanging rods, and drawers for optimal storage and organization. The wardrobe should be elegant in design and functional in use. Please ensure it is sturdy and durable, suitable for daily use. It should be a balance between aesthetic appeal and practicality, ensuring it can comfortably accommodate my clothing and accessories. Ideal Skills: - Experienced in carpentry or furniture making, particularly in creating wardrobes. - Proficient in working with wood and able to translate the design into a quality finished...
I'm looking for a skilled Wikipedia editor to update a public figure's Wikipedia page with verifiable, online sources I will provide. Key Requirements: - Skilled Wikipedia Editor: You should have a proven track record of editing Wikipedia pages, ideally public figure pages. - Access to Online Sources: You will need to be able to access and incorporate the online sources I provide.
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
I am in need of a freelance professional who can assist with the creation of a magazine to promote a small rural town in Arizona and our RV resort. We also need you to design 6 billboards and signs for our RV resort. The magazine will be composed of: 1) A 35 page magazine/brochure containing ads for local businesses, small business features, business directory, area information, etc. The ...read the magazine, so understanding of effective call-to-actions and market strategies in this setting is preferred. The ideal candidate for this job would have experience in both magazine production and outdoor advertising, with a keen understanding of how to tailor content to the business audience. Most importantly, I am looking for someone who can bring creativity and fresh ideas to the ...
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data points...
I am looking for an experienced PHP developer to help me domify some software. Specifically, I need an inventory management system built from raw PHP. Key Features: - Inventory management: I need a system that can help me keep track of my inventory in real-time. This system should be able to handle multiple products and update their status as needed. Current Inventory Management: I am currently using another software to manage my inventory. However, it does not meet my needs and I am looking for a more tailored solution. Ideal Skills: - Strong proficiency in PHP - Experience with building Inventory Management Systems - Knowledge of raw PHP If you have experience in building similar systems, I would love to hear from you.
