Excel macro example filling cellsJobb

I require a highly skilled Power BI professional to automate reports based on customer data currently stored in Excel spreadsheets. Tasks: - Familiarize themselves with the data structure in our Excel spreadsheets. - Use Power BI to automate the reporting of this data. Ideal Skills: - Advanced understanding of Power BI and its functionality, specifically in regards to report automation. - Experience with data analysis, particularly of customer data. - Expertise in Excel, able to work with complex spreadsheets. Your ability to work 'real time' using screen-share technology is essential. This will help ensure a seamless integration of your work into our existing system. Freelancers who have successfully conducted similar projects in the past will be highly r...

I'm in need of a proficient data entry specialist, particularly knowledgeable in Excel. The data to be entered is not just simplistic entries, it involves working with links between spreadsheets and complex formulas. Here's what I require: - Fascinating skills in Excel data entry - Proficiency in creating links between spreadsheets - Ability to handle complex formulas within Excel - Competence in creating both pivot tables and graphs based on entered data This project requires an individual with advanced knowledge in Excel, and strong precision to detail. The ideal freelancer should have excellent organizational skills and previous experience working with similar projects.

I'm seeking seasoned professionals who excel in website development, mobile app creation, and graphic design to bring my multi-faceted e-commerce concept to life. The scope includes: - Crafting an e-commerce website - Developing a corresponding mobile app - Deploying enticing graphic designs I aim to establish a platform for selling products/services, highlighting the necessity of expertise in similar business-oriented projects. Ideal Skills include: - Proficiency in e-commerce website development - Expertise in mobile app development, iOS and Android - Exceptional creative graphic design capability - Excellent understanding of UI/UX principles Proven experience in similar projects will significantly increase the chances of collaboration. Looking forward to innovative, ...

I'm in need of a skilled freelancer who is an expert in Excel 365 and specifically skilled in VBA automating tasks. The main function of this role includes: - Automating tasks in Excel 365 - Utilizing VBA to generate regular reports - Should work in Windows and Macbook both The ideal candidate for this project has strong experience in using Excel 365, with specific knowledge in automating tasks through VBA. I am especially interested in those who have a proven track record of generating regular reports using VBA. Please include examples of similar work in your proposal.

...company's B2B program as Excel and XML within a certain period of time. The B2B program installed on my computer was installed on my desktop with keys and passwords via remote connection. The information I want from this program; I want a program that can quickly capture the stock code of the product, product description, original number of the product, price of the product, image URL of the product, and stock quantities of the product in which warehouses within a certain period of time. After making this program, it should automatically upload this data to my own website, which I purchased with a ready-made theme, as soon as possible. I need someone who can integrate and do this. The ready-made themed site I purchased uploads data in bulk with an XML address and Excel...

I need assistance in extracting specific elements from 250 Excel spreadsheet addresses - specifically, the city, state, and ZIP codes. The purpose of this extraction is ultimately to import this data into a specialized software. Ideal Skills: - Strong grasp of Excel - Experience in data extraction and manipulation - Familiarity with data importation process for software applications Deliverables: - Clean and well-organized list of city, state, and ZIP code data extracted from 250 addresses - Recommendations on best practices for importing this data into software.

More details: What subject is the classwork for? vba What is the specific task or problem you need help with using VBA? Creating macros for repetitive tasks What type of macro functions should the script perform? Filtering and sorting data

...I am currently a student in a business school and I am preparing for a makeup session regarding Excel VBA. Unfortunately, during my preparation, I encountered difficulties using ChatGPT for the exam, which was not successful. Additionally, I faced a delicate situation when it turned out that I had used a portion of a friend's work to help me, which was noticed by the professor since my friend's name was on the Excel file. I am simply seeking an expert specializing in automating tasks in Excel using VBA. The main focus of this project revolves around automating data entry processes. Here, efficiency and accuracy are paramount. The main responsibilities include: - Automating data entry in Excel using VBA - Enhancing the speed and accuracy of data i...

