Example macro excel automatically fill information workbookJobs

I'm looking for a skilled Tableau developer to design a dynamic daily sales dashboard that automatically updates with new sales data daily. The dashboard should include a comparative analysis of current sales against the sales from the same period in the previous year. Key requirements include: - Developing a visually appealing and user-friendly interface. - Implementing real-time updating features to ensure that the data is always current. - Inclusion of a year-over-year sales comparison to provide insights into sales trends. Ideal skills and experiences for this project include: - Expertise in Tableau, particularly in developing interactive dashboards. - Experience in integrating real-time data into Tableau. - A keen eye for design and the ability to present complex data in...

Any one experienced with octoparse or any other web scrapping tool can easily complete this straight forward web scrapping project. Please see this google drive link for instruction and check attached excel where sample scrapping is done for you.

Hi Elite Information Tech, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I am seeking a skilled professional who can expertly integrate Xero with KOST Quotation Software. The ideal candidate has a deep underst...KOST Quotation Software. The ideal candidate has a deep understanding of both platforms and their capabilities. This role will require the successful candidate to develop: - A system to import customer data from KOST Quotation Software into Xero - A feature to sync invoices between the two platforms - A function to create quotations using the integrated system These functions should sync automatically without manual intervention from me. Previous experience with Xero and KOST Quotation Software, and an understanding of the requirements of automatic data syncing for large scale accounting and financial data, would be highly beneficial for thi...

I'm looking for a skilled Tableau developer to design a dynamic daily sales dashboard that automatically updates with new sales data daily. The dashboard should include a comparative analysis of current sales against the sales from the same period in the previous year. Key requirements include: - Developing a visually appealing and user-friendly interface. - Implementing real-time updating features to ensure that the data is always current. - Inclusion of a year-over-year sales comparison to provide insights into sales trends. Ideal skills and experiences for this project include: - Expertise in Tableau, particularly in developing interactive dashboards. - Experience in integrating real-time data into Tableau. - A keen eye for design and the ability to present complex data in...

Wir sind ein Gastronomiebetrieb und möchten die Kontrollen und Übersichten über diverse Verkäufe, Arbeitszeiten der Mitarbeiter und ähnlichem vereinfacht und am besten mit Automationen in Excel-Listen eintragen. Auswertungen der Verkäufe usw. werden per Mail des Kassensystem-Dienstleisters an uns gesendet. Diese Auswertungen sollen dann in die Excel-Listen eingefügt werden. Mit wenig oder am Besten, durch Automationen, mit keinem Aufwand. Sinn ist es Arbeitszeit zu sparen und Fehler zu vermeiden.

...detailed furniture packages for various property types and customer segments. The goal is to systematically structure these packages in Excel, covering multiple styles and accommodating property sizes from studio apartments to 4-bedroom homes. Each style will cater to different client types: holiday homes, new homeowners, expats, and investors. ### Objectives - **Create Defined Furniture Packages**: Develop comprehensive lists of items included in each package tailored to specific client types and property sizes. - **Organize Data Efficiently**: Present the data in a clear, accessible format in Excel that allows our team to understand and utilize the information effectively for sales and marketing strategies. ### Scope of Work 1. **Data Organization**: - Compi...

I'm in search of a talented and hard-working freelancer to help me with an Excel task. The job at hand is complex and demands someone with strong analytical skills and attention to detail. The primary objective of this project is to achieve a high level of accuracy and efficiency in the output. Thise means that the quality of work is paramount. To succeed in this role, you must have a good understanding of Excel, be able to think logically, and work meticulously. Key Skills & Experience: - Proven track record in Excel data management - Strong analytical and problem-solving abilities - Attention to detail - Ability to work autonomously I look forward to receiving your application, and I will be in touch with the successful candidate soon.

