Excel connection add example vbaprá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.

Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.

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.

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í.

Customizing the spellchecker I will add dictionaries and rules for hunspell. Interlingo language see: Required skills: MS Visual Studio, C #, MS Office, Git

Přizpůsobení spellcheckeru Slovníky a pravidla pro hunspell dodám. Jazyk interlingva viz: žádané dovednosti: MS Visual Studio, C#, MS Office, Git

POtřebuji napsat indikátor pro market analyzer na ninjatrader 8. Bude to kolonka, kde se napíše ano x ne x poslední, podle toho, jaké bylo volume. Pokud ano, tak bude 1,5x větší volume, než je průměr za posledních 10 svíček.

datae

datae

mise en forme

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

Napraviti Excel VBA program

...vytvořená na míru našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dok...

I need a detail-oriented professional to help with my bookkeeping and prepare financial statements using Excel. Key Responsibilities: - Regularly update my Excel spreadsheets with day-to-day transactions - Prepare monthly financial statements for my business Ideal Skills & Experience: - Strong Excel skills, including advanced functions and formulas - Experience in bookkeeping and financial statement preparation - Attention to detail and a good understanding of accounting principles Please note: - The role is likely to require around 10 hours of work per month - I may consider transitioning to a more robust accounting software in the future, so experience with QuickBooks or Xero would be a plus.

I'm looking for a skilled analyst to examine and arrange a substantial set of numerical data using Excel. The primary purpose of this project is to facilitate thorough data analysis. However, the data's arrangement or layout has yet to be defined, and I'm open to suggestions from the freelancer on how best to structure the data for optimal analysis. Ideal Skillset: - Strong background in data analysis and numerical data - Proficient in Excel, including its advanced functions - Ability to suggest and implement data arrangement strategies in Excel This project will require strict attention to detail and excellent organizational skills. So, if this project is up your alley, don't hesitate to bid.

I need assistance in a data entry project. The task involves inputting numerical and textual data from digital documents into an Excel sheet. Skills and Experience: - Proficient in Excel - Must have accurate and fast typing skills - Prior experience in data entry jobs This job requires the utmost precision and accuracy, as the entered data will be used for important business processes. A keen eye for detail and a high degree of data accuracy are important for this role. The successful candidate should have the ability to read, understand, and input data efficiently.

Seeking a skilled programmer adept in WordPress for custom coding work and form layout adjustments. Requires proficiency in backend management, specifically relating to data capture, viewing, and exporting in Excel format. A highlight of the project entails the customization of our existing WordPress theme and the integration of new, unspecified features. Lack of detailed request emphasizes the need for a freelancer capable of intuitive problem solving. Primary tasks include: - WordPress custom coding - PDF form adjustments - Data capture and export to Excel Ideal candidate should have knowledge and experience in custom coding, WordPress navigation, and form data handling. Exceptional problem-solving skills are highly appreciated. Undefined project elements call for a creat...

I'm urgently requiring a resourceful developer to create a tailor-made HR dashboard for our company. T...understanding of HR-related metrics. Key Features: - The dashboard should prominently feature recruitment metrics and performance evaluations. Recruitment Metrics Include: - Time-to-hire - Cost-per-hire Performance Evaluations Indicators: - Retention rate The dashboard should present these metrics in a clear, accessible format, preferably utilizing visually-pleasing graphs and charts. To excel at this project, the developer should have significant experience working on similar projects, a keen eye for design, and a knack for turning complex data into easy-to-understand visuals. A truly comprehensive understanding of HR metrics and how to effectively display them will b...

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

I'm looking for a freelancer with expertise in data entry to assist with tasks in Excel. Tasks: - You'll be working to enter data into an Excel sheet. Nature of Data: - The data to be entered will be a mixture of numerical and textual. Size of Project: - You'll be handling an Excel sheet containing between 100-500 rows and columns. Required Skills: - Proficient in Microsoft Excel - Fast typing skills with a strong attention to detail. - Strong numerical and textual data entry skills.

I'm seeking a proficient C# developer, skilled in the .NET framework for a project. The exact application type is still to be confirmed. You should have: - Strong experience with C# programming. - Understanding of .NET framework. - Ability to work without strict time constraints. Time frames and further project details will be discussed upon connection. Looking forward to working with a focused and motivated professional.