More details: What subject is the classwork for? vba What is the specific task or problem you need help with using VBA? Creating macros for repetitive tasks What type of macro functions should the script perform? Filtering and sorting data

I am in need of a freelancer who is an expert in Excel to assist me with data analysis. The ideal candidate should have advanced skills in Excel and should be proficient in general data analysis techniques. The specific tasks that I require help with include data analysis, formula creation, and formatting and design. The freelancer should also be experienced in working with a variety of data sets. If you have the required skills and experience, please apply for this project.

I'm looking for an Excel expert to create a spreadsheet for me. Here are the key features I want: - Automatic calculations: I need the spreadsheet to automatically calculate sums and percentages. Prior experience in creating automatic calculations in Excel is important. - Graphs: I would like the spreadsheet to include bar graphs. This will visually display the data in digital format, so freelancers with skills in creating and managing graphs in Excel would be ideal. The final deliverable should be a user-friendly Excel spreadsheet that meets the above requirements. As such, attention to detail, proficiency in Excel, and a knack for visually representing data are all necessary skills for this job. I want to make an Excel that allows me t...

...Scraping text content and images from a test website. - Ensuring the data is accurate and comprehensive. - Organizing scrapped data in an Excel spreadsheet or a csv file. Keen attention to detail is critical. Applicants with prior experience in web scraping, data extraction, and data management, who are comfortable with Excel functions, will be ideal for this project. Please bid on an hourly basis for your time and explain who you will charge by the hour. I'm assuming that you will need to set up the scraping tool, which might take some time, then do the scraping itself from about 2,500 website pages, and then make sure the data is correct in the excel spreadsheet (or csv). Please share what tool you will use and if there is any additional cost to us for usin...

I need someone to convert 20 PDF files into Excel spreadsheet format. Secondly, once converted to Excel format, I need a slightly new design (colour scheme) to the existing design found in the PDF files. If you could create several sample designs of how to represent the data in the PDF files in a different way (style?) in Excel? See attached 1 x sample PDF file to convert

I require a dependable and sharp personal assistant with a Bachelor's degree in engineering, possessing profound knowledge and fluency in English. This role involves a monthly salary of 500 USD and demands a high level of availability and smart handling of various tasks that are crucial to my personal and business needs. The assistant I'm looking for should excel in: - Managing my emails and setting appointments efficiently - Undertaking research-oriented tasks alongside adept data management - Facilitating the tasks with ChatGPT for diverse purposes - Seamlessly handling Airbnb business-related tasks including managing reservations, bookings, and ensuring guest satisfaction - Coordinating with housekeeping services ensuring the property is well-maintained, alongside regu...

1. If certain condition met, Update value in diffect column in same row 2. It is by Minutes, Data are updated every second. Example: I will give Seconds to Minutes Interval(30 sec to any Minutes) value is one cell, If i give value in excell cell, It start copy the live data value in Ex: Live data in Col A If give 1 min interval A col value copied into F col if one minutes end A col value again copied in G col G-F value stoted in H col then G col value assigned F col- Repeat this process in Excel VBA I need an intelligent programmer, who can see future problems and solve them clever and independently. 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 ap...

As a manufacturing business, we are in urgent need of an Excel expert who can efficiently create a comprehensive daily production report. This report will play a crucial role in tracking and informing us on: - The quantities produced each day - The quantities produced processed through different process - Purchase quantities from Outside - Monitoring dispatch - The respective production time for each product - Any machine downtime that occurs Each of these factors are vital elements to monitor in our production process. In addition to a total quantity count, we're also interested in having a breakdown of quantities produced, batch-wise. Ideal candidate should: - Have excellent skills in Excel, particularly in advanced functions and data visualization - Be able to ...

More details: What type of data do you need to enter? Text data What is the source of your text data? Digital files What type of digital files are the data in? Excel spreadsheets