...streamline the process of time-stamp duration reporting in Excel. The solution I'm seeking should ideally have the following components: I have a report (excel-sheet) exported from a system that I use in a weekly basis, however in this report, the date and time of processing exported in a form of “timestamp” and in order to calculate elapsed time of each stage in cycle, every time I have to do the followings: - Fix the format issue in excel since system always export data in a form of “timestamp” and there is no to fix that. - Exclude non-working hours for each stage/ elapsed time. - Exclude Weekends (Friday & Saturday). - Sum up the total of elapsed times Do you have a solution that I can use the as tool either by creating exc...

...and knowledge of using the Namecheap API to create a script or program that can perform the following tasks automatically: Domain purchase: The script should be able to purchase a new domain on Namecheap every week. A list of available domains to choose from will be provided, and the script should select one that meets certain predefined criteria. Domain change: Once the new domain has been purchased, the script should automatically change the domain of an existing website to this new domain. The domain change should be seamless and should not cause any disruptions in the availability of the website. It is important to note the following: The script should be able to run automatically every week without manual intervention. Logic should be implemented to ensure th...

...changes or extending hours on the job. Fatigue scores will be automatically recalculated and flag any breaches that the shift change may incur. 3. Breaches will automatically flag a risk assessment where it can be completed instantly on the phone. And send nonfiction to the admin via email. 4. Worker app will only show the individual's roster. It allows shifts to be edited if needed which recalculates fatigue scores and allows a risk assessment to be completed. 5. Immediate visibility to last minute changes and any breaches that may occur meaning a fully compliant solution. 6. Apps work Offline so it doesn’t matter if there is no internet connection in remote areas. Once the connection stablished the data will Sync automatically. ==================...

I'm looking for a freelancer who can provide me with the links to Facebook pages of specific public figures/politicians, total of 1215 (IMPORTANT! I need only pages, NOT private profiles). The links should be delivered in google sheets which I will provide, along with the names. Key Requirements: - Co...Facebook pages of specific public figures/politicians, total of 1215 (IMPORTANT! I need only pages, NOT private profiles). The links should be delivered in google sheets which I will provide, along with the names. Key Requirements: - Compile a list of specified Facebook pages - Deliver the links in google seets Ideal Skills and Experience: - Proficiency in Internet Research - Experience with Excel or Google Sheets - Strong attention to detail - Ability to follow instruct...

...requirements: - **Design/Layout:** The site's current aesthetic is outdated and unappealing. I'm seeking a modern, professional design that resonates with our B2B target audience. - **Content Organization:** The information on the site is currently haphazardly arranged, making it hard for visitors to find what they need. A more intuitive content structure is required. - **User Navigation:** The current site's navigation is messy, confusing, and not user-friendly. The new design must prioritize simplicity and ease of use. The primary objective of the redesigned site is to encourage visitors to fill out a contact form. It's crucial that the new design is optimized to drive this action effectively. Ideal skills for this job include: - Proficiency in Wor...

We are looking for a creative web designer to craft an engaging and visually appealing perfume information page for our review website. The page design should effectively showcase perfume characteristics, user reviews, and related perfumes. Key skills required: - Proficient in creating minimalistic website designs - Skills to ensure the information is presented in a clear and engaging manner The ideal candidate should have experience in creating similar websites or at least a strong portfolio that demonstrates their capability in minimalistic design and information presentation. It would be a plus if you can suggest light-toned color schemes to complement the minimalistic design. Deliverables: Design of one single static webpage, for one single perfume to be used as...

DESEO HACER UN CAMBIO DE TARIFAS DE UN DOCUMENTO EN WORD DONDE ACTUALIZAR EN BASE AL TEXTO INICIAL SOLAMENTE MODIFICAR LOS IMPORTES QUE SE INDICAN CON LOS CONCEPTOS E IGUALMENTE A EXCEL POR APARTADOS

I'm in need of a proficient Excel and Word expert who can assist me with various tasks. Unfortunately, I did not specify the exact tasks nor provide a deadline for this project. However, I'm excited to review your proposal and discuss your experience in more detail. Please include your past work in Excel and Word with your proposal. This could be anything from template creation to complex data analysis and automation. The more detail you can provide about your past work, the better. In terms of my needs, I'll be looking for a flexible freelancer who can help out with a range of tasks. Experience in data analysis, formula creation, and automation in Excel would be particularly desirable, as would proficiency in creating and formatting templates in Wor...

