Macro pull data from multiple excel sheetspráce
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
Jednoduchá alá timesheet aplikace, v které může zaměstnanec rozdělit svůj týdenní čas v procentech mezi projekty, země a neprojektové aktivity a jeho nadřízený pak výkazy pro všechny své podřízené schválit. Vstupní data (zaměstnanci a nadřízení) se načítají z HR systému a výstupní data se pak ukládají do DWH. Přiložený wireframe by měl dát jasnou představu o tom, jak by aplikace měla vypadat a fungovat. K dispozici pak bude i plnotučný solution a functional design. Interně odhadujeme, že je to cca 10 MD práce a aplikaci potřebujeme mít hotovou do konce roku. Pokud máte ...
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
Two years ago, I had a plugin created to calculate the price of pencil printing. After updating the woocommerce, my files were probably overwritten - the price with the print on the product page, in the cart and others is not displayed. You will need a good knowledge of the core of woocommerce and programming Link for example : https://...Link for example : input quantity 100 - select "potisk předmětu - online kalkulačka" click "zvolte technologii" select "tamponový tisk" click "Upřesněte technologii" select "jednobarevný potisk" click vypočítat cenu potisku ... now see only NaN Kč... Nan - It should be the sum of the price of the products + the price of the print Multiple files need to be modified for...
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
We need to turn this picture into an infograph / process flow with some animated features. Needs to work on PowerPoint presentations and online environments such as social media and website. Three correction rounds to be included. CMYK colors to be used: [67, 28, 86, 30], [17, 25, 76, 25], [17, 25, 76, 25], black, white Fonts to be used: DIN Condensed Pro Regular, Avenir Next Pro Condensed, Avenir Next Pro Condensed Demi
Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.
I have a website selling heat exchangers. It is in Czech language. Many of the pages are also in Slovak language. I would like to expose the web also in German language. The translations have to be written into existing html files containing Cz...cz/deskovy-chladic-oleje/ 500 words 100 words 1400 words 500 100 I can communicate in Czech and in English to assist you with translating. You should be able to use existing German heat exchangers websites (from competitors) to get explanation on terms/sentences where you are unsure how to translate them into German.
Who is the Czech who can help me translate the language from English into Czech?Kdo je dáma, která mi může pomoci přeložit jazyk z angličtiny do češtiny?
Poptávám kvalitní překlad článku z AJ do ČJ, nemusí se jednat o doslovný překlad. Quality translation of the article from English to Czech, it doesn´t have to be a literal translation.
Create a high-definition PSD template based on a predefined design and encode it into HTML and CSS. REQUEST A VALID CODE!
Hledám čechy, rodilé mluvčí, k překladům krátkých textů z angličtiny do češtiny.
Hledám někoho, kdo mi přeloží 3 strany dokumentace XML k účetnímu systému Abra do EN. Termín do pondělí 14.8.2017
Hledám někoho, kdo mi přeloží 3 strany dokumentace XML k účetnímu systému Abra do EN. Termín do pondělí 14.8.2017
Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
adsfjkl;'xfjl;, vzduukmvfhknm xkgnvxhdjfmxdjgmfhmbnvcgbnnkgjnbfkgnmfkgj
****Please read brief **** Multiple Language E commerce site (Czech, German, English, Polish) We will provide the translations Hello, I'm looking to extend my website (WordPress) and introduce an effective SEO friendly online store. We aim to create the online store under our current domain and server. We will accept cash upon delivery within a specific area, we will also accept bank transfer, Paypal, Google Wallet and Stripe payments. This E commerce site will need to be integrated into our WordPress theme (Avada). There is 6 food products we will sell online (not much) We have already purchased WPML and its associated plugins that can offer multiple languages. I am looking for an experienced professional to do this job. Please read this brief b...
Mujhse dosti karogi :P Mai pakistan se hoo, per rehta madina mai hoo, main new new ho freelancer per aapki id dekhi tu msg kar dia if u intrested kya hum dost bann sakty hai ?
Nastavení vytvořených Facebook účtu podle parametrů zadaných v excelu - změna jména, skrytí privatních informací (skrýt zeď pouze přátelé, skrýt kamarády pouze pro přátelů), pohlaví, pohlaví a nastavení nějakých like stránek z Czech Republic. atd. Já pošlu Excel po dohodnutí se na zakázce. První zadání je úprava 300 FB účtů.
...Side Social Media Options. 10. Categories Create Option and Select. 11. Trending Page + High View Post. 12. Search Home Page Option. 13. Footer Ads + Link Option. 14. Google Ads Option Manual and Auto. 15. App Listing: App link, Banner+Js Copy+FAQ+Footer Marquee Text 16. Brand Logo Change+ WhatsApp Link 17. Full Analytics All Website Like Every Days, Months, views+ Per Apps Views 18. Admin Pannel Multiple User Like I am Main Admin and My Another Team Members Post Apps+ Views Analytics 19. SEO Friendly URL 20. Sitemap Automatically Generated+ Frequently Daily Change I haven't chosen a design motif yet, so ideally, you're able to suggest and create designs that are user-friendly, attractive, and compatible with the features. In addition, no specific external integrations...
I'm in need of an Expert Excel programmer to help design a user-friendly Excel sheet focusing on stock and ledger management. Specifically, I'm interested in: - Incorporating Automatic Calculations: The ideal candidate should be able to create a system that automates complex calculations based on data inputs. - Dropdown menus: The sheet should offer an easy interface with dropdown menu options for hassle-free data inputs and editing. - Linking Stock and Sales: The sheet should be designed in such a way where the inventory updates automatically from sales data. So, a keen understanding of Excel's data integration and interconnection capabilities is necessary. - Essential Data Fields: My Excel sheet needs to inclu...
I just need a list of employees from Linkedin Recruiter.. I will get in a google-meet or zoom meet with you, and I give instructions. _We need to find the list of 'Open to Work' People from a particular Company in India. The reason for doing that is, We want to look for employees, who are considering Job switch from this company. _we will together log into your Linkedin Recruiter account _We will look for 'open to work' candidates _we will export the list (around 313 people) in CSV or Excel or PDF format. _If exporting the list is costly, in that case, I will simply take screenshots of the List (of candidates), and will later convert that into excel sheet. **The Task will take maximum of 10-15 minute time. Regards, Kashish Bhasin
Simple task, I need the background removing from this logo so it can be used online.
1. Develop a function that copies specific fields from Account records into corresponding Ticket fields automatically. 2. Develop a function that auto-fills multiple Ticket fields based on the input from a manually entered field. This function should dynamically pull data from the account database and populate the ticket fields according to the values entered. If your work meets our expectations, we may be interested in an ongoing collaboration for future projects across various Zoho applications (Desk, CRM, Campaigns, Projects)
10 Minute task on remote app AnyDesk - Disable the possibility of multiple clicks/submissions. - Prevent blank form submissions.
Need an extremely competent financial modeler in Excel who is capable of working with a lot of date math in formulas. You need to work on a working model template. NOTE: Do not apply if you are not genuinely capable of working with complex models. I am looking for help because I'm busy, not because I'm not capable! I make huge financial model templates on topics people don't model. I made a model on "ESOP" (Ownership structures for startups). ISSUE A client input dates in a way I didn't test and I realized I built in circular references I wasn't aware of. TASK Remove circular references (Need to change logic a bit to do it, which is not simple) Ideally break test to see how I messed up date math when dates are similar so won't be issues wi...
I am in need of a robust and efficient inventory management system made in Excel. This project requires: - Tracking of product quantities and managing stock levels to ensure seamless operation - Cataloguing of each product's relevant information including its name, SKU/Part number, quantity, batch number and expiry date - Methods of updating system quantities should be manual entry and bar code scanning. Knowledge in these methods is required. Ideal candidates should have extensive experience in Excel and inventory management system creation, preferably with a sound understanding of retail or related sectors. They should also be adept at implementing bar code scanning into Excel systems. Sharp attention to detail and ability to optimize for efficiency and usab...
...platforms will you post" for reference** Requirements: 1 article for product placement marketing about my Amazon clients' products.(and put the link to the product in your articles) [A new way to clean your pet's teeth] we can discuss and adjust the article if need these articles to at least 10 related news platforms/blogs in the US only. For example, post pet care articles to multiple USA pet care platforms. we can discuss and adjust the platform if need a report detailing which news platforms you posted to and which performed the best. us to quote your article for use on our social media,website and Amazon posts. if you meet those requirements please leave the information i need, Thank you. article: Presenting the best method for cleaning your dog
..."examples of your past work",and "how many platforms will you post" for reference** Requirements: 1 article for product placement marketing about my Amazon clients' products.(and put the link to the product in your articles) we can discuss and adjust the article if needed these articles to at least 10 related news platforms/blogs in the US only. For example, post pet care articles to multiple USA pet care platforms. we can discuss and adjust the platform if needed a report detailing which news platforms you posted to and which performed the best. us to quote your article for use on our social media,website and Amazon posts. if you meet those requirements please leave the information i need, Thank you. (article: Highlighting the importance of hea...
...complex schedules across multiple time zones. Key Responsibilities: -Manage and coordinate calendar for an executive, ensuring efficient scheduling of meetings and optimizing executive's time. -When Exec is on holiday: handle email correspondence, ensuring timely and accurate responses and flagging important messages that require executive attention. -Handle confidential information with integrity and discretion. - Respond to slack / whatsapp messages -Occasionally respond to a message during out of hours, though this is rarely required. Required Skills and Qualifications: -Exceptional command of English, both written and spoken. -Outstanding organizational skills and a keen attention to detail. Highly accurate. -Proven ability in managing calendars across multiple ...
I'm in need of a pro who can assist in adding multiple members to a WhatsApp group at once. The contact details will be forwarded to you via email. Key Requirements: - Adding multiple members at once to a WhatsApp group - Contact details provided via email - Sending confirmation messages to new members via WhatsApp Ideal Skills/Experience: - Proficiency in WhatsApp - Strong email management skills - Excellent communication skills - Experience in managing group memberships is a plus Please let me know if you're up for the job.
Hi Dezine Genius, I have a new project that I can offer you. We have worked multiple times. I would offer a 20 euro bonus plus the fixed rate if the end result is satisfactory.
Looking to upgrade my Shopify store on multiple fronts, seeking a professional with expertise in eCommerce and UX design. The ideal candidate would understand the luxury market and create a fitting online experience for my discerning customers. The task involves: 1. Layout and design: Turn my current layout into a minimalist yet luxurious environment that speaks to high-end shoppers. You can use a theme you want. 2. Navigation and user experience: Improve menu design, page layout, and other navigational elements for seamless interactions. 3. Product listings and search functionality: Modify the current system to become more user-friendly, enabling easy product search and exploration. The website is
...understanding of Google Sheets API and real-time data integration. App should be able to display rates, track order status, display quote of products and other basic tabs like upload of pdf documents of catalogues, contact us, about us and social media links etc. I have attached a basic pdf document of what the app should look like. Will need UI improvements in it too. Key Responsibilities: - Develop an Android application that dynamically displays data from certain cells in Google Sheets. - The app should be designed to pull updates in real time, refreshing every minute. - It should provide a manual refresh data option for immediate update. Ideal Skills: - Extensive Android app development - Knowledge and experience with Google ...
I’m looking for an Excel expert able to implement drop downs and inter sheet connections to manage my business ledger and stock updates on a weekly basis. Here are the project specifications: * There are currently less than 5 Excel sheets that need to be interconnected. * The primary intent of this interconnection is the cross-referencing of information. * The exchange of data to be implemented includes Inventory data, Financial data, and Sales data. The ideal candidate should possess advanced Excel skills, including knowledge and experience in cross-referencing various types of data across multiple sheets. Familiarity with business inventory, financials, and sales data is highly desirable. Ple...
...experienced Sales Representative with expertise in the Meat Industry, specifically within the UAE market. Your role will involve intensive market research and lead generation, focusing on the importation and distribution of chilled lamb from Australia, Kenya, and South Africa. Responsibilities: Conduct thorough market research to identify and analyze the prices and competitors within the UAE meat market. Identify and reach out to at least 40 potential suppliers, including wholesalers and importers, to obtain competitive quotes on chilled lamb varieties. Essential data points include: - Lamb Price per ton - Lamb Grade (e.g., 246) - Slaughterhouse number - Payment terms (e.g., cash on delivery) - Lead time (e.g., 1 day delivered to Dubai) Convert potential leads int...
I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.
I'm actively looking for a talented website developer to craft a cutting-edge B2C ecommerce platform from scratch. Due to certain preferences, no specific platform is required although experience with popular platforms like Shopify, Magento, and WooCommerce is advantageous. Key Requirements: - Proficient with developing B2C ecommerce websites - 100 products listing - Post sevice support - Open to utilizing any established ecommerce platforms - Ability to integrate multiple payment gateways, specifically debit/credit card and Google Pay options Ideal Skills and Experience: - Prior experience in ecommerce website development - Familiarity with a variety of ecommerce platforms - Proven track record in integrating diverse payment gateways.
Following are the requirements of task to be fulfilled. 1- Task is to visit the Gottingen physically and Take 5 to 6 geotagged photos of with name board captured and from outside the building. 2- Get the verification form filled, signed and stamped by the HR and also stamp the certificate. 3- Get the details of verifier, Name, Designation, Department and Contact. 4- In case of refusal to fill form, take the written refusal with stamp or sign as a proof. 5- If companydoes not found on given address than take the 7 to 8 geotagged photos of exact address with right left name boards photos and make a small few seconds video of address . Also get the details of any nearby business ( Name of person, Business name and Contact
...that can crawl through a list of websites provided in an Excel file and export all the webpages it finds into a new Excel file. This task is aimed at scraping the entire content of the websites, not just a specific piece of information. Key Requirements: - The script must be able to read a list of websites from an Excel file. - The script should use natural crawling mechanisms, not sitemap, to find all the webpages on each website. - All the webpages found on the websites should be exported into a new Excel file. The purpose of this script is to aid in analyzing the content of these websites, so it's crucial that all pages are scraped. Ideal Skills: - Proficiency in Python programming, particularly web scraping. - Knowledge of Excel fil...
...Requirements: - Payment Gateway Integration: The website must support multiple payment methods, including Credit/Debit Cards, PayPal, Bank Transfer and Upi. It should ensure a secure and hassle-free donation process. - User Information Collection: During the donation process, the website should collect the donor's Full Name, Email Address, and Mailing Address. This data is crucial for maintaining donor records and sending acknowledgments. The ideal candidate should have: - Proficiency in web development, with a proven track record in creating secure, user-friendly websites. - Experience in integrating various payment gateways, especially Credit/Debit Cards, PayPal, Bank Transfer, and Upi. - A keen understanding of ethical data collection practices and privacy ...
I require an expert in Excel to build a comprehensive tracking file. This task involves: - Establishing a data entry form to easily input inventory and project progress details. Knowledge of creating user-friendly interfaces within Excel is beneficial. - Implementing automated calculations to streamline the data analysis process. Strong mathematical and analytical skills are essential. - Creating a graphical representation of data to facilitate understanding. Experience in data visualization is a must. The spreadsheet will track fewer than 10 types of inventory data and project progress data. Your familiarity with inventory management processes and project tracking would be highly valuable. This assignment calls for you to use Exce...
I am looking to streamline my excel data entry process. Needs centralized on the automation of numerical data entry in my Excel spreadsheets. Key requirements: - Automate simple data entry into few columns. - Experience with Excel data entry automation required. - Should have good knowledge of Excel functionalities and automations. - Ability to handle numerical data efficiently. Experience in handling simple data entry (few columns) and automating the same would be ideal for this job. Reach out if you need more information and looking forward to your expert assistance in this process improvement.