...The email reminder statements are sent at invoice date + 45 days, invoice date + 60 days, invoice date + 90 days and invoice date + 120 days. It may be easier to have 4 separate flows which is fine by me, or all in one if possible. I can create the additional flows I’m sure, so I’m happy if you just concentrate on the 45 day one. 3. The Power Automate flow should iterate through the rows in an example spreadsheet I can provide. 4. Filter the data based on certain criteria. I have a number of other criteria, but I’m certain I can add additional ones that I need once the framework is in place. So, for the flow I’m asking you to create I would need to filter the spreadsheet for: 1. invoice date (so if doing the 45 day flow, all invoices that are at least 45 d...

I am seeking an energy professional expert in smart grid design and demand response technologies. The ke...project is to integrate renewable energy sources into a hydrogen-based smart grid. - A key aspect to the project involves designing efficient and reliable portable power applications using fuel cells. - Proficiency in demand response technologies as a means to enhance the overall energy efficiency of the entire design is a major requirement. This project is an exciting opportunity for individuals with a background in renewable energy, electrical engineering, and sustainable technology. Prior experience in smart grid design and hydrogen technology will be a major plus. Demonstrated knowledge of fuel cells and their applications in the realm of portable power will be ...

Need assistance in closing down my foreign-owned limited liability company established in 2023. The company had no income or bank transactions last year, but I want to ensure all necessary steps are taken correctly. This entails: - Filling out and submitting the EIN Closing Form, Articles of Dissolution, Tax Return Closing Form, and any other relevant forms. - Filing final tax returns. - Cancelling business licences and permits. Ideal freelancer should have experience in business dissolutions, a strong understanding of tax law, and excellent attention to detail. They should be able to guide me through the process seamlessly end-to-end.

I'm on the hunt for someone adept in social media advertising, influencer marketing, and email marketing. Your task will be to effectively promote my digital marketing product to entrepreneurs and regular day people who want to make passive income with digital marketing. My product boasts the key benefit of increased website traffic. To excel at this job, you'll need outstanding skills in digital marketing channels, an understanding of the specific target audience, and a knack for persuasive selling. A successful sale of the $497 course means a 20% commission for you. Let's step up the digital marketing game together.

Adaptar planilha existente para melhor eficiência e design mais bonito para apresentação. a planilha deve atender mulheres executivas que buscam conhecer suas despesas, e alcançar a sua independência financeira para futura aposentadoria ou independência financeira do marido. levando em consideração seus investimentos, inflação e media de rentabilidade de seus investimentos.

I need professional guidance on creating custom modules on ...Specifically, I need a tutorial tailored towards the Data Analytics and CRM sections of the software. The custom module should incorporate the following functionalities: - Data visualization - Customer segmentation - Contact communication history For seamless operation, the module should be able to integrate data from the following sources: - ERPNext platform's database - External APIs - CSV/Excel files The ideal freelancer for this task should have a robust understanding of ERPNext software and have experience in module customization. Data analytics and CRM specialization as well as proficiency in integrating diverse data sources will be a significant asset. The ability to clearly explain and instruct on the proc...

looking for java script expert for the JavaScript Macro Development to sheet automation the task is - - Writing a JavaScript macro to duplicate the last visible sheet within a file and providing it with a new name as a part of an automated procedure. - Once duplicated and renamed, the new sheet should be moved to a specific location inside the file. - Modifying the contents of the copied sheet as necessary. - Implementing a notification function once the procedure is completed successfully. - Adding protection to specific cells within the sheet. more detail on chat

...This is a fantastic opportunity for a professional looking to contribute to an innovative project. Goal of this project is to be able to 1) when a new user signs up on our wordpress website, an about me card will be generated with their profile pic, name, their expertise (e.g. teacher), subject expertise (e.g. Social studies) and link to their profile on the website: 2) once the user completes filling out the initial new user form, they will be prompted to post their newly created profile to linkedin using the linkedin API -the card that we descibed in step 1 is what will post. The user should be able to accept or reject posting their newly created profiled card to linkedin. 3) what linkedin users will see, is a card with the name and profile pic, and short about me "e.g....