I am in need of an experienced and knowledgeable professional to assist in the development of a comprehensive training program for individuals aspiring to become advanced pentesters. Key responsibilities: - Create a structured, in-depth training curriculum focused on web applications, networks, and mobile applications pentesting. - Design ...particularly in the areas of web applications, networks, and mobile applications. - Prior experience in designing and delivering training programs, workshops, or courses. - Strong communication skills and the ability to explain complex technical concepts in a clear and concise manner. The goal of this project is to equip participants with the necessary skills, knowledge, and practical experience to excel as advanced pentesters in a professiona...

...revealing the real website address. The redirect must withstand scrutiny, ensuring that the actual target URL is never exposed. Key requirements include: - Setting up a permanent redirect: The redirect should be set up in a way that search engines and users are directed to the new URL without any indication of the original one. - Maintaining sync with the original website: The redirection should automatically update to reflect any changes on the original website. This is crucial as it ensures that the redirect remains accurate and up-to-date. - Ensuring the redirection is seamless and fast: The process must be smooth and without delays, ensuring a seamless user experience. Ideal skills and experience for this job include: - Proficiency in web development and server-side scripti...

Following are the requiremen...Task is to visit the Post secondary school 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 of Christiana Slatina Post Secondary School . Also stamp on the educational 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 Christiana Slatina Post Secondary Schoo does 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 an...

...follows: Upon clicking the appropriate button in CRM, a survey should be created, which we can then provide to the trainees to fill out after the training. The survey should include individual training attributes transferred from CRM entities - such as the training name, training date, and trainer's name. Other fields like training rating will be constant for each survey. The survey link should be generated and displayed in CRM, and there should also be an option to send it to the email address of the trainer conducting the training. A QR code should be generated for the survey link. Survey results should be saved to a separate table in CRM, which will contain information about the training, the trainer, and responses to each question. Based on these results, we will...

...menu data, which exceeds 500 entries, in Excel. My project primarily involves handling text data. Here's what you would focus on: - Categorizing different types of food items. - Ensuring accuracy and consistency in data entry. While not a firm requirement, familiarity with culinary vocabulary could be beneficial. Additionally, someone proficient in MS Excel and particularly experienced in data categorization would be ideal. I appreciate your consideration and look forward to potentially working with you. Paid project: remote work  Seeking Assistance: Categorizing Online Menu Data in Excel Hey guys, I hope you're doing well! I'm reaching out because I could use your expertise for a project I'm working on involving categorizing online me...

I have a highly encrypted XLSM file that I urgently need help with. This specific project involves making VBA in the file visible. I need someone with advanced VBA skills and experience in cracking down highly encrypted XLSM files. Key requirements: - Expertise in VBA for Excel - Experience with highly encrypted XLSM files - Ability to make VBA visible in such files Please only apply if you have previous experience in this area and can start immediately. BID NOW!!! Serious freelancers only with the skills since it is ASAP!!

...as a platform for data visualization and export. Key Functionalities for Admin User: - **User Management:** The admin should have the capability to manage user accounts, including setting access permissions. - **Graph Creation:** The admin needs to be able to create visual representations of data. - **Data Viewing and Exporting:** The admin should be able to view all the data and export it to Excel for further analysis. Graphs Per Department: - **Data Points:** The graphs should focus on data from Sales, Expenses, Profit, and Number of Employees, using a rolling average approach for accuracy. - **Rolling Average Calculation:** The rolling average for the graphs should be calculated based on Manual Entered Data, per department. Additional Requirement: - **Formula Calculation...

