Excel vba code download historical data yahoo jobs

I need an Excel spreadsheet specifically designed for data entry and storage of inventory lists. The file should be user-friendly with clearly defined sections for different aspects of inventory management. It's for a property company, simple schedule of type-rents etc. Based near Chelsea.

I need assistance with an Excel formula that's getting an error. I'm trying to get a cell to populate with the next date, but I need it to ignore certain instances. I am unsure which specific lookup function I am using. - Ideal Skills: Proficient in Excel, experienced in complex formula creation and troubleshooting. - Experience: Prior experience with date manipulation in Excel is preferred.

...to assist with data entry and creating a customized Excel worksheet. The project involves: - Total no. 600 restaurants. The online ordering Menu of these restaurants is to be copied into an Excel CSV sheet, from the website ( provided after the award ) and then arranged in a predefined header format which will be as attached. Images of the dishes where available are to be saved in jpeg format for each restaurant in a folder The Excel CSV menu sheet and downloaded image folder shall comprise a single separate folder named for the restaurant Creating Excel worksheets with predefined headers for a system database - Storing mixed data types in the worksheet - Utilizing a provided list of specific headers and column names Ideal candidat...

I'm looking for a creative graphic designer to design a new logo for our Christian school, Northside Christian Warriors. The current logo is outdated and needs a modern touch. - Warrior Style: The logo should feature a fantasy warrior. This could be inspired by mythical or imaginative combatants, rather than historical knights or contemporary soldiers. The aim is to create a unique and eye-catching representation of a warrior. - Logo Elements: The logo should include a shield, sword, and helmet. These elements should be integrated in a way that is visually pleasing and represents the spirit of our school - strength, courage, and faith. - Color Scheme: The primary colors of the logo should be Blue and Gold. These colors are not only the school colors but also represent trust, l...

I'm seeking an Excel specialist to analyze my survey results and create a PowerPoint presentation from the findings. Requirements: - Expert-level Excel skills, particularly with pivot charts - Proficient in PowerPoint - Able to analyze survey data comparing year-to-year numbers to illustrate growth by different categories - Able to conduct a demographic breakdown based on location and occupation

I need an experienced JavaScript developer to create for me funny js code in 1 h maximum the code should be hard to read from non developer , with no alert or console log or comments the result should be Glory()= great so the funny thing in the code is about finding the value of great and when dev start reading the code should not expect that the value will be great Glory is company name which combine mutiple teams and teams will collaborate with each other to reach that value this info help you to express that in the code can you share example of your code related and can do that Please no use AI for that the code should be a abit long to make reader not understand it quickly or expect the result please do it in funny and creativ...

Please Sign Up or Login to see details.

I need a QuickSight dashboard that connects to both databases and CSV/Excel files. The dashboard should be able to display data using tables, pivots and filters. Ideal skills for this project include: - Proficiency with Amazon QuickSight - Experience with database and CSV/Excel file integration - Ability to create and manipulate tables, pivots, and filters - Strong understanding of data visualization techniques

I have a master Excel spreadsheet filled with various product-related information. I'm looking to create ten additional tabs that all pull filtered data from the master sheet, organized by product categories. Key Requirements: - Experience in Excel is a must. - Ability to create interconnected tabs that update in real-time with the master sheet. - Strong communication skills for regular updates and clarifications. Please note, the data on the additional tabs will be filtered by category. It's important that you understand product categorization and can effectively segregate the data. Your attention to detail and ability to manage complex data sets will be key to the success of this project.

I need help finding high-quality, freely available downloadable dataset/links on consumer behavio...ready-to-eat or cooked food. Also, I need assistance in creating related questions on which the dataset is based. The datasets/questions should be in Excel format. Key Aspects of Consumer Behaviour to Explore: - Purchase frequency - Brand preference - Consumption patterns - Additional parameters for in-depth analysis Other Considerations: - Demographic information - Spending habits - Product satisfaction - Sustainability considerations - Customer satisfaction The freelancer will also be required to assist in formulating relevant questions based on the dataset. Ideal skills for this project include: - Data analysis - Market research - Excel proficiency - Understandi...

I'm seeking a professional to enhance the functionality of my Excel sheet. The main focus will be on refining formulas and functions to improve automation and integrating macros for more efficient operation. - Key Areas of Improvement: - Optimizing existing formulas and functions - Implementing automation techniques - Designing and integrating macros Ideal candidates should have extensive experience with Excel, particularly in the area of automation and macro creation. Please provide examples of previous work that demonstrate your ability to improve Excel sheets.