ISSUE WITH WEBSITE I recently changed servers and the ‘email consultant’ facility has stopped working. There are lots of consultants all of whom have an individual page on the website with a facility to contact them via their profile page by filling out the contact form. All consultants can be found via the search facility on the menu of each page and then contacted via the unique contact form I created a test consultant to check if things were working after the server change over. Here The contact form has stopped working. Normally it would send the enquirer an auto responder, and send me the message and also a message to the consultant email address. Please identify the fault and correct it to ensure things work

Need assistance in closing down my foreign-owned limited liability company established in 2023. The company had no income or bank transactions last year, but I want to ensure all necessary steps are taken correctly. This entails: - Filling out and submitting the EIN Closing Form, Articles of Dissolution, Tax Return Closing Form, and any other relevant forms. - Filing final tax returns. - Cancelling business licences and permits. Ideal freelancer should have experience in business dissolutions, a strong understanding of tax law, and excellent attention to detail. They should be able to guide me through the process seamlessly end-to-end.

I am in need of a highly skilled and experienced spreadsheet developer to assist me with organizing my self-employment taxes promptly. I require help in compiling business expenses and tax deductions for my tax preparer to submit. My goal is to maximize my tax return. The total income from all of my self-employment endeavors is under $20,000, making this a straightforward business self-employment spreadsheet. Please submit bids appropriate to the simplicity of the task. The most competitive offer from a proficient candidate will be awarded the project.

Hi Gupta I have a PDF which I would like converting to Excel please. The volume is 6 pages, printed 2 pages wide (there are 18 columns) it is 3 pages long. Please confirm availability and time needed to complete. Regards

I'm in need of a proficient Excel expert who can develop a dashboard for courier pricing data. The focus of this project is to allow analysis and comparison amongst different courier companies to determine the most cost-effective options based on weight categories. The desired end product should function as a calculator and feature: - Comparison of pricing between various courier agencies to identify the most economical options - Filter and sorting capabilities based on weight categories Based on these needs, the ideal candidate should have extensive experience with Excel, particularly in creating interactive and functional dashboards, and be able to work within the deadline of March 26th. You should also be knowledgeable in data analysis to capture significant insight...

...cleverly-built spreadsheet that can automatically populate data into specific cells based on the input of four defining variables. I can furnish this information during subsequent discussions. Specifically, the spreadsheet should be functionally proficient in data sorting. It would mean you'd need to creatively implement sorting functions that suit my data management requirements. In your proposal, it would be very helpful to share examples of past work, especially those that demonstrate your expertise in advanced spreadsheet functions. Showcase how you have used spreadsheet functions to handle complex data management tasks. Ideal candidates for this project will possess strong experience with spreadsheet software like Excel or Google Sheets and have a keen eye ...

I'm seeking an experienced Excel developer to bring organization to my data. The main focus of this project will be to create a structure within Excel that will allow for simple and intuitive navigation. Key responsibilities: - Create an organized structure for a large amount of data - Build an easy-to-use system for future data entry Ideal skill set: - Sound understanding of Excel capabilities - Proven experience in organizing and structuring data within Excel - Detail-oriented and highly organized To apply, please provide: - Evidence of past projects similar in nature - A detailed proposal on how you plan to tackle this task. Your main goal will be to create a system in Excel that allows for efficient and organized handling of data. Looking ...

I'm seeking a qualified individual or team to design an artificial intelligence (AI) agent capable of navigating informational websites, filling out forms, sending emails, and performing several additional functionalities. This project will require: - Developing the AI agent using Python - Ensuring the agent primarily focus on browsing informational sites, effectively extracting and processing the needed data. - Configuring the agent to run either through cloud-based operations or manual triggers. Ideal Skills and Experience: - Profound expertise in Python programming - Significant experience in AI development, preferably with a focus on web browsing and data extraction - Familiarity with cloud-based operations and manual triggering systems - Understanding of the structure a...

I'm seeking a proficient Excel expert capable of creating an efficient lookup file for me. The premise is to compare product names and SKU numbers across a medium-sized dataset, ranging from 101 to 1000 rows. Time efficiency is paramount, as the project needs to be completed ASAP. Ideal bidders will have: - Outstanding proficiency in Excel, particularly in creating and managing lookup files. - Exceptional attention to detail to ensure accuracy in comparing product names and SKU numbers. - Ability to deliver a fast turnaround time as this project needs immediate attention. Thank you in advance for your time and bid.

