Excel macro import excel sheet access 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.
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.
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I'm experiencing unauthorized accounts being opened with my information all across various websites most of which I’ve never heard of or visited. Also there’s nonstop access to my existing online accounts and noticing suspicious activity on my devices. While I've taken measures on some accounts to secure them, it's not enough and I need professional intervention. The compromised accounts include apps, social media, GPS and financial. The activity on my devices sparks concern, particularly regarding showing activity in my history I did not do and I'm looking for expert guidance I have already wiped my device multiple times and have even gone as far as establishing all new digital identifiers such as new phone number, email, and Apple ID to no avai...
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...
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.
My Server that I access via remote desktop services has stopped allowing remote desktop access. it was working fine for months, now it is not. the error message is: "NO remote desktop license server is available. REmote desktop services will stop working because this computer is past its grace period and has not contacted at least a valid windows server 2019 License." I had this issue before about 4 months after I initially set up the server, I went through multiple steps to register and it began working again for the past 5 months or so, and now it has stopped again. I need someone to help configure/reconfigure the server properly to allow remote desktop to function properly. I have physical access to the server and can work at that server terminal to...
...learning model. The primary goal of this application will be to evaluate student applications in real-time. Key Features: - Real-time evaluation feedback: The application should provide instant feedback on student applications, based on the integrated machine learning model. - User authentication: The application should include a secure user authentication system to ensure only authorized users can access and use it. - Data visualization: The application should have data visualization capabilities to help users understand the evaluation process and results better. Integration: - The application will need to integrate with existing systems or databases. The specifics of this integration can be discussed in further detail with the chosen developer. Skills and Experience: - Prof...
I need a machine learning model developed in Python. This model should be able to evaluate prospective student applications by...should be able to evaluate prospective student applications by comparing them to historical data sets. The goal is to classify and sort the new applicants efficiently. Key Requirements: - Develop a classification-based machine learning model in Python - Understand and work with historical data sets to evaluate new student applications - Deploy the model in a web application format for ease of access Ideal Skills and Experience: - Strong background in machine learning and Python - Previous experience in developing classification models - Ability to understand and work with large data sets - Prior experience with deploying machine learning models in web ap...
I need a tech-savvy professional with vast experience in social media account recovery. I lost control of my old Instagram account but I have the username. My main goal is to regain access and permanently delete the account. Key Responsibilities: - Recover lost Instagram account using the provided username - Delete the account upon recovery Essential Skills: - Knowledge and expertise in Instagram account recovery - Experience in similar projects - Understanding of privacy and data security protocols I can provide a driver's license as proof of identity. Confidentiality and transparency during this process are paramount, and I look forward to a successful collaboration.
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.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
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 need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.
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...
...system supports IP whitelisting for added security. - Configure the dialer to handle multiple campaigns simultaneously. - Integrate a basic CRM to manage and search client information efficiently. - Ensure the system can support a minimum of 10 representatives. - Provide the capability to handle "N" number of lines per representative. - Design a user-friendly interface for agents to manage calls and access customer information. - Provide real-time analytics and reporting tools to monitor performance metrics and track agent productivity. - Ensure the system is scalable to handle varying call volumes. - Provide ongoing technical support and maintenance for the dialer system. **Requirements:** - Proven experience in developing and implementing outgoing predictive dialer s...
As part of my endeavor...will be to prevent unauthorized access. Here's what I require: * In-depth evaluation and analysis of our data security framework * Identification of any potential vulnerabilities and security loopholes * Devise strategies to fortify the data security dimensions against malicious hackers The ideal candidate should possess: * Extensive experience in ethical hacking and data security * Strong analytical skills and a keen eye for spotting weaknesses and vulnerabilities in data security * Ability to devise actionable strategies to address the identified issues Rest assured, full access to the necessary systems will be granted for the successful execution of the job. Please note that a thorough professional background check will be performed be...
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...
I'm looking for an experienced full stack developer to help me with a project. This role requires a professional who is well-versed in both front-end and back-end coding. i need someone with great experience to deploy my webesite, i will give access to my sourcecode
...Estimated Time: 3 hours Evaluation Criteria: Creation of a simplified specification sheet Identification and characterization of functions and constraints Hierarchization and creative problem-solving using FAST diagrams Proposal of solutions with clear schematics and sketches Value analysis including criteria, scoring, weighting, and reasoned choices Synthesis of selected solutions CAD Modeling of a Mechanism Estimated Time: 8 hours Evaluation Criteria: General appearance and manufacturability of parts Quality and cleanliness of part modeling and construction trees Accurate assembly definition and kinematic mobility Definition of stops for μ and λ, and the locking mechanism Verification against specification sheet constraints Clear explanations for complex desig...
I need a freelancer with web scraping skills who can extract product prices and models from my 17 competitors. Ideally, the freelancer should be able to: Extract information accurately and comprehensively. Upload all the extracted information into an Excel sheet. Create a simple online website to facilitate this process. I have hosting and a domain. Enable me to update the extracted information with a single click. Complete this task within a maximum of 48 hours. Please include detailed proposals in your application on how you would approach this project.
Floor joist and beam plan Autocad sheet needed for house plan
I'm having an issue updating my WordPress site plugins due to a checksum error. Along with this, I can't download newer versions of WordPress. I also need to make sure that my website is compatible with Consent Mode V2. Your responsibilities include: - Diagnosing and resolving the checksum error that prevents me from updating plugins and downloading ...other issues that could be causing the problem. Skills and experience needed: - Proficiency in WordPress, its functioning, and its common issues. - Experience with plugin management and troubleshooting. - Familiarity with web compliance, especially with Consent Mode V2. - Ability to work around potential issues caused by uncertain changes to the site. I'll provide you with WordPress admin access so you can troubl...
...correct/wrong/blank questions should be calculated by determining the options marked with the appropriate image processing algorithm. In addition, the number of times each question was marked as correct, how many times as incorrect and blank should be kept during each determination. The application must be developed for Android. The general structure of the application and a sample of the answer sheet are attached. Requirements: - Strong knowledge and experience in OpenCV and image processing - Proficiency in Android development - Familiarity with mobile optical reader applications - Creative and innovative thinking for suggesting image filtering effects Preferred Skills: - Experience in developing Android applications with OpenCV - Ability to provide regular updates and chec...
As I am looking for an experienced Android app developer, I have a vision for an educational app that helps learners to access educational content with ease. Detailed walk through will be provided on call as I have the front end concept simulation ready. However here are some... Key Project Features: - User login & Registration: We require a secure user login and registration setup that protects the user's data and ensures only registered users have access to our app. - Requires Map integration and working with object on a map (google maps/mapbox, etc). - Implementation of Modal screens. Ideally, the freelancer should have a robust experience in the development of Android apps. The freelancer should be well-versed in creating apps that offer user-friendly inte...
...information is to be taken from Local Planning Authority official websites (publicly available information and no logins required). An in-depth knowledge of planning submissions and permissions and BNG is NOT needed. What is however required is accurate information to be taken from those websites and converted into a database for us. - This work can be done remotely and only requires a computer and access to the internet. - The geographical focus of the UK planning authorities we require information from will be provided to you in a prioritised list This is a meticulous role that requires sound organizational skills, attention to detail and an ability to efficiently analyse and interpret information. Candidates with extensive experience in market research, particularly wit...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output f...
...live sound engineer to ensure the best audio experience for our audience. - Event Type: Your main focus will be to manage the live sound at a rock concert, ensuring a vibrant, smooth, and balanced output. - Music Genre: Having experience with rock music is critical as you'll be balancing and mixing sounds for such a performance. - Sound Equipment: We've got the basics covered; you will have access to microphones, speakers and mixers at the venue. Your expertise on how to utilize these equipment to create the quintessential rock concert atmosphere will be key. Ideal candidate should have: - experience as live sound engineer, ideally with rock concerts. - comfortable level of skill in sound mixing and balancing. - Familiarity with the use and management of sound syste...
I'm in need of a talented designer to create a minimalist and modern facade for my clothing store. The design should be both aesthetically pleasing and practical, reflecting the essence of a contemporary retail space. Key Requirements: - The selected materials for the facade are Glass, Metal, Wood, acp, aluminium pipe, and acp alternate sheet. Experience with these materials is a must. - The desired color scheme for the facade includes violet (#47143d), golden (#b99750), and white (#ffffff). However, I'm also open to other corporate-looking 3-color palettes. Store dimentions: Height- ground level to ground floor roof= 12 feet, remaining till top= 44 feet, total = 56 feet Width- 50 feet wide (at only ground floor, there are 2 shops having front space of 25 feet each) {ref...
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
...This app should cater to the needs of individuals and should be fully responsive as I want it to be accessible across various devices, particularly mobile. Key Features: - User Registration and Login: A seamless and secure process for users to create accounts and log in. - File Upload and Storage: A functionality that allows users to upload and store files. This should include a system for easy access and organization. - Payment Processing: A secure payment system that enables users to make transactions within the app. Ideal Skills & Experience: - Proficiency in web development, particularly in creating user-friendly interfaces. - Experience with security protocols for managing user data and payment processing. - Strong knowledge of cloud storage and data management system...
...process with your valid translation certificate or degree **Tasks**: * Create a account with the client's provided information * Configure the account for shared access * Provide login credentials for the client to access the account * Assist the client in understanding the features of the platform **Selection Criteria**: * Qualifications and experience in translation * Quality of CV and references provided * Ability to pass 's verification process with a valid translation certificate or degree * Competitive pricing for services offered **Additional Terms**: * The freelancer will have access to the account and will be able to use it for their own translation projects. * The freelancer will receive 45% of the earnings generated by me on the platfor...
1) Configure the OpenVPN CloudConnexa Client on TP-Link (OpenWRT) so that other CloudConnexa Clients can access the devices behind the router. For example (see attached image), CloudConnexa Client should be able to access and 92.168.17.20. 2) Document required changes in a README file.
I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.
I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if...
I need a Blender expert to import the Textures I downloaded from my Turbo Squid account for the product (please see what i currently have vs what It should look like). I've had a play around myself with nodes etc, but I'm relatively new to the software and haven't had much success bar the buttons in the middle. I have all the textures as a .tif, I just need them importing and correctly set up so they look the same when rendered.
This project involves cleaning up an MP3 audio file. Key requirements are: - Experience with audio editing and noise reduction - Expertise in removing embedded sounds, particularly the echo and piano sounds which are equally distributed throughout this file - Delicate handling is needed as the given audio...editing and noise reduction - Expertise in removing embedded sounds, particularly the echo and piano sounds which are equally distributed throughout this file - Delicate handling is needed as the given audio file has low quality (distorted or noisy) - Ability to complete tasks within deadlines - Experience with handling audio files of less quality like this one will be favorable - Should have access to high-quality audio processing and editing software to deliver optima...
I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance a...with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with Excel/CSV data import...
I'm currently facing an issue with my MySQL replica. Although there are no errors, the data isn't being synced and the "Seconds_Behind_Master" is consistently increasing. I'm looking for a professional who can help me with this problem. I can't give you access to the server(s) but we can troubleshoot together. Key Requirements: - Expertise in MySQL command line - In-depth understanding of MySQL replication mechanisms - Experience in troubleshooting replication lag - Ability to work quickly and efficiently Max 50 euros. Thank you.