Hi Ashish, this is for the tasks I emailed about.

I'm looking for a detail-oriented freelancer to help me with an Excel data entry project. The task primarily involves typing text from scanned documents into my Excel sheet. **Key Requirements:** - Accurate typing of text from scanned documents into Excel - Organizing the data into tables and lists **Skills Needed:** - Proficient in Microsoft Excel - Attention to detail to ensure accuracy - Experience in data entry, ideally with scanned documents - Ability to organize data into tables and lists The ideal candidate should be comfortable working with scanned documents, have a knack for accuracy and attention to detail in typing, and be able to organize the data effectively into tables and lists in Excel.

I'm in need of an expert who can develop a risk assessment model for Cmbs SASB. The main g...of this project is to identify and analyze risks associated with my investments. Key Project Details: - The primary focus will be creating a risk model for Cmbs SASB. - I will provide third-party analytics data which you will need to integrate into the model. - The development and implementation of this model will be done using Excel. Ideal Candidate: - Prior experience in financial risk assessment, ideally involving Cmbs SASB. - Proficiency in Excel is a must, as this will be the main tool for developing the model. Please provide any relevant past work or experience that you think aligns well with this project. We can discuss further details and expectations once...

I have a set of printed documents that need to be transcribed into an Excel sheet for easy access and analysis. The data is primarily textual, composed of various types of written information. Requirements: - Expertise in data entry, particularly with Excel. - Proficient in English to accurately interpret the text. - Experience with printed document transcription is preferred, but not required. The ideal candidate must be detail-oriented and meticulous, as the accuracy of the data entry is crucial.

I have a project which involves transferring text data from PDF documents into an Excel sheet. The data is purely text-based and will need to be accurately inputted. The ideal freelancer for this project would: - Have experience with Excel data entries, especially involving text - Be proficient in working with PDF documents - Have previous experience in data import from different formats Your job will largely involve: - Importing data from PDF files into Excel accurately - Ensuring correct data input without losing any details - Maintaining the original structure and formatting wherever necessary Please ensure the completion of this project in a timely and precise manner.

I'm searching for a detail-oriented freelancer with extensive experience working with Excel. - This task involves typing text data into an Excel spreadsheet. - The data entered will be a mixture of both structured and random entries. Thus, a keen eye for detail and the ability to maintain organization amidst complexity is key. - As a crucial aspect of this project, I require error checking to ensure the highest quality of work. The ideal candidate should have experience and knowledge in Excel data validation. - For successful completion of this project, accuracy and attention to detail are paramount. Candidates with previous background in similar tasks will be highly regarded.

- Please do no...time. Please look this up before applying. ------------------- Engage in 1-on-1 conversations with subscribers on OnlyFans. Foster a positive and engaging atmosphere to keep subscribers entertained and coming back. Provide regular updates and feedback to the team. ------------------- - Must be 18+ - Must have at least a near-native level of English - Have a stable workstation and Internet connection - Comfortable viewing and selling explicit content - Ability to build virtual girlfriend experience with subscribers - Must understand the Psychology behind OF chatting ------------------- - We offer 6 hour shifts in a completely remote working environment. - Starting Salary is between $7.50 and $10 per hour, depending on your skill level. - Payouts are made ever...

I require a meticulous individual who is adept at data entry into Excel, with precision and accuracy being top priorities. - The task involves entering various types of data, including numeric, text, and alphanumeric, ensuring it is correctly and appropriately categorized. - The Excel sheet will consist of two columns which will require careful management for data uniformity and consistency. - The entered data should be organized based on the input order, therefore, attention to chronological details is paramount. The successful bidder should have proficient data entry skills and a keen eye for detail for successful completion of this project. Prior experience in similar projects would be an advantage.

I have an unfinished Flutter app that requires a skilled individual to handle its database connection. The app is designed and now, I need help connecting it to a MySQL database using an API. Key Responsibilities: - Complete the database connection for my Flutter app - Utilize MySQL to store the following data types: user profiles and authentication, transactional records, content and multimedia files Ideal candidate: - Proficient in Flutter and experienced in developing Flutter apps - Skilled in MySQL and API integration - Familiar with handling user data and transaction records securely - Strong background in data storage and retrieval for content and multimedia files This project is not for a business, but rather a personal venture. Your expertise will help me bring my...