I need an experienced Excel user to input numeric data into an Excel sheet in tabular form. This project is focused on data entry and does not require any formula or calculation implementation. The ideal candidate should have: - Experience with Excel data entry - Diligence in maintaining data accuracy - Ability to work effectively with numeric data - Typing proficiency to ensure target is met in the given time Please ensure high accuracy, as the data entered will be used internally. The project timeline is flexible and can be discussed further during the hiring process.

More details: Which specific data do you want to extract from your Facebook account? Group name, link, public/no public, number of user For which specific groups do you want to extract data from your Facebook account? I am connect...specific groups do you want to extract data from your Facebook account? I am connected to hundreds of groups, I would like to extract their data What specific data do you want to extract from each group? Group name, Group link, number of member,, public or no public group I am connected to hundreds of groups, I would like to extract their data. I would like to save the extracted data in csv or excel. Group name, group link, number of members in the group, whether the group is public or not - that's all the data I'm interested in from the grou...

As someone with an advanced level of experience in Tableau, I'm on the hunt for equally qualified professionals who can assist me greatly in data visualization tasks. The successful candidate should have: - Expertise in working with large data sets within Tableau - Proficient skills in using Excel or CSV files as data sources - Exceptional ability in portraying complex data in a simple and visually appealing manner. Your top-notch skills in developing insightful visuals are what I require for my project. Join me, if you're all about turning raw data into striking visuals.

I need a specialist to develop and implement an operational dashboard on Tableau. I intend to use Excel spreadsheets as the main data source. Key requirements: - Proven experience in creating interactive dashboards in Tableau - Familiarity with Excel and data interpretation - Experience in representing operational metrics visually Ideal Freelancer: - Strong background in data analysis - Proven experience with Tableau - Understanding of operational KPIs would be advantageous The primary focus for the dashboard will be on operational metrics. This is crucial to the overall success of the project. Your expertise in crafting engaging, insightful visual representations of complex data will be key. I look forward to seeing your previous work and discussing how we can work to...

I'm urgently seeking an advanced Excel coder for data analysis. With a budget of just $10, your key role will be to analyze and report on an undisclosed set of data. To be successful in this task, the following skills are desirable: - Expert knowledge of Excel, including creating custom functions - Strong data analysis and reporting abilities - Experience automating repetitive tasks to improve efficiency Please, note that I am aiming for prompt completion of this project, so your ability to produce results ASAP would be beneficial. If your Excel coding skills align with what I'm seeking, please don't hesitate to bid on the project. Improving data accessibility and understanding through your expert analysis is my main goal. Your guidance through this d...

I have a project that requires precise date entry into an Excel sheet. The specifics of the project include: - Typing dates from a digital document into an Excel sheet. - All dates should be inputted strictly using the DD/MM/YYYY format. Ideal Skills/Experience: Candidates with exceptional attention to detail are highly preferable. I am looking for someone who has proficiency in Excel and has a track record of precise typing. Ability to handle digital documents with ease is also a must. Your accuracy and speed will be key for this project. I look forward to receiving your bid if you can meet these requirements!

am seeking a competent data entry specialist with excellent attention to detail and proficiency in Tally. The assignment entails adding around 300 entries from an excel file to tally data (i.e. update company Tally Books). Each entry in excel has comments that specifies the heading & vendor name for the data entry. Once the data is entered the same will be verified by us for correctness. Key Responsibilities: - Organizing extensive financial data within Tally with accuracy and precision - Ensuring the data is properly categorized and easy to understand - Verifying the accuracy of the financial data, correcting any errors, and handling any discrepancies. Ideal Skills and Experience: The ideal candidate should be precise, meticulous, incredibly organized, and possess the...