I urgently require a skilled photo editor to make slight adjustments to 4 photos from a recent construction project. Some ceiling tiles in the photos are misplaced or missing, and I need this addressed. Photo 9516 - there is some ceiling tiles missing top right Photo 9521 - there are some whiter ceiling tiles in the gird ...Some ceiling tiles in the photos are misplaced or missing, and I need this addressed. Photo 9516 - there is some ceiling tiles missing top right Photo 9521 - there are some whiter ceiling tiles in the gird that are wrong (4-5 nr), change colour of these. (Not the central long panels in the corridor ceiling which are ceiling radiators). Photo 9528 - there's a couple of ceiling tiles missing, please fill in. Photo 9529 - there's a couple of ceiling tile...

...ReactJS and Ruby on Rails - Experience with integrating third-party APIs - Understanding of UX/UI principles for web and mobile interfaces The main requirement This is an online booking platform, and I am integrating Google calendar to manage bookings. As most vendors use Google Calendar to manage their bookings, this system will ensure: new booking made through our platform will be automatically synchronized and registered on the vendor's Google Calendar. 2. Bookings made directly on the vendor's Google Calendar, bypassing our platform, will be promptly detected and updated within our system. Optional, but I will need a Calendar UI to display the bookings made: 1. Users can toggle between different views to see the studio's schedules for a specific day, week, o...

I'm in need of a professional who can de...develop a custom dashboard software with two distinct views. The first view will be for our customers, allowing them to input specific data which will be reflected to us as administrators. Key Features: - Two distinct views for customer and admin - Customer view: Customers can : - Fill in order details - Submit data to admin - Admin view: - Receive and review customer inputs - search easily to find the data. - Filtering - Dashboard Information section: - Specific information not disclosed - Product name - Quantity Ideal Skillset: - Proficient in web development - Experience in dashboard design and customization - Strong in data handling and submission - Excellent communication for ad...

I'm in need of a freelancer proficient in SAP ERP, particularly in Finance and Controlling, and Sales and Distribution. Your primary task will be to fill data sheets for me. I'm looking for a one-time service, so the ideal candidate should be able to perform this task effectively within a single session. Key requirements for this project include: - Deep understanding of SAP ERP, specifically in Finance and Controlling, and Sales and Distribution. - Ability to analyze case studies in order to fill the data sheets. - Proficient in providing accurate and detailed information.

...of both text and numeric data from PDF files. The extracted data will then need to be arranged in a specific format in an Excel sheet. Key Responsibilities: - Extract both text and numeric data from PDF files - Perform the data extraction on a weekly basis - Arrange the extracted data in specific columns and rows in Excel Ideal Candidate: - Proficient in using PowerAutomate for data extraction - Experience working with PDF files and Excel - Attention to detail for correct formatting of data - Ability to meet weekly deadlines - Strong communication skills to verify data accuracy Please find attached pdf (extract) example (there is 5 different templates to use) & excel (input). Looking forward to working with you! We have many more use cases lik...

I'm in need of a highly skilled AWS OCR specialist to help extract data from a large number of PDF invoices. We intend to export the extracted data into an Excel (XLSX) file. All invoices follow a consistent format, as shown in the attached sample. All invoices have been scanned at 300dpi resolution with searchable OCR enabled." Key Requirements: - Proficiency with OCR technologies, particularly those integrated with AWS services (Textract) - Experience with extracting data from PDFs, especially invoices. - Ability to export extracted data into Excel format. The freelancer will supervise the implementation process on our PC. Due to confidentiality, access to the invoices will be provided remotely on my PC

Vær venlig at Tilmelde dig eller Log ind for at se detaljer.

I need a seasoned Excel Macro developer to help me create a macro to automate repetitive tasks and generate daily reports. Key Requirements: - The macro needs to be compatible with Excel 2016, as this is the primary version I'm working with. - I'll need to run the macro daily, so it has to be stable and reliable for consistent use.

I'm seeking an experienced MS Excel specialist for a freelance data analysis job. Key Responsibilities: - Execute thorough data analysis using Excel. - Generate actionable insights from the data. - Prepare and present reports based on findings. Ideal Candidate: - Proficiency in MS Excel. - Proven experience in data analysis. - Strong analytical and problem-solving skills. - Excellent attention to detail.

