Excel vba update workbook 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.
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 am looking for an individual, preferably from Australia, to handle the regular maintenance of our client's social media profile. Your successfully completed tasks will: - Respond to reviews in a professional and formal manner. - Frequently update business information. - Post regular content updates. These tasks need to be completed on a monthly basis. Note:- Only bid if you are from Australian Region
I'm looking for a skilled data science trainer who can introduce my large team to the foundational aspects of the field. Key Responsibilities: • Deliver beginner level lectures on data science • Train over 10 team members • Cover areas inclusive of Data Analysis, Machine Learning, and Predictive Modelling Ideal Candidate: • Ex...Machine Learning, and Predictive Modelling Ideal Candidate: • Expertise in data science education • Ability to conduct engaging, accessible training sessions • In-depth knowledge of Data Analysis, Machine Learning, Predictive Modelling • Experience in training larger groups The objective of this training is to equip my team with basic data science capabilities. Thus, patient trainers who excel in bre...
We're on the lookout for self-motivated sales reps ready to roll up their sleeves and boost their earnings with our natural herbal products. With a proven track record and satisfied customers, our products offer a lucrative opportunity for those willing to put in the effort. Responsibilities: Drive sales of our natural herbal products to prospective cus...profit-sharing opportunity. As you contribute to our products' success, you'll share in the profits generated. If you're hungry for success and eager to boost your earnings through hard work, this is the opportunity for you! Join us in spreading the benefits of our natural herbal products far and wide. Ready to seize this opportunity? Submit your application detailing your drive and determination to excel in...
Hello, I have around 400 Postcodes in the UK, and out of those 300 are already done, so you need to search for the remaining postcodes on a website, I will provide you with all the ...remaining postcodes on a website, I will provide you with all the details along with a video tutorial + other details I will provide through WhatsApp messaging and calls. You will know about taking screenshots, I have a free Chrome tool, and I will provide it. it's a Very Urgent Project, so if you can start work Immediately and finish within the next 24 hours, then only apply. You should know the Excel and web-based copy/paste knowledge. This is a challenging job, and who can handle the pressure, the right candidate can get regular work. Hindi-speaking people will get preference. Happy B...
1. update elementor 2. email link on Contact page (under the word contact) doesn't send when someone fills out the form 3. the homepage image is too large
I need a knowledgeable freelancer to update my DNS records (A, CNAME, MX) for my WordPress website to make it go live. As I do have full access to my hosting account, I can provide all the necessary information for you to perform the task. In the scope of this project, no additional settings or configurations are required on the hosting environment. You just need to focus on DNS record updates. I have a past Wordpress webite that had some email attached to it and I would love to access these emails if its possible. Ideal skills for this job would be advanced knowledge of DNS configuration and WordPress, as well as a good understanding of hosting environments. It's a major plus if you have prior experience with similar tasks because I want this job to be done as soon as po...
I'm in need of a proficient individual with strong data extraction skills and a good knowledge of Excel. The task is focused on extracting both text and image data from 1-2 websites. It is essential for the freelancer to have capabilities in: • Website data extraction • Handling of both text and image data • Organizing and managing the extracted data in Excel. An eye for detail and a knack for organization would be key for this project. Experience in similar projects is also a great advantage. This task requires utmost accuracy and adherence to deadlines, thus a freelancer with a track record for prompt delivery would be ideal.
I have a simple Dash app which looks for terms in a pdf and highlights it and lets you download the highlighted pdf. I want someone to update ita UI into a custom format. It needs to be done un 4 to 6 hrs..
I'm currently endeavoring to rebrand my business and want to update my logo accordingly. With a preference for maintaining the existing color scheme, I am seeking a designer to take on the challenge of modernizing the aesthetic into something more minimalist but also eye catching and memorable at the same time. Key responsibilities of this task: - Redesign a modern and minimalist logo - Incorporate the current color scheme into the new design but am open to other color suggestions The ideal freelancer for this job would possess: - A strong portfolio of minimalist logo designs - Proven experience in brand updating - An understanding of color theory - Excellent communication and interpretation skills - Ability to meet deadlines This design and logo is for a personal trai...
I'm seeking an experienced freelancer to add 2 new pages to my Wordpress website and update current ones with booking buttons and wording provided.. The successful applicant should be proficient in Wordpress, HTML, CSS, and JavaScript with experience working in content management systems. Experience is paramount, as I prefer someone who can complete the project efficiently with minimal guidance. Show me that you're capable by describing similar projects you've done. Let's enhance the web experience for my customers together.
I need an expert to assist with converting PDF and Excel files into IIF to incorporate into my QuickBooks accounting software. This integration will be key in the transparency and efficiency of my financial transactions. Key responsibilities: - Convert files from PDF and Excel to IIF. - Ensure compatible formatting with QuickBooks. - Sort IIF files by transaction type for easy navigation and organization. Skills and experience: - Proficient in QuickBooks and IIF format. - Accurate data entry. - Deep understanding of accounting principles and financial data organization.
My goal is to standardize the naming conventions of our products on our e-commerce site. To do this, I will be using a CSV file which contains the products' names, IDs, and descriptions. Ideal Candidate: • Proficient in manipulating data within CSV files • Experience with e-commerce platforms • Detail-oriented to ensure accurate standardization of product names The task will consist of: • Updating product names in the CSV file to adhere to our new naming conventions • Ensuring the revised naming conventions correspond accurately with the correct product IDs and descriptions • Testing and verifying the accuracy of these updates on the e-commerce site This job requires a keen eye for detail to ensure every product name is updated accurately and in alignm...
I'm looking for a web developer and designer who can build a minimalist, clean website to effectively showcase my work process in architecture and interior design field, keeping my future clients engaged. The site will heavily feature: - Dynamic imagery or portfolio: Photos, sketches, models, and final creations should be visually striking, easy to navigate and update. Your experience in creating visually stunning portfolio galleries will be highly valued. This website should act as an effective tool during interviews to present to future clients, therefore the ability to add and alter content without comprehensive programming knowledge is a must. Skills ideally required: - Web design - Web development - Graphic Design - UI/UX Design - Portfolio Management -and its on squ...
I'm looking for a skilled individual with a keen eye for detail to create an Excel spreadsheet. This sheet will be handling different insurance companies' appetite guidelines, which are broken down by state. For example, I need to know which carriers write workers compensation in New Jersey Key Requirements are: - Excellent knowledge of Microsoft Excel for data organization and management. In your application, please include your asking price for this fixed rate project. Previous experience in the insurance field or with similar projects would be a plus but isn't a necessity. Looking forward to finding the best fit for this data-driven venture.
If you know how to code a javascript or python script to get a few pieces of information from Google, then this is easy for you. Here's all we need in this small project: 1. For a particular google search ON MAPs, the program would output the web URL, and name and send that to excel (or a csv) - other fields would be provided to include as well. 2. It should let me pick 1-50 entries. 3. It should work from within the browser (NO API calls necessary). that's it! Thanks for your bid
I'm seeking an expert to create an automated dashboard, aggregating training metrics from an eLearning Management System database. It is essential that Excel functions are automated, and feeding data into this dashboard should be user-friendly. Key responsibilities: - Design a dashboard that will display updated training metrics from a database - Automate Excel functions - Allow user-friendly data import Ideal candidate: - Proficient in Excel - Knowledge of DBMS (Database Management Systems) - Familiar with eLearning Management Systems - Experience in creating user-friendly interfaces - Strong time management skills, as the project needs to be completed within a month Our understanding of the exact DBMS is currently unclear; thus the freelancer needs to be com...
Hello there is a free publicly accessible Google spreadsheet with 185 lines and 21 columns. Copy and download is disable. I need someone who is still able to copy the data into an excel spreadsheet or otherwise manually "copy" all data into an excel spreedsheet thanks I offer the link to the website after receiving bids Generic bids are ignored. Therefore pls write "i understand its a download disables google spreadsheet."
I have a very simple two page wordpress site that was built a few years ago (one page is only contact information). The plugins all need to be updated, google tags need to be added, and some text/pictures need to be changed. I need someone to: - Update the plugins and make sure the site works and loads perfectly fine - input the google tags - create a duplicate page that isn't live to make the text/graphics changes on
I need a skilled and creative freelancer to create 100 different invoices for me in Excel. Each invoice must have its own distinct company design and company logo. Here are the specifics of the project: - I am giving you complete creative freedom to design each invoice. Let your mind run wild! - The invoices should include placeholder information whilst also leaving some areas blank. This will provide a more customizable experience. Ideal skill set includes: - Proficiency in Excel - Graphic design inclination - Creative thinking - Attention to detail Looking forward to seeing your brilliant designs shine on each invoice.
I'm looking for an expert PHP developer with proficiency in Codigniter to modify and enhance an existing script I bought from CodeCanyon. Task Details: • Modify existing func...functionality and add new features to the script. • Add three new fields to the signup window code and sync it with the mySQL database. These fields should include text fields and dropdown menus. • Create a report based on data from one table in the mySQL database. • Implement a feature to export the report data to Excel. Ideal Skills and Experience: • PHP and Codigniter expertise • Experience with SQL database manipulation • Knowledge in report generation and data exporting to Excel • Proficient in UI design with a focus on text fields and drop...
I'm in need of a developer to build a simple CRUD website. A few specifics about my requirements: 1. The website should interact with an Excel file; enabling data extraction and modification directly from and to the file and Display the records in a grid or tabular format. 2. Search option to look for connection details with Applicant ID. 3. Add a date picker to filter via date range via date of application. 4. Option to view/edit electricity connection application requests. a. Refer dataset for the data attributes. b. Could be on same or different page. 5. Data Validation. a. Should not be allowed to change some data and put validations on a few fields. Nothing complex. 6. Create a visualization graph e.g., bar or line chart for number of connection requests in every month. Th...
I require a freelancer who is proficient in extracting specific data points from a PDF document and translating it into a structured Excel or CSV file. The data is presented within paragraphs. Key Tasks: 1. Extract the following elements from the PDF: Names, dates, numerical values, lead location, phone number, email, US dollar value, status, date added. 2. Organise these elements in a structured format in an Excel or CSV file. Skills Required: - Attention to detail - Proficiency in data extraction - Strong knowledge of Excel or similar data management software - Ability to interpret information from paragraphs. Freelancer should assure accuracy as the correctness of extracted data is essential.
I'm seeking an professional who excels in creating detailed Power BI dashboards. It will basically focus on visualizing Sales data, Financial data, and Marketing data, and will need to be regularly updated on a daily basis. The dashboards should incorporate visual elements including Graphs and charts, Maps and geographical data, as well as Tables and matrices. This ensures read...data, as well as Tables and matrices. This ensures readable, engaging, and comprehensive interpretation of the crucial company data. Ideal Skills: - Exceptional knowledge and experience in Power BI tool. - Strong ability to structure data efficiently. - Proficiency in data visualization techniques. - Awareness of latest trends in data representation styles. - Ability to deliver on a daily updat...
I am urgently looking for a proficient content writer to craft captivating, humorous copy (infused with a dash of wit) for my Webflow resume website. The main purpose of this website is to effectively showcase my skills and ...of conveying complex professional information in a witty and accessible manner Timing: - The project must be completed ASAP due to pressing job opportunities! Your swift turnaround time will be highly appreciated. Currently webflow design is ready: Content draft: You need to update content to be more attractive as professional writer. Send me your quote, required time, and some of your work on the draft will easily let me land on the right candidate.
...the ability to utilize electronic devices effectively. Responsibilities: -Review and rectify any inaccuracies in client property information. -Ensure all property details are up to date and accurately represented on the platform. -Post and advertise client properties on Booking.com. -Utilize our partner marketplace or mobile application to facilitate listings effectively. -Regularly update property calendars to reflect availability accurately. -Ensure timely adjustments to reflect booking statuses and changes in availability. -Efficiently manage client accounts on Booking.com. -Respond promptly to inquiries, accept bookings, and communicate availability to guests. -Strive to maintain a high acceptance rate by managing bookings effectively. -Liaise with supervisors to provide r...
I'...be user-friendly and adequately cater to the following features: - Player selection and team formation; the users should be capable of selecting players (with photos) and forming their team. It should support season long format. - Points calculation and leaderboard formations; these are essential features to make the solution competitive and interesting. - Importantly, we need a manual score update system that will work fully with reports from Cricheroes. Given the complexity of the project, I require seasoned web developers experienced in fantasy web development and sports solutions; familiarity with cricket is a plus. The ideal candidate should also demonstrate expertise in User Interface (UI)/User Experience (UX) design to create an engaging and easy-to-use platform...
I am presently working on an extensive project involving several excel spreadsheets. These spreadsheets contain sentences for a book and I require a freelancer to help me color code the cells based on different categories. The color will represent different aspects of each category. The color coding will include: - More than 10 different categories - Existing color suggestions that need refining - Categorization that's based on multiple factors, going beyond the book chapters The ideal freelancer for this job should possess a good understanding of Excel and have a knack for good organization and attention to detail. Strong collaboration and communication skills are key, as I'll need to discuss and finalize the color scheme and the factors affecting categorization...
I'm in need of a proficient Excel expert who can proficiently apply formulas to my dataset. Here's what you'll be taking on: - Add 'Sum', 'Average' and 'Count' functions to the given data set. Your expertise in implementing these formulas will be highly valuable. - The dataset needs to be sorted based on validity. I'm not entirely certain whether ascending or descending order would work best, so I'm open to your professional advice. - Prioritization should be given to the most recent entries. They should appear at the top of the dataset after sorting. To succeed in this task, you must possess advanced understanding of Excel functionality and a keen eye for detail. An ability to work independently, make efficient decisi...
...portrait orientation. • Style: A vibrant and colorful aesthetic is preferred for this project. Your design should be engaging and eye-catching while being clean enough to allow for easy updates. • Structure: The flyer's layout should be a combination of distinct sections and a simple format. This means it needs to have specific areas for different information, but should be easy to update each week. I am looking for someone with experience in graphic design, specifically with flyer creation. Being adept with design software that allows for easy editing like Adobe Illustrator or InDesign is a must....