I am in need of an Excel operator to assist with data entry tasks. Ideal candidates would have extensive experience in Excel and be confident in their data entry abilities. Skills and Requirements: - Proficient in Excel data entry - Attention to detail - Experience with Excel formulas is a plus Application Details: Applicants should include their Excel experience details in their application. Please provide information about past related work, specifically focusing on data entry tasks in Excel. Tasks to be Performed: - Input various data points into Excel spreadsheet accurately - Handle high volumes of data entry - Maintain the integrity and accuracy of the data If this sounds like something you can handle, apply now and let's work...

I'm in need of a freelancer with solid expertise in Excel, specifically in using mathematical functions. This project revolves around efficiently applying these to enhance data organization in my spreadsheet. Skills and Experience: - Extensive knowledge in Excel mathematical functions - Proven ability to handle complex Excel formulas - Prior experience in tasks requiring detailed data organization - Sharp attention to detail and time management Please be ready to showcase samples of your past related work upon your proposal. Your role is crucial in achieving a structured and organized Excel sheet.

I'm in need of a freelancer with solid expertise in Excel, specifically in using mathematical functions. This project revolves around efficiently applying these to enhance data organization in my spreadsheet. Skills and Experience: - Extensive knowledge in Excel mathematical functions - Proven ability to handle complex Excel formulas - Prior experience in tasks requiring detailed data organization - Sharp attention to detail and time management Please be ready to showcase samples of your past related work upon your proposal. Your role is crucial in achieving a structured and organized Excel sheet.

I need an excel sheet designed with advanced functionalities. Unfortunately, I am unable to pinpoint exact features at this time, but as we progress, we'll identify what specifically is needed. Some functionalities might include a data entry form, automated calculations, and conditional formatting. Ideal Skills: - Intermediate level expertise in Excel. - Ability and creativity to suggest functionalities and features for the sheet. - Knowledge of data entry, formulas, functions and conditional formatting. Please include in your application: - A brief summary of your experience with Excel. - Any similar projects you've worked on, if applicable. - Suggestions for possible features for the sheet, based on your experience.

I need someone to convert 20 PDF files into Excel spreadsheet format. Secondly, once converted to Excel format, I need a slightly new design (colour scheme) to the existing design found in the PDF files. If you could create several sample designs of how to represent the data in the PDF files in a different way (style?) in Excel? See attached 1 x sample PDF file to convert

1. If certain condition met, Update value in diffect column in same row 2. It is by Minutes, Data are updated every second. Example: I will give Seconds to Minutes Interval(30 sec to any Minutes) value is one cell, If i give value in excell cell, It start copy the live data value in Ex: Live data in Col A If give 1 min interval A col value copied into F col if one minutes end A col value again copied in G col G-F value stoted in H col then G col value assigned F col- Repeat this process in Excel VBA I need an intelligent programmer, who can see future problems and solve them clever and independently. 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...

I need help with a set of questions that need to be solved on Excel with a focus on spreadsheet modelling and data table. Ideal Experience and Skills: - Advanced knowledge of Excel including formulas, charts and graphs - Experience in creating spreadsheet models - Expertise in data tables Application Requirement: To ensure best fit for this task, freelancers should include examples of past work specifically dealing with Excel spreadsheet problems and modelling.

I'm looking for a data specialist who excels in extractions from e-commerce APIs. The end-goal is to generate an Excel file with extracted text, numerical, and image data. Key tasks will include: 1. Accurate extraction of text, numerical, and image data. 2. Ensuring all extracted data is relevant and usable. 3. Delivering all data in Excel file format. Ideal candidates will have an extensive background in API extractions, especially from e-commerce platforms. Additionally, proficiency in data conversions and formatting, specifically into Excel, will be highly beneficial for the job completion.

I'm in need of an expert in the health field to fill in a review an article and then provide answers for an existing questionaire. As a freelancing professional, your duty is centred on taking the original content and coherently filling up the review template provided. This project requires: - Demonstrated expertise in the health sector. - Outstanding skills in analysis and comprehension. - Ability to work efficiently and quickly, noting specific elements and sections directly from the article to the template. Please note, comprehension and the ability to summarize intricate health concepts in a succinct manner are key to this project. A background in health journalism or education could be beneficial.