Excel macro list worksheet names sheet jobs
I need help populating an Excel sheet with 378 company websites. - The task involves searching the internet for the website of each company and entering it into the Excel sheet. - If a company doesn't have a website, please mark it as 'No Website'. - All URLs should be inserted in a new column in the existing Excel file. I would prefer the URLs to be in the format '' or ''. Ideal Skills: - Proficiency in Excel and web research. - Attention to detail to accurately populate the data. - Strong communication to flag issues or ask questions during the process.
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.
I'm looking to build a dedicated community website specifica...should be modern, articulate and decision makers or contribute to the decision of what jewelry to buy Buys branded fashion accessories (apparel, jewelry, footwear, accessories) at least once a month Digitally active on Instagram Strong share of online buying (at least 3 of last 5 purchases) Travels on vacation at least once a year nationally or internationally We need phone numbers, emails and names of these consumers so that they can join our internal community for the client. A deliverable will be someone who signs up to be a part of the community for a year. If you have experience in designing, developing, and managing online communities, especially ones that focus on gathering feedback and insights, I'd li...
...analyst to organize and create 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 Org...
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...
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: - 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 instructions accurately
I require a knowledgeable individual to seamlessly upload all products to my new Shopify store from a CSV file, which contains product names, images, and descriptions. The expert will also set up an organized system for product collections, categorised by product types. Key Requirements: - Proficient in utilizing FTP files for shopify product upload - Skilled in Shopify product collection organization - Effective mastery of CSV file usage with specified fields including product names, images, and descriptions. Looking forward to reliable bids. Please, only bid if you are fully capable and have handled similar tasks. Thank you.
...to add a protection mechanism that ensures the spreadsheet can be edited by all users but avoids accidental changes to existing data. 2. Automated Data Analysis: I'm looking to automate the process of data analysis in the spreadsheet. Your solution should be efficient and user-friendly. 3. Make analysis available in existing web page 3. Export to other existing database It is important that the sheet can be accessed and run from Google Workspace with mainstream browsers without requiring usr to download extensions, run scripts, etc Happy to work on time based payments and will contract item 1 first and then move onto others sequentially subject to successful and timely completion of previous. Ideal candidates for this job should: - Have a strong understanding of Google ...
Need this complete so i can...the points For authors. Review score 1-2 = 0 points 2-3 = 5 points 3-4 = 10 points and 4-5 = 20 points I also want to award points for the user wall or page feed posts If the user posts to any wall/feed on any page they receive 10 points. If the post has an image, they receive an extra 50 points. If the text is longer than 30 words they receive an extra 30 points I also want different badge names to receive different multiples of points. Example Badge 1 would be the standard Badge 2 would get 1.5 times the points Badge 3 would get 2 times the points The voxel is pretty good with custom work I can give you access to a test site to have a look. But I have added a custom hook that has already been done plus an image of the custom hander area for the...
I'm seeking a skilled individual to accurately convert a PDF document into a Word document. The prime purpose of this conversion is for extracting text. - The project demands the highest level of precision, with a requirement for 100% accuracy in the extracted text. Any mistakes in conversion could result in significant inaccuracies, hence meticulous attention to detail is vital. - It's imperative that the Word document maintains the original format of the PDF for consistency and ease of navigation. The freelancer must be well-versed with advanced Word formatting to accurately replicate the original PDF layout. Ideal skills: - Proven experience in data entry and document conversion - High level of accuracy and attention to detail - Strong understanding of Microsoft Word's...
I'm looking for a skilled professional who can help me make minor text updates to a series of PDF documents. - I need simple changes such as updating dates, names, etc. - The job involves editing 1-5 documents in total. Ideal candidates for this job would have experience in PDF editing and be detail-oriented and reliable.
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...
...decision-making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) National Highway Khon Buri, Khon Buri District, Nakh...
...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!!
...decision-making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Dakar, Senegal. • Has a camera or phone/tablet ...
I'm looking for an experienced researcher to create a list of affiliates, organized by industry and location. The industries in focus are make money online businesses, digital marketing, and artificial intelligence. The locations should span across the United States, Europe, and Asia. The ideal candidate should have a great eye for detail, excellent research skills, and prior experience in affiliate marketing.
...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'm looking for a proficient web developer with experience in Joomla and Hikashop to customize the invoice sheet layout . The sheet should be working for both languages of website in the specific language and should be easily printable by siteadmin to be attached to the package( .csv / or xml?) Your tasks will include: - Modifying the layout of the invoice sheet, specifically the header arrangement, footer items, and body contents. - Customizing the header of the invoice sheet as per provided example. The ideal candidate will not only have a solid understanding of Joomla and Hikashop, but will also be adept at translating my vision into a user-friendly interface. If you possess these skills and think you can help, then I'd love to hear from you. ...
...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
I'm looking for a proficient Abaqus modeler to develop a model of a slender column based on specific design specifications provided in the job sheet. The task will involve: - Modeling a slender column using Abaqus - Incorporating specific material properties and geometry specifications - Applying boundary conditions for combined loads of axial load and bending moment Ideal skills for this job would include extensive experience in modeling structures with Abaqus, understanding of boundary conditions, and experience in analyzing structures under combined loads. Familiarity with structural dynamics will be a major plus.
I have a Windows 10 PC linked to a NAS Unit on public used for storing files. I need a PowerShell script which will transfer files and folders, including subfolders from the NAS unit to my FileZilla server using FTP. The PowerShell script has a further requirement. It should create a log file with the names of all files it has transferred and reads it each time the script runs so that it does not recopy them. The script should run at 23:00 every evening. Ideal Freelancer: Versed in Windows 10 PC, NAS and FileZilla server operations. Excellent skills in PowerShell scripting, specifically for FTP file transfer.
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.
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.
I'm having a significant issue with my Google Sheet that needs sorting quickly. The main issue I'm dealing with is a formula error - when I try to make a hyperlink auto-populate after inputting a specific exercise, it just isn't working, which is causing a lot of frustration. Key Requirements: - Understands Google Sheets - Skilled in fixing formula errors - Fast turnaround time Ideal Skills and Experience: - Strong expertise in Google Sheets and formulas - Proven troubleshooting evaluation - Ability to deliver ASAP.
...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...
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...
...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 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.
For my small business, I need an expert to create my income statement, balance sheet and cash flow statement using Wave for 2022, 2023 and 2024. Your proficiency in this software is highly desired. The delivery method required is in PDF format. Any demonstrable experience or understanding of small business accounting will be advantageous. Please also have excellent attention to detail, strong computational abilities, and a thorough knowledge of current financial legislation. Your data presentation skills should be effortlessly understandable to someone without an accounting background.
I'm on the lookout for a talented graphic artist who can create digital images of two specific towns in the style of retro “Greetings from…” postcards. Each image should feature notable locations within the letters of the town's name. - Towns: The towns have been predetermined. I will provide the names as soon as we start the project. - Artistic Style: Emulation of a vintage aesthetic is key. The art should evoke nostalgia reminiscent of old-school Americana postcards. The ideal freelancer for this project is proficient in graphic design, particularly digital art. Experience in vintage-style artwork or illustrating townscapes would certainly be a bonus. Attention to detail and the ability to incorporate the iconic landmarks of the towns into the lette...
Make a GoogleApps Script. In google sheets on {sheet-1} when cell {T1} is {> 0}, then send an email to XXX@addy_com.- - Check every {15} minutes.- - All content in {brackets} is easily adjustable.- - Email subject {Idle Time}; body {Check server} More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? p Project proposal and similar work completed How soon do you need your project completed? In a few days
...reports. 2. These reports must provide a list of all tasks and their current status 3. in particular how to create a table of all tasks related to a Milestone - similar to Task path function for predecessors. The ideal freelancer for this project should possess strong skills in VBA and Microsoft Project. They should have a proven track record in automating and streamlining reporting processes. Previous experience in project management reporting is ESSENTIAL. I'm looking for someone who understands project progress reporting and can deliver efficient, accurate results. If it turns out that it is not possible to achieve the type of reporting in MS Project then i will consider outputting the data to Excel, and creating suitable dashboards in Excel. (I might al...
...1. Dataset and Topic Selection: Choose any publicly available dataset that interests you, whether related to environmental issues, public health, economics, sports, finance, real estate, or any other field. The key is to select a topic that allows for insightful data analysis and storytelling. 2. Tool Selection: You can use any data visualization tool you are comfortable with, such as Microsoft Excel, Power BI, Tableau, or others. 3. Dashboard Creation: Design a dashboard to be informative and visually engaging, using a variety of charts, graphs, and visual elements to convey critical insights effectively. The dashboard should be structured to communicate the story or analysis, making it easy for viewers to understand and derive conclusions. 4. Video Presentation: Record a 7-10 m...
I have a custom-made plugin, I want to duplicate it into 4 plugins with different names like plugin 1 plugin 2 etc... and all should work fine with each other without conflicts budget: $10 1+1?
Dear Candidate, As described in the title, this task requires that you reasearch medical centres (also called general practice medical centres, family physician clinics, clinics) and find out who the owners of these clinics are are using internet research. You will have to be fluid with excel, online reasearch tools. This is a posting for a long-term VA who can perform various forms of online research and other tasks. Personal attributes required: 1. Speed and efficiency in online research. 2. Attention to detail and complete accuracy in all tasks. 3. Punctuality and ability to meet deadlines. 4. Ability to read/follow instructions carefully with attention to detail. Successful candidates will be required to complete two test works before the project is awarded. 1. Watching i...
...particularly interested in monitoring three key data sets: - Patient volume - Revenue - (PPC) This data need to be updated and reported on a monthly basis, presented in an accessible and understandable way for our administrative team. The reporting format we require is spreadsheet, so proficiency with Excel or a similar program is a necessity. Ideal candidates for this job would have: - Strong data analysis skills - Previous experience with financial and PPC data - Proficiency in Excel or similar spreadsheet software - Ability to deliver monthly updates in a timely manner Through this analysis, our goal is to gain a clearer understanding of how patient volume, revenue, and PPC are impacting our clinic and individual doctors' performances and devise data-driven s...
we have 645 pages in the attached Excel spreadsheet that we need to write 150-200 words about the product as content for each page.
I am in need of an Excel expert who can assist me predominantly with data analysis tasks. More specifically, the ideal individual should be adept at: - Utilizing Excel effectively with the @Risk add-on, - Performing a Monte Carlo simulation to analyze risk, - Wielding strong analytic capabilities to interpret and communicate the simulation's results. The task will require a deep understanding of data analysis techniques, a keen eye for detail, and fluency in data visualization. This role is perfect for seasoned Excel professionals with past experience in risk analysis and simulation.
I am looking for an expert in data analysis and excel who can compile specific data for certain doctors in our clinic. The data metrics required include: - Volume - Revenue - (PPC) The data should be organized both doctor-wise and clinic-wise for effective comparison and understanding. You should be able to present the data in an easy-to-understand, concise and visually appealing manner. Key skills required for the project include proficiency in: - Data analysis - Excel data manipulation - Understanding of PPC metrics - Attention to detail Experience in health-related data analysis would be a plus. Sub-headings should be WOW (week over week), MOM (month over month), MTD (month to date), and YTD (year to date), reflecting the volume, revenue, and PPC for each particular ...
I am looking for an expert in data analysis and excel who can compile specific data for certain doctors in our clinic. The data metrics required include: - Volume - Revenue - (PPC) The data should be organized both doctor-wise and clinic-wise for effective comparison and understanding. You should be able to present the data in an easy-to-understand, concise and visually appealing manner. Key skills required for the project include proficiency in: - Data analysis - Excel data manipulation - Understanding of PPC metrics - Attention to detail Experience in health-related data analysis would be a plus. Sub-headings should be WOW (week over week), MOM (month over month), MTD (month to date), and YTD (year to date), reflecting the volume, revenue, and PPC for each particular ...
I'm in need of an Excel VBA expert who can assist me with writing macros and automating data entry in my spreadsheets. The primary goal of these macros is to automate the data entry process and streamline the subsequent data analysis tasks. Key project requirements: - Building custom macros: I need help with building macros that can automate data entry tasks and facilitate data analysis. - Data analysis focus: The macros should be designed to support data analysis, particularly with a focus on data visualization. - Expertise in Excel VBA: Proficient in Excel VBA is a must, with a proven track record of designing and implementing complex, data-focused macros. - Understanding of data analysis: A strong understanding of data analysis is crucial to ensure the macros ...