Please read the attached instruction sheet along with below details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+s...image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if the brochure /excel or images (provided twice by us)has got duplicates 4) If the images are not clear as per the 900 X 700... YOU shall consider the image from the website. we will share you the link for your understanding if you require the a...

I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.

I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish...

...function and durability for horse and rider. My saddle blankets run a panorama of colors, from the elegance of the "Asheville" design with its’ soft pink and grays to the bold blend of firey colors in "Fireball Whiskey". After a decade of creating original, show stopping, designs in my hand woven cinches and breast collars, moving to unique saddle blanket designs came naturally. My deep connection and love of all nature are key inspirations in my designs. Wild Ride Saddle Blankets will shine in the Show Ring, on the Ranch and on the Trail. “Wild Ride” saddle blankets are for those who understand quality, hard work and an entrepreneurial spirit … for the MAVERICKS, the true-hearted who aren’t afraid to stand out in a cr...

I am facing an issue on my Windows system where the internet disconnects every time I connect to my OpenVPN. This issue is significantly impacting my ab...OpenVPN. This issue is significantly impacting my ability to work remotely and access the resources I need. Key Points: - The issue started occurring when I began using OpenVPN. - I work on my system and the VPN is a critical part of my workflow. - The problem is specific to my Windows operating system. I am looking for a professional who has: - Profound experience with troubleshooting VPN connection issues, especially with OpenVPN. - Strong knowledge of Windows operating system networking and its interaction with VPNs. - Excellent communication skills and can guide me through the troubleshooting process in a clear and understan...

...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant app...research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...

Java based app backend for tourism activities need 2 things. 1 - add a copy activity in activity page to copie a existing activity content to a new one 2 - migrate backend from vps centosOS to cpanel based hosting.

I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...

...technology, MetaMatch aims to revolutionize fan interaction with sports through the integration of NFTs and real-time event engagement. The logo should encapsulate the essence of blending traditional sports with cutting-edge blockchain technology, appealing to both tech-savvy and sports-loving audiences. Specific Requirements: Concept and Design: The logo must convey a sense of innovation and connection, symbolizing the fusion of real-world sports and blockchain technology. It should be modern, easily recognizable, and scalable for use on various platforms and sizes. Color Scheme: We are looking for a color palette that stands out yet feels intrinsic to both the digital nature of blockchain and the dynamic energy of sports. Suggestions include, but are not limited to, combinat...

...published on a separate WordPress site. Ideal skills for this project include: - Strong understanding of WordPress development - Experience with creating custom plugins - Familiarity with WordPress APIs and data handling - Ability to work with cross-site data transfer The project requires: - Setting up a user-friendly form for registered users on Website A to create posts - Establishing a connection between Website A and Website B for seamless post transfer - Ensuring the posts are published immediately on Website B I'm open to your suggestions for user information that could be included in the post transfer, and I would appreciate your input on best practices for this kind of cross-website integration. Your input on potential security considerations for such integrati...

...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...

I would like to design standard operating procedure (rules of lead engagement) based on large medium and enterprise segments- 1) how should sales consume the leads once a lead is assigned to the sales reps. 2) Define the stage movement timeline from one stage to another in salesforce based on which stage the lead is in. 3) How long to wait to send a follow up email /call after the two way connection has been established. 4) Reason to close or recycle the lead 5) Activities logged in salesforce. etc.

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes...- Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of stock management ...

i have a form created with HTML and PHP. user has to fill in information and when press submit, it should insert infos in database. But sometimes it doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload data in realtime. as soon as user finished typing in 1 field, it should store data. when uploading, it should show loading icon near input field. if succeed, green vink icon. if not, red cross icon. when user finish, user can click submit button which will echo all data stored in mysql database on same page in lightbox. image attached. Budget is $35. if you want more, please do NOT bid. budget is $35

More details: What is the desired color scheme for the HTML emails? Vibrant colors What type of data is being displayed in the emails? Graphs and charts How sophisticated should the timeline image design be? Moderate complexity with some unique elements