...specific URL, verify it, fetch the corresponding file from Envato, and generate a direct download link for the user. Key Components: - Envato API Integration: Establish a seamless and efficient connection with the Envato API to validate user-provided URLs and retrieve associated files. - User Panel: Design a clean, intuitive interface for users to input URLs and view validated download links post-processing. - Admin Panel: Implement a control center for managing user requests, and configuring API keys, limits, and other system parameters. - File Download: Ensure the system facilitates direct downloads of files sourced from Envato URLs. - Security: Prioritize the security of API connections and download processes. This includes implementing authentication c...

I need assistance with my financial Excel file. The project involves: - Data Entry and Organization: Help me organize my existing data in a more coherent and usable manner. - Formulas and Calculations: Apply relevant formulas and perform necessary calculations to derive insights from the data. - Creating Charts and Graphs: Visualize the data using various charts and graphs to highlight key trends and patterns. The existing data is all in Excel format and I need this data to be incorporated into the analysis and visualization. Ideal Skills: - Proficiency in Excel, including advanced functions and formulas. - Experience in financial data analysis. - Skills in data visualization and creating charts and graphs in...

...suppliers do NOT provide complete data or images. Being able to effectively get the information online efficiently is needed - Proven experience as a Product Manager in the retail industry is a must. - Strong understanding of the B2B market and how to effectively meet its needs. - Deep knowledge of Magento 2 as you will have to create configurable products. - Your job will be to determine attributes / categories for products using information available online (you will have to research the brand of products you are importing) - A deep knowledge of how Magento Manages Attributes is essential - Some suppliers use standardized data (PIES, ACES, Digital Asset) - some other suppliers do NOT use standardized data. It is important to be able to use Standardized data...

I'm seeking an Excel expert to assist with my spreadsheet. I need help with creating and modifying formulas, writing VBA scripts, and troubleshooting existing issues. The spreadsheet has some minor discrepancies that need to be corrected to enhance data accuracy and improve the user interface. Ideal Skills: - Advanced Excel skills - Proficiency in writing and modifying VBA scripts - Strong troubleshooting skills - Experience with data accuracy improvements - User interface design skills in Excel The goal is to tighten up the spreadsheet, improve its performance and make it more user-friendly.

I need assistance extracting data from 100-150 scientific articles. The data to be extracted includes statistical data and references/citations. The extracted statistical data needs to be delivered in an Excel spreadsheet. Additionally, I need data from tables within the articles to be included. Ideal skills for this project include: - Experience with data extraction - Familiarity with scientific literature - Proficiency in Excel The successful freelancer will be detail-oriented and able to work independently.

I'm in need of comprehensive data from Google Scholar for a personal project. The specific data points required include: - Article metadata: This will help me understand the context and relevance of the articles. - Citation counts: This will provide insights on the impact and reach of the articles. - Author profiles: This will assist in identifying key contributors in the field. The data should be delivered in Excel format. Ideal skills for this task include: - Proficiency in data extraction and web scraping - Familiarity with Google Scholar - Expertise in data organization in Excel. Experience in handling academic data and conducting market analysis would also be advantageous. Please ensure you can deliver the data ...

I'm looking for a straightforward Python script that can scrape text posts from Facebook groups I'm a member of. The primary purpose for this is data analysis, and I would like the scraped data to be delivered in a CSV file. Key requirements: - Proficient in Python, with experience in web scraping - Familiarity with Facebook's structure and privacy considerations - Ability to code a solution that filters for text posts only - Can provide the data in a well-structured CSV format This project is ideal for someone who can deliver a reliable and efficient scraping tool, and understands the importance of ethical scraping practices. Please include examples of similar projects you've completed in your bid.

PS : BIDS WITH NO EXAMPLE OF THEIR WORK WILL BE REJECTED I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initia...

I'm looking for an Excel expert to create a comprehensive and dynamic dashboard from my dataset. Key Requirements: - You will be working with 518 rows of data across 36 columns. - A summary sheet needs to be created per my specifications, which will be provided in the attachment. - Each cell in the summary needs to be hyperlinked to the corresponding data point. - The dashboard should be dynamic to accommodate potential future data additions. - All Excel formulas must be shared with me. Communication: - I expect all queries to be answered within 30 minutes of me asking. Preferences: - The summary sheet should feature both visual (bar charts) and tabular representations of the data. - The dashboard should include interactive filters, drill-...

