Access vba excel file update 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 ...
Access-tietokanta, joka sisältää tiedon syöttämistä, raportteja ja mahdollisuutta muokata tietoja.
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.
Morjesta mindwakerstudio! Biddaisitko tähän niin päästään hommiin! Deadline on 12.09.2014 Ja budjekti on $100
I need a structural engineer to update existing plans for an interior home remodel to submit to the City of Henderson, NV for an owner/builder permit. The city wants drawings from an engineer mainly for the following: (complete plans to be discussed if you are interested in this assignment) -replacement of two windows to two larger windows with new header to carry load of second floor above -replacement of a double front door with glass block sidelights to a single pivot door with larger glass sidelights with new header to carry load of second floor above. Window and door manufacturer to supply engineering specs to engineer -removal of upstairs fireplace and replace with wall and new opening to primary bath (non-load bearing) -re-framing of shower wall to accomodate bench (non-loa...
I am on the lookout for a researcher who can access and scan articles from a specific arabic language journal held in the Bibliothèque nationale de France. The journal was published in France. I have confirmation that it is held there. (Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions)
I need a professional PHP developer to update my current PHP script. The script currently uses PHP mailer to send emails using normal login (Less Secure Apps) authentication. The new Gmail security measures will require the use of Oauth for authentication. The ideal candidate should have: - Strong PHP skills and experience with PHP 7 - Expertise in PHPMailer and setting up email services, specifically Gmail - Solid understanding of OAuth authentication - Experience with updating scripts to accommodate new security measures - Good problem-solving skills to ensure the script remains fully functional post-update
I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.
I'm looking for an experienced software developer to create an AI recruiting software tailored for the...Matching: A system to match keywords in resumes to job requirements - Machine Learning Algorithms: An algorithm to predict candidate suitability based on historical data Platform: - Web-based: The software should be accessible via any web browser for ease of use and accessibility - Mobile App: A mobile application should also be developed alongside the web version to allow recruiters and candidates to access the service on the go. Ideal skills for this project include: - Proficiency in AI and machine learning algorithms - Experience in recruitment software development - Knowledge of LMS and healthcare recruitment practices - Ability to create a user-friendly web interface...
I'm looking for a WordPress expert to help with crucial updates on my website. The project consists primarily of content updates, along with special focus on updating various plugins. Key Responsibilities: • Updating content as per provided instructions • Updating and troubleshooting three specific plugins: Yoast SEO, WooCommerce, and Contact Form 7 Ideal Skills: • Strong expertise in WordPress • Prior experience with Yoast SEO, WooCommerce, and Contact Form 7 plugins • Attention to detail for subtle content updates. Let's enhance my website together!
I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add ...
I am seeking a skilled Swift iOS developer who can create an innovative, user-friendly application for managing driving routes via GIS .shp files. Key Featu...managing driving routes via GIS .shp files. Key Features: 1. Import GIS .shp files and convert them into driving routes. 2. Incorporate a web portal feature to assign and track drivers. 3. Real-time updates on the progress of each route. The ideal freelancer for this project should have experience with Swift, iOS development, .shp file manipulation, and incorporating real-time updates into an app. The app also needs a mobile version for drivers to access their routes; therefore, experience with mobile app development is also desired. More specifications will be provided upon selection. Looking forward to a frui...
I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.
The target is to write a Java, console program (public static void main) that will generate a docx Word file. Program needs to use docx4j library () Programm needs to generate many parts: Heading1, Heading2, Heading3, every with some content (lorem ipsum) Make a table of contents (showing on which page is a given Heading1, Heading2, Heading3 - not hard coded, but detected) Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 In the text put links to a concrete Headings, eg. "read in Heading2 - abc (page 4)" - it should be link to this section and "(page 4)" should Make a footer showing the number of page and first Heading on the
...responsible for keeping track of both pricing and product availability. A high level of accuracy is essential. Update frequency should be configurable. This script should be written in an efficient language. As I have no specific preference, I trust your judgement on choosing a language that is effective for the required task. Ideal requirements: - Proven experience in developing similar scripts - Knowledge of and experience with eCommerce website structures - Accurate and detail-oriented developers are highly essestial. Your proposal should include the language you intend to use and why you think it would be the most suitable. Please also mention how frequently the script will update the information. Start your bid with "Tracker Guru" to help me filter ou...
I'm seeking a knowledgeable writer to update an under 500-word article on Visuals SQL. Key tasks include adapting the article to a manufacturing context and replacing outdated information with the latest industry trends. The desired freelancer would have experience in technical writing, specifically within the manufacturing industry, with an in-depth understanding of Visuals SQL.
I'm in need of an architect to design a modern style triplex villa. The total area is 110 square meters and the project is expected to be a contemporary, sophisticated a...means ensuring there's a balance between communal areas and private spaces. - Incorporating key features such as a private garden or terrace, multiple balconies and rooftop access. These features are essential and should be integrated seamlessly into the design. Ideal candidates for this project should: - Have a strong portfolio of modern architectural designs - Possess experience in designing triplex villas and with a mix of open plan and separate rooms - Demonstrate creativity and innovation in the use of space - Be able to understand and incorporate essential features like private garden, balconies,...
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
...$399/month) 20% commission on the monthly revenue generated by Tier 3 clients (client pays $599/month) Bonus Structure: $250 bonus when a client reaches 3 months $500 bonus at 6 months $1,000 bonus at 12 months Earnings Potential: Our top performers can earn $1,500 - $3,000+ per month within the first few months. The more clients you acquire, the higher your passive income grows. Tools Provided: Access to cutting-edge lead generation tools Sales scripts, email templates, and resources to streamline your outreach Responsibilities: Identify and reach out to potential clients through targeted campaigns Conduct research to build prospect lists and identify decision-makers Deliver compelling sales presentations showcasing our value proposition Close deals and onboard new clien...
As a client, I have full access to the financial statements and data required for this project. I am seeking a proficient professional who can conduct a comprehensive valuation for a listed company using three different models; Discounted Cash Flow (DCF), Gordon model, and residual income. The project should be conducted with a 5-year timeframe in mind. Key Deliverables: - Thorough valuation of a listed company using DCF, Gordon model, and residual income - Clear and well-structured report detailing the results and rationale of the valuation - Analysis that corresponds to a 5-year timeframe Ideal Skills and Experience: - Strong financial analysis background with experience in valuations - Expertise in using DCF, Gordon model and residual income for company valuation - Ability to ...
I am in need of a professional website developed to showcase my academia-focused content. The site should be specifically designed to highlight my research publications. Key Features: - Display of Research publications: These should be presented in a clear, easily navigable way. Each publication must have its abstract summary and a link to access the full text PDF. - Organization: The publications should be organized by research topic, allowing visitors to quickly navigate to their areas of interest. Ideal skills for the job: - Web Design: You should have a portfolio demonstrating your ability to create professional, clean, and user-friendly sites. - Content Management: Familiarity with content organization is crucial, specifically in handling academic or research materials. Over...
I need a skilled individual to convert my current Laravel website to WordPress. The main reason for this transition is to ensure that I have a user-friendly, easy-to-manage website. Currenlty, the website is built with Laravel, but I would like it to be converted to WordPress to make it easier for me to manage and update the content. Ideal skills and experience: - Proficient in Laravel and WordPress - Strong understanding of website architecture and conversion process - Ability to ensure a seamless transition - Good communication skills and ability to explain technical concepts to non-technical individuals.
Updating prices on Puparazzi’s brochure
...looking for the product to then be purchasable following that quotation following a sign up process and agreement to terms and conditions. Customer will then automatically be sent an email welcoming them to the product and will include policy details. I will need functionality to bill customers monthly using card payment and to include a cancel anytime option. I absolutely need free-flow access to the site and the ability to make frequent changes. Therefore upon completion I will be looking to employ the designer for regular maintenance and change updates throughout the lifetime of the site. When up and running I would look to communicate mainly through whatsapp for ease of communication. A crucial requirement is for my designer to speak very good English please. K...
I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines
I am looking for an expert to put together a professional sales report using Sisense, solely based on my e-commerce platform data. Key Information: - The report should focus on sales statistics and trends, analyzing data collected from our e-commerce platform. - The main purpose of this reporting is to help us make strategic decisions and improve...will be shared with different teams in our company. Skills & Experience: - Proficiency in Sisense or similar BI tools is a must. - Previous experience creating sales reports is highly desirable. - Understanding of e-commerce data, especially sales metrics, is crucial. Please note that the report you provide can be used as a reference for future reports, so a well-documented process of how to update and maintain the report would ...
I need an experienced web scraping expert who can help me scrape relevant data from a specific website on a daily basis. Key Details: - I'm looking for data in text format including headlines, product descriptions, and any other relevant information available on the site. - There is no requirement for authentication to access the data, so the process should be straightforward. - The extraction needs to happen daily, so you should be able to set up a recurring scraping process. Skills and Experience: - Proficiency in web scraping tools and techniques. - Experience in extracting text data from websites and setting up automated daily scraping routines. - Good understanding of data formats and storage to deliver data in a usable format. I'm looking for a reliable and effic...
I need a simple web application developed using the Scriptcase platform. The main functionality of the project will be integrating a database into the application. This will include data for user profiles and product listings. Key Requirements: - Development experience with the Scriptcase platform is a must - Proficiency in PHP and web application development - Experience in integrating da...for user profiles and product listings. Key Requirements: - Development experience with the Scriptcase platform is a must - Proficiency in PHP and web application development - Experience in integrating databases into web applications Other Details: - The application must be user-friendly and intuitive - No specific user roles or permissions are required, all users will have the same level of a...
I require an experienced developer to write and implement a single page webhook URL into my current server. This webhook will specifically track and update the delivery status of messages sent through the JIO Interakt WhatsApp service, indicating if messages have been sent, delivered or failed. Skills and Experience: - Proficiency in ASP.NET C# - Deep knowledge of working with Webhook - Experience with JIO Interakt WhatsApp messaging service Project Requirements: - Implement single page webhook URL in ASP.NET C# into the current server - Webhook should track 'Sent', 'Delivered', and 'Failed' statuses of messages - It should retry sending the message if delivery fails - Use existing JIO Interakt WhatsApp messaging service API Please provide proof of...
I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.
...Display daily receipt data with graphs. o Monthly Receipt Report: Display monthly receipt data with graphs. o Annual Receipt Report: Display annual receipt data with graphical representation. o Data Source: Multiple MS SQL databases. 3. Inventory Management o Full Inventory List: Display a comprehensive list of inventory items. o Export Functionality: Export inventory data to PDF or Excel files. 4. Customer Data Analysis o Outstanding Amounts: Report on outstanding customer balances. o Receipts: Report on customer receipts. o Sales and Payments Reports: Generate detailed reports on customer sales and payments. Compatibility • The dashboard must be accessible via: o Web browsers (Chrome, Firefox, Safari, Edge) o Mobile devices (responsive design ...