Hi Elite Information Tech, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hi Elite Information Tech, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I need a meticulous and detail-oriented freelancer to assist with numerical data entry for the purpose of data analysis. Key Requirements: - The data you'll be working with is in a digital format, mainly in Excel and CSV files. - You will be responsible for accurately entering this numerical data. Ideal Skills and Experience: - Proficiency in Excel and data entry. - Experience with numerical data analysis. - Attention to detail and accuracy. - Ability to work with large sets of numbers efficiently.

Hi Elite Information Tech, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm seeking a professional who can help me apply for jobs in the technology and finance industries. Key Requirements: - Fill online job applications only - Use a standard application template for all submissions Ideal Skills: - Strong understanding of the technology and finance industries - Exceptional written communication skills - Previous experience in a related role would be a plus Please provide an overview of your relevant experience while bidding.

We are reaching out to inquire about designing a logo for our new online store, "EMAA USA." Our store focuses primarily on offering a range of products for kids and moms. We are looking for a logo that is visually appealing to ch...and moms. We are looking for a logo that is visually appealing to children while maintaining a modern and minimalist design. When designing the logo, we kindly request that you avoid using excessive colors and instead opt for a more restrained color palette. Additionally, we would like to emphasize that we do not accept logos generated using AI. Entries utilizing AI-generated designs will be automatically rejected. We appreciate your attention to these details and look forward to seeing your creative concepts for our logo. *** We want AI file...

...and intangible assets, as well as financial assets. - The Ultimate Goal: The primary objective of this project is to implement robust asset management practices via a comprehensive depreciation forecast. I'm seeking a professional with: Creating a excel spreadsheet that i can download my asset register into and then have the worksheet calculate future annual depreciation say to 10 years. But also allow the ability to have the individual assets to be revalued either an increase or decrease in the original asset cost. This would mean the excel sheet would need to be able to take into account prior accumulative depreciation and adjust in the year we are currently reporting in. The attached file is current assets as at 30th June 2023. No depreciation has ran for FY24 ...

I'm in need of a freelance job, specifically requiring assistance with Excel. This project is tailored for someone with experience in the following areas: - **Excel Expertise**: I'm looking for someone who is proficient with Excel, especially in handling data analysis tasks. The ideal candidate should be comfortable with manipulating large data sets and extracting key insights from them. - **Data Analysis Skills**: A strong background in data analysis is crucial. You should be able to interpret data, identify trends, and provide meaningful conclusions based on your analysis. - **Attention to Detail**: As this job involves working with data, high attention to detail is a must. The ability to spot errors or irregularities in data sets is crucial to the succe...

I'm in need of a skilled accounting professional who can seamlessly handle a variety of accounting...bookkeeping, financial analysis, and tax preparation. Key Responsibilities: - Timely and accurate bookkeeping: Keeping track of all financial transactions. - Perform financial analysis: Analyzing financial data and creating financial models to support decision-making. - Tax preparation: Preparing and filing tax forms in a timely and accurate manner. Ideal Skills and Experience: - Proficient in Excel, Tally Prime, and Zoho Books. - Strong understanding of bookkeeping, financial analysis, and tax preparation. - Prior experience with daily accounting tasks. - Excellent attention to detail and organizational skills. - Strong communication skills and ability to work efficiently an...

...seamlessly, connecting with our shipping partner, Sequell. Key Features: - Automatic order creation in Sequell: The plugin should automatically create an order in Sequell when a new order is placed and marked as ready to ship on our WooCommerce store. - Automatic generation of tracking number: A tracking number should be automatically generated for each order. - Automatic sharing of tracking number with customers: The plugin should share the tracking number with customers in a simple and automated manner. Order Details for Sequell: The order details sent to Sequell should include: - Customer name and address - Product name and quantity - Payment information (if applicable) Sharing the Tracking Number: The tracking number should be shared with customers via: -...