I need a Python developer to integrate a Telegram bot with Python code that will execute predefined terminal commands. The system should take messages which are broadcasted to the bot and execute the corresponding command. Key Requirements: - Python programming skills - Experience with Telegram bot development - Familiarity with terminal commands - Knowledge of MySQL for querying The primary goal of this project is to automate the execution of specific tasks via the Telegram bot. The user will interact with the system by sending MySQL queries, which the bot will interpret and respond to. The ideal freelancer for this project should be able to help me with the following: - Executing predefined commands - Using MySQL queries to trigger these commands - Ensuring the system can take m...

I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/password. • Differ...

I require an Excel expert to create macros and VBA scripts to transform my imported Excel data into a specific format. The necessary modifications span across data formatting, calculations, and filtering. You will need to adjust: - Headers - Columns - Rows The data will be imported from another system, so I need a professional who is skilled in data manipulation and can ensure the output is consistently formatted according to my requirements. The format of excel before editing & after editing are attached for your final product should come with a button "Format" which can convert my excels to my required format. NOTE: I need to see your previous works in Excel macros & VBA before awarding this wor...

I'm looking for a freelancer who can scrape a public website for contact details. The information I need includes email addresses, phone numbers, and names. This is a one-time project. ...a public website for contact details. The information I need includes email addresses, phone numbers, and names. This is a one-time project. Ideal Skills and Experience: - Proficient in web scraping techniques and tools - Prior experience in data extraction - Attention to detail to ensure data accuracy - Understanding of privacy laws and ethical standards in data collection This is the website: We need the following information: - Name - Adress - E-Mail - Phone number You find an example in the attached Excel file. Please add all other contacts in the same manner.

...descriptions, promotional materials, and offers from the Lemonsqueezy affiliate network. Download or collect promotional resources from the Lemonsqueezy affiliate backend: Step 2: Tool Verification Visit each provided tool link. Verify if the link corresponds to an online tool or service: If it is a valid online tool or service, proceed to the next step. If it is not, record the reason in an Excel sheet (e.g., "invalid link," "non-tool," etc.) and skip it. Step 3: Organize Tool Content Prepare and organize the following information for each tool: Classification: Choose the appropriate category based on the tool’s primary function. Website Icon: Download or screenshot the tool’s logo from its website. Website Screenshot: Ta...

...Invoice management and payment history. Customer Support Module • - Integrated ticketing system for issue resolution. • - Live chat and chatbot support. • - Knowledge base with FAQs and guides. Quality Assurance Module • - Third-party quality checks at milestones. • - Compliance certification for building codes. • - Post-construction maintenance support options. User Journey Flow For Homeowners • - Download and install the app. • - Sign up and create a profile. • - Select 'New Project' and fill out project details (type, size, budget). • - View cost estimation and approve the project. • - Select materials and services from the marketplace. • - Track progress, milestones, and payments. • - Communicate with ...

I'm looking for a detail-oriented and proficient professional in MS Excel to assist with data entry. The primary task will involve entering customer information, specifically names and contact details as well as demographic information, into a provided CSV template. This data will subsequently need to be imported into WordPress. Key Responsibilities: - Accurately input customer information into the CSV template - Ensure the data is ready for seamless import into WordPress Ideal Skills: - Exceptional attention to detail - Proficiency in MS Excel - Previous experience with data entry - Familiarity with WordPress is a plus I have a template for the CSV file, so you won't need to create one. However, I expect the data to be meticul...

I'm in need of a data extraction expert to help me gather information from a specific website. The dataset contains approximately 200,000 entries, and I'm looking to filter for contacts from a specific location. Key Requirements: - Export data fields: Name, Email, Designation, Company Name, - Data to be delivered in Excel format - Experience with web scraping and data extraction - Ability to filter data by specific location Compensation: I can offer 20-30 paisa per contact.

...KPIs. Generate detailed historical reports. Provide a user-friendly and ergonomic interface, optimized for desktop and mobile screens. Budget and Deadline (Please Read Carefully): Budget: €500 - €1,000 (Fixed). Deadline: 2 weeks maximum. Applications exceeding the budget or timeline will not be considered. Key Features: Real-Time Map: Track drivers and passengers live on a map. Display active trips with pickup and drop-off points. Heatmaps to show areas with high demand or low supply. Well-Organized KPIs: Track drivers, passengers, trips, and revenue. Clearly display statistics in an interactive and accessible way. User Profiles & Reports: Detailed profiles for drivers and passengers (with activity and performance history). Exportable historical reports ...

**Request for...through a structured interaction, allowing them to choose from predefined topics and subtopics. 2. **Dynamic Question and Answer Selection**: After selecting a subtopic, users should be able to choose a specific question from my database, and the chatbot will display the corresponding answer. 3. **Database Integration**: The plugin must use my existing Excel file, which contains questions, answers, and associated topic tags, as the data source. 4. **User-Friendly Interaction**: Ensure the chatbot provides an intuitive and seamless experience for users. 5. **Brand Compatibility**: The chatbot’s design should align with my website’s branding and overall look and feel. Please share your experience with similar projects and provide your pric...

I'm Anup Kumar from India, proficient in Excel, Word, PDF files, content writing, copytyping, retyping, and translating all languages. I'm seeking assistance with a variety of tasks, including document formatting, content creation, and language translation. The ideal freelancer for this project would be someone who is also adept at writing engaging blog posts, compelling website content, and catchy product descriptions. Skills and Experience Required: - Advanced knowledge of Excel and Word - Excellent content writing skills - Proficient in document formatting - Skilled in language translation - Experience in writing for blogs, websites, and product descriptions - Strong copytyping and retyping abilities Please note that the tasks will cover all aspects of cont...

Do analysis and create data visualize for company product

...are seeking a proficient developer to create an application for iOS, with further plans for Android and Web platforms. This app is aimed at promoting and distributing our eBook, with the goal to enhance its visibility, engagement, and ultimately, sales. Key Features: User Login and Registration: -The app should have a secure and user-friendly login and registration system. eBook Purchasing and Download: -A seamless interface for purchasing and downloading the eBook is crucial. Content Preview or Sample Chapters: -The app should allow users to preview content or read sample chapters. Design: The application should boast a modern and sleek design. The user interface needs to be intuitive, appealing, and easy to navigate. Ideal Skills: -Proficient in iOS app development, with kn...

Extend an existing MySQL cursor with additional logic to perform 9 calculations based on formulas (provided in Excel) and update another table using IF conditions. Ensure efficient database execution and minimal overhead. Deliver optimized code with minimal documentation for easy understanding of the added logic and calculations. Completion expected within 2-3 days.

...UK's property and construction industry with precise, cutting-edge data solutions. As the fastest-growing PropTech company in the UK and the leading supplier of planning data, we power 70% of all property transactions, providing large enterprise partners with the most accurate and reliable data available. Our SaaS platform not only automates data handling to streamline operations and boost productivity but also uncovers new business opportunities by connecting businesses with prospective customers. With unmatched data accuracy, we empower organisations to make smarter decisions, drive growth, and generate valuable leads. About this Role We’re a dynamic, driven, and ambitious startup, and we’re looking for a proactive Data Pol...

I'm looking for an advanced Excel expert who can create a roster maker for me. This should be an Excel sheet that leverages automation with macros to help manage and create rosters for multiple shifts per day. Key Features: - Handling of multiple shifts per day: The roster maker should be able to accommodate AM, PM, and ND (night) shifts. - User Inputs: The sheet will need to take in employee names and IDs, shift totals, and contracted hours. - Complexity: This isn't a simple roster maker. It will need to use a range of formulas and conditional formatting, along with the automation through macros. Ideal Skills: - Expertise in Excel and VBA for Macros - Experience with creating complex scheduling tools - Ability to understand and implement conditional...

I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/password. • Differ...

I'm looking for an expert in Excel who can help me manage various aspects of my business using this powerful tool. Key Responsibilities: - Inventory Management: Track and manage stock levels, shipments, and purchases. - Financial Calculations: Assist with budgeting, forecasting, and expense tracking. - Data Analysis: Examine sales data, transportation costs, administrative expenditures, and stock valuations to derive actionable insights. Ideal Skills and Experience: - Proficiency in Excel with a strong understanding of custom formulas. - Experience with creating automated reports and dashboard visuals. - Background in accounting and customer relationship management (CRM) is a plus. - Ability to create user-friendly dashboards for easy navigation and unde...

I'm looking for a PHP script that allows me to view and download Instagram stories without the need for user authentication. The script should also download stories if customer wants. I DON'T NEED DESIGN FOR THE WEBSITE; Just for the script. I'll do the design myself. Key Requirements: - PHP Script to view and download Instagram stories - Download video stories and image stories - No user login or authentication required Ideal Skills and Experience: - Proficiency in PHP - Experience with Instagram's API (or similar) - Prior work with creating viewer and downloader scripts

We need a GIS expert to assist in our mosquito larvicide distribution project in India. We aim to create local maps 0.5 KM radius of stagnant water with roads and landmarks. we want to offer this map to our e-commerce customers whose pin codes we know. we will get 3 days to create maps Key Responsibilities: - Utilize satellite imagery to identify areas of stagnant water. - Map these areas alongside roads and landmarks for easy navigation and understanding. Ideal Skills: - Proficient in GIS software and satellite imagery analysis. - Experience in creating detailed, user-friendly maps. - Ability to work at a village-level scale. Your expertise will help us effectively reach and assist communities in need, ultimately contributing to the reduction of mosquito populations in these areas.

I'm looking for a talented costume designer to create a unique, mens-fashionable ninja inspired costume that blends elements of traditional ninja attire with modern streetwear aesthetics. Key Requirements: - The co...create a unique, mens-fashionable ninja inspired costume that blends elements of traditional ninja attire with modern streetwear aesthetics. Key Requirements: - The costume should be primarily made of high-quality, comfortable, breathable fabrics. - A strong understanding and capability in mens fashion design is essential. - Experience in costume design is a plus. - Creative ability to merge historical and contemporary styles. must be able to create outfit, then make it custom to measurements Australia preferred but not essential Preferable to be able to cr...

...- Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont waste your time and bid If you have exp...

I am working on a MATLAB project that involves curve fitting and deducing a transfer function from measured data. I need help with: - Reading data from an Excel sheet and plotting the graph between two variables. - Reconstructing a curve that fits the measured data. - Fitting a higher-order transfer function to this curve. I plan to use the Optimization Toolbox for this project. I would appreciate your assistance in completing this project effectively. I will provide multiple measurements in form of excel sheets(along with the basic code) and fitted curves along with MATLAB codes are required .

I need someone to extract data from my invoices and enter it into Microsoft Excel and then into both a desktop and a cloud-based application. Key Tasks: - Extract data from invoices - Paste data into Excel - Enter data into a desktop app and a cloud app Ideal Candidate: - Familiarity with data extraction and Microsoft Excel - Experience with both desktop and cloud-based applications - Attention to detail to ensure data is entered accurately

Move code from theme to plugins only (Urgent)

...seeking an R programming expert to assist with my research project. The primary goal involves extensive data analysis, statistical modeling, and data visualization. I have a set of CSV files that contain the data from my research, and I need help with the following tasks: - Reading and cleaning the data from the CSV files - Performing statistical analysis - Creating visualizations to illustrate the findings Ideal candidates for this project should have a strong background in R programming, data analysis and visualization, and experience working with CSV files. Hello,I hope you are having a good day. I would like your help with r-coding. The topic that i have to develop further with R-code is: “Exploring the Causal Impact of Climate Var...

I'm looking for a skilled Excel expert who can transform my investment portfolio data into a user-friendly, dynamic spreadsheet. Key Requirements: 1. Create a comprehensive, dynamic Excel table capturing all of the client's investment positions. 2. Organize information into dedicated columns for each data point (e.g., ISIN, Name, Price, etc.) 3. Utilize advanced graphic design skills to present the data in an intuitive and visually appealing manner. The aim is to create a UX-friendly information table suitable for individual investors. 4. Include a dedicated column with links to Yahoo Finance or Investing.com. Each link should correspond to the historical chart data of each investment position. Ideal Skills: - Proficient ...

I need immediate assistance in resolving some issues in Power BI. Main issues: - Dates not displaying in correct order in a chart. - Need help with displaying employee hierarchy data in an organizational chart. Data Source: - Current data source for my Power BI report is an Excel file. Ideal skills and experience: - Proficiency in Power BI is a must. - Experience with Excel as a data source. - Ability to create and troubleshoot organizational charts. - Strong problem-solving skills for date sorting issues.

I'm looking for a professional who can proficiently analyze data using Excel, specifically looking at descriptive statistics. In addition, I need assistance with managing and strategizing my social media ad campaigns. Ideal candidates should have: - Strong expertise in Excel, particularly in data analysis - Experience in working with descriptive statistics - Proven track record in managing social media ad campaigns - Skills in creating compelling ad content - Ability to interpret data and adjust campaigns accordingly Please provide examples of your previous work related to this project.

I need help with my Framer project. In a custom-coded download button, the download link is active only on half of the button. I can only use half of it, and I need to be able to use the entire button to download a PDF file. Ideal skills for this project: - Proficient in Framer - Experienced in custom coding - Strong understanding of interactive design