...an existing Excel calculator into a web-embeddable format for integration on our website. The calculator should perform basic arithmetic operations and allow user input for the calculations. At the moment the user has to imput the item being stored and the size of the shed and it will tell them how much it can store of that item. We want this reversed and the user will put in the item they want to store and how much they want to store and it will calculate the size the shed will need to be. Key Requirements: - Convert an existing Excel calculator to a web-embeddable format - Ensure it performs basic arithmetic operations - Allow users to input values for the calculations - Optimally integrate the tool within our website Ideal Skills and Experience: - Proven experience ...

...Serenity, your dedicated partner empowering startups and small businesses nationwide. We level the digital marketing playing field, ensuring every business has an equal opportunity for success. Our small team combines creativity, strategic marketing, and data-driven insights to create unstoppable marketing campaigns aligned with your vision. At Oak Serenity, your success is our priority, driving us to excel alongside you. We operate with these 7 core values: Integrity, Teamwork, Empowerment, Excellence, Stability, Growth, and Innovation. Do you crave the freedom to design your work schedule and control your earnings? Are you a goal-oriented, self-motivated salesperson passionate about helping businesses succeed? Then join Oak Serenity! We're seeking a highly motivated Perfor...

I'm looking for a professional web developer to build a new website for my company. The website will be primarily informational, designed to showcase our services and attract potential clients from the bu...potential clients from the business community. Key Requirements: - Development of a fast, responsive, and visually appealing website - Incorporation of SEO best practices to ensure high visibility on search engines - Ensuring the website provides an exceptional user experience for business professionals The ideal candidate should have: - Proven experience in developing high-quality, SEO-optimized information websites - A good understanding of design principles and user experience - Strong communication skills and the ability to understand and cater to the needs of business...

I need a talented artist and copywriter to create two persuasive sales pages. These pages will showcase two of my products, aiming to convince both potential customers and licensees of their value. Specific responsibilities will be: - Creating a photo-realistic 3D rendering of each ...copy that effectively communicates the value of the products, but more importantly - it sells the benefits (not the features). Ideal candidates should possess: - Excellent 3D rendering skills - Experience in persuasive sales copywriting - Understanding of how to appeal to both customers and licensee parties - Previous success in converting sales pages. This is a wonderful opportunity if you excel in merging artistry with persuasive sales copy. Let's increase the perceived value of these pro...

52 sheet for 52 week needs to contain mon-Friday. I will register everydays expense on that.

I'm looking for a freelancer who can set up an integration between Home Depot Pro Referral leads and Workiz CRM. Here's what I need: - The leads should be automatically entered into Workiz CRM. This will save time and ensure we don't miss any potential opportunities. - For each lead, I need to capture both contact details and project details. This will help us tailor our follow-up and communication strategies to each lead. - Standard fields in Workiz CRM are sufficient for this project. I don't need any custom fields or special information included in the lead's profile. The ideal freelancer for this project will have experience with both Home Depot Pro Referral and Workiz CRM. It's crucial that the integration is seamless and accurate to ensur...

I'm seeking an expert web developer who can build an informational website aimed at the general public. Your duties will not stop at designing ...also be required to: - Modern and industry-appropriate web design - ("Manageable" "original" design with WordPress CMS infrastructure) - 15-20 service page landing page design - Compatibility regulations with mobile devices - On-site search engine optimization - Search Console registration - Google Analytics record - Social media links - Conversion-focused communication links - Modern and easy to fill out contact forms - Live support application customer communication module - Standard privacy and security practices - Production and updating of SEO compatible content - 1 year maintenance, security, updates, backup...

...freedom to choose a fitting color scheme as I don't have a specific one in mind (confirm with me before using). - Although I didn't specify a design style, it would be beneficial if you have experience in designing minimalist, vintage or modern styles. Having said that, I'm open to other design styles as well, but overall the design of the web and mobile app should be amazing and latest. - The fill features in the app like, user registration/login, live chat, recommendation matches feed etc (that usually a matrimony app has). - The app should have both light mode as well as dark mode. - Node human images should be used in web or mobile app, it should be clean and simple (can discuss more on this). What we need for a web app: - Super and Sub-admin dashboard - User...