Excel vba reference sheet name variable jobs

I'm looking for a freelancer proficient in Excel for a simple data entry task. The work involves straightforward copytyping of numeric information into an excel sheet. Key requirements include: - Accurate data entry skills - Proficiency in Excel - Attention to detail The project doesn't involve any complex formulas or advanced functions. It's a relatively straightforward task that requires precision and focus. Your role will be to ensure all data is accurately entered into the spreadsheet in a timely and efficient manner. A keen eye for detail and a methodical approach will be crucial for successfully completing this project. Please note that the data entry will be in the form of standard tables, so experience with this type of formattin...

Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account

I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.

I need an Excel expert to enter a set of numbers and dates into an Excel sheet, and perform some basic calculations. - Data Typing: You'll need to be comfortable working with both numbers and dates, as these will be the primary data types that need to be entered into the sheet. - Calculations: There are two specific calculations that need to be performed on the numbers: - Summation: You will need to calculate the total of all the numbers. - Average Calculation: You will also need to find the average of all the numbers. - Date Formatting: The dates I will provide need to be formatted in both date and time format. This means you should be adept at formatting cells in Excel to ensure the correct display of dates and times. Ideal Candidate: - P...

I'm looking for someone who is smart and can record some action songs for preschool kids. No previous experience is required. You can just use your phone camera to record the videos. You only have to act/dance based on the songs we provide. You will get the payments for each video song you record. I will provide you with all the reference songs for each video. These are just 3-5 minute long videos and it depends on the rhymes song. Please take a look at the example video (This is just a demo video and the rhymes will be mostly in English.) -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- PLEASE NOTE: You must be in SAREE for

1. Migrate equaleartth from gate to hostinger Philippines. Hosted in my name. 2. Transfer my domain vanxilefpaintings from gate to my plan with in the Philippines 3. Upload text and about 500 pictures to my website

I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.

I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...

I have an html form php file on my server. I would like a passcode (no username) added to the form that captures the u...captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to insert the data from 5 fields. Can you help with this? We have an form in the laravel, these are three main tasks : 1) Secure the form with 6 code passcode. 2) Update the URL of the form. 3) Save the form data in google sheet. There are various tabs in the sheet, so we need to save the data in goo...

I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and changes over time...

I'm seeking a talented designer to work with us on a GIG or part time basis. We need you to revamp company's email branding Key Requirements: - Modern, clean design style - Incorporation of company logo, social media links, and contact information - Overall design and layout should be reflective of our brand - Se...your previous email branding work and explain how you would approach this task. You will have skills in using either figma, photoshop, canva or beefree PART 1 We have a 1 hour paid mock test for the right person If the design is really good We will invite you to PART 2 Then you will design it in the email system (make sure it works, layout is mobile optimised and dark mode etc) Future reference Generally, we award a gig that has a task of 10+ templa...

I'm looking for a Laravel expert to integrate Google Sheets into my system. Specifically, I want to connect it with a form on my site for seamless data handling. I have an html form php file on my server (built in laravel). I would like a passcode (no username) added to th...my site for seamless data handling. I have an html form php file on my server (built in laravel). I would like a passcode (no username) added to the form that captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and r...

Defined the Scopes of Works, duty, or task (let said the "tasks") show as below: "Basic Scope" (I need you to do) 1. Initial Financial Statement Drafting (Basic Income Statement, Balance Sheet, change of Equity, and cash flow) as of 2024 March 31st (Year End 31-03-2024) 2. Maintain the company account and record transaction recorded (e.g: Journal Enters) 3. Recording and reconciliation of banking, AP, and AR transactions 4. prepare the accounting schedule (The “schedules”); A. Account Receivable, B. Account Payable, C. Payroll (Included MPF) D. Loan, E. Accrued expense. F. Amount due from/to G. Bank transaction. H. Fixed asset (with depreciation) 5. Prepare monthly financial statement (with the schedules Above) "Additional Scope" (I want you...

I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.

...market research. The task involves identifying and documenting all Amazon lockers situated near rural locations on Google Maps. The deliverable should be an Excel spreadsheet with the following information for each locker: I have provided a sheet with more detailed instructions attached, with list of cities required included. - Name - Address - Picture - Need link to image or image attached. - Operating hours This research is crucial to exploring potential market opportunities. It's essential that the information is detailed and accurate to assist me in making informed decisions. Will need to have provide a and excel or google sheet document with the information requested above. Need at least 1 picture per location. Please I am currently on...

I need a skilled VBA developer who can help with an important task -- Macro Programming. The main purpose of this programming will be to improve the output of data in a more coherent and meaningful way. Here's what the project involves: - Macro Programming: I am specifically looking for someone who can build macros in our system to ease the process and make it more efficient. - Data Output Formatting: The second important part of the task is to navigate data output formatting. Even though I haven't specified the kind of formatting, this is a crucial aspect of the job. Skills and experience necessary for this project include: - Proficiency in VBA development and Macro programming - Experience in managing and manipulating data - Skills in data output formatting...

business profit loss reporting excel(Jan, Feb & March)

...assist with multiple tasks related to creating and manipulating sheet metal panel drawings. The work will primarily involve: - Creating 3D models from 2D drawings - Making modifications to these models - Generating flat patterns needed for manufacturing - Setting up configurations and global variances for sizes, materials, and thicknesses Moreover, the final goal is to establish a DriveWorks automation project. I'm looking for someone to ensure it encompasses: - A customizable user interface for parameter input - The ability to automatically generate reports or documentation I need this project to be completed as soon as possible. Ideal candidates should have a strong background in Solidworks, with extensive experience in sheet metal panel design and DriveWorks...

Please Sign Up or Login to see details.

-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static...

I need an experienced data entry person to perform research on Twitter(X) for crypto/stock twitter influencers/posters with over 1,0...who make predictions on crypto/stocks. @CryptoCapo_ is one example of a desired crypto influencer account. I also want you to find stock and crypto prediction Substack accounts, there is no subscriber minimum. It is your job to find other similar accounts and make a spreadsheet with two sheets, one for twitter and one for substack. the twitter sheet will include the twitter handle and the link to their profile for each account. The substack sheet will include the link to the main substack page, the number of subscribers, and whether the substack is free or paid. if the substack is paid, please have different columns for the different tiers ...

...each item. • Delivery You will be given a Google Sheet template and bank statements to work on. You will work autonomously with minimal supervision. • Workplace You will be working online remotely. • Experience Please show us your detailed related work experience. • IP The intellectual property, including the source code, belongs to Sors Markets Ltd. • Future work I hope that one day you can be good enough to handle some of the simple payments and research on, for example, flight and train tickets. If you can handle the preliminary work, more admin work can be shifted to you, and the number of hours on the task will increase. If you have any questions, please send us a message. Key skills: - Proficient in Microsoft Excel / Google Shee...

...each item. • Delivery You will be given a Google Sheet template and bank statements to work on. You will work autonomously with minimal supervision. • Workplace You will be working online remotely. • Experience Please show us your detailed related work experience. • IP The intellectual property, including the source code, belongs to Sors Markets Ltd. • Future work I hope that one day you can be good enough to handle some of the simple payments and research on, for example, flight and train tickets. If you can handle the preliminary work, more admin work can be shifted to you, and the number of hours on the task will increase. If you have any questions, please send us a message. Key skills: - Proficient in Microsoft Excel / Google Shee...

...causing any conflicts. - Need to add additional search filter "Industry" before other search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries on this job board. - Need additional search fields for both Company / Employer, Candidate, Job Search and Filter, Post Job. - I would like to know if it's possible to upload job titles from excel into the job fields for search criteria. - I would also like a place for employers to add job title if it's not in the list. Most is setup in templates, just needing a few additions and changes. Would like additional blank fields that I can fill in later as additional requests are made. - Possibly style search and output pages. I'm open to input from previo...

...commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this...

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

...one for the general public. For the general public: 1. When a sender sends any message, number, or letter, the bot greets them and requests input of a code or menu name (there are 200 codes or menu names available). 2. If the input is incorrect, the bot asks the sender to resend the correct code, send an image containing all the codes, or return to the main menu. 3. If the code is entered correctly, the bot displays general information in text form taken from a Google Sheet. Along with this information, a menu is displayed: • PDF file extracted from Google Drive or a folder • Image • Information in text form taken from a Google Sheet • Input another code • Return to the main menu For subscribers: 1. Information from PDF files or images is so...

...of images in marketing, web, and print materials. Timeline: Photographer Qualifications: Proven experience in architectural and real estate photography. A strong portfolio showcasing similar projects. High qulity camera and lens. ataching example in this link in special for 72-01 Queens Blvd I need whole building shot , Ataching file with reference....

I'm seeking a professional to create an Information Memorandum specifically aimed at securing financing from venture capitalists and or private equity. This document should include detailed financial information, such as: - Revenue projections - Profit and loss statement - Balance sheet - Adopt government statistics - Market & Industry Analysis - Design funding models The ideal candidate for this job should have a solid background in finance, business analysis, and experience in creating successful Information Memorandums for the Australian market. They should be able to present complex financial data in a clear and concise manner to appeal to potential investors.

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

I need a modern and minimalist logo designed for my company, 1031 Cap Ex, to be used primarily in marketing materials. NOTES: - only the C and E should be capital like this 1031 Cap Ex - look at uploaded examples for style reference. do not copy. come up with a new logo that follows those styles Key Points: - The logo design should be clean and simple, reflecting a modern and minimalist style. - It will primarily be used on marketing materials, so the design should be versatile and scalable. - The target audience is sophisticated, so the logo should convey professionalism and trustworthiness.

Looking for someone to do full drawing set for gas station design. Must have previous experience. Please provide a previous project as reference when bidding.

I'm in need of an experienced professional who can assist with financial statements preparation using Tally accounting software. Key Responsibilities: - Preparation of Balance Sheet, Profit and Loss Statement, and Cash Flow Statement Ideal Skills: - Proficient in Tally software - Experience in financial statements preparation - Attention to detail and accuracy in work - Knowledge of accounting principles and practices This role is vital to ensure the accuracy and validity of our financial data. Please only apply if you have demonstrable experience with Tally accounting software and financial statements preparation.

I'm looking for a talented graphic designer to create a vibrant, 8k cartoon profile photo for my PUBG account. Key Requirements: - Style: Cartoon - The photo should be in a visually appealing, animated style. - Elements: In-game items - I'd like the photo to include some notable in-game items, which I will provide for reference. - Color Scheme: Bright and vibrant - The overall color palette should be lively and eye-catching. Ideal Skills and Experience: - Strong background in graphic design, with experience in creating cartoon-style artworks. - Proficiency in using design software to create high-resolution, detailed images. - Familiarity with PUBG or similar games to understand and accurately depict in-game items. Note: As the photo will be used as a profile pict...

Hi VJ IT Services, combine like last time, Data sheet has main data and secondary data (if you cant find a name)

Hello, I'm looking for a web developer to review and correct the structure of my project. The container, where all the site's content will be, should be 1100px and centered. The font hierarchy should also be corrected and the site should be responsive. In the files, you can see the reference of the main pages for desktop and mobile. It should also be applied to the pages of the three projects.

...enhance readability and draw attention to key areas. Print and Digital Versions: Provide print-ready files suitable for professional printing. Create a digital version that can be easily shared online or via email. Additional Elements: Include a cover page with our logo and a brief introduction to our company. Design a back page with contact information, social media links, and a call-to-action. Reference for Design Inspiration: We would like our pamphlet to have a similar professional look and feel to the maintenance plans pamphlet provided by Larson Air: Larson Air Maintenance Plans. Project Deliverables: Initial design mockups for review and feedback. Finalized design files in high-resolution PDF format for print and digital distribution. Source files in Adobe InDesign or ...

...need of a freelancer to assist with labeling text tweets by topic (to aid in machine learning research). Key Requirements: - Labeling 1,000 tweets as to whether they are about the topic sustainability - Must be labeled by hand (no machine learning or AI) by a native English speaker Task: -Open the attached spreadsheet -Read the FULL TEXT of each tweet. Also read the brand handle and sector for reference. Make sure to pay attention to any hashtags included. -You do not need to open any URLs. Make your judgment based only on the text. -If the tweet is about sustainability, enter "1" in column E. If it is not about sustainability, enter "0" in column E. -Note that "sustainability" is a broad topic -- it is often a judgment call as to whether a given...

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...

...Responsibilities: Collaborate with our CRM team to understand our current processes and requirements. Conduct thorough research and gather necessary information. Write detailed, step-by-step instructions and guidelines for various CRM processes. Ensure documentation is easy to understand and follow for both new and experienced users. Organize and structure the content logically for efficient reference. Maintain consistency in writing style, tone, and formatting across all documentation. Study the agency website () to understand the services and sub-services provided. Set up a full database of minimum 30 to 40 demo clients or sample clients in the GrowCRM system, covering all stages from leads to task completion, payment, and ticket management. Create demo data from beginning

Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing value...(e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsoft Fabric and Excel (VBA) • ...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

...Arizona and our RV resort. We also need you to design 6 billboards and signs for our RV resort. The magazine will be composed of: 1) A 35 page magazine/brochure containing ads for local businesses, small business features, business directory, area information, etc. The design and copywriting for each page, including ads, need to be created by you. We can provide an outline and resources for reference, as well as photos. We can give you some information about the business, some guidance/references, but will need you to write the copy (using AI is fine), 2) Design of clean and modern billboards for our marketing launch, aligning with the design of your previously designed brochure and storage center ad to maintain consistency. For the magazine/brochure, the content wil...

I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data...

We are seeking a talented Houdini/C4D 3D Artist to create captivating animations for our website. The ideal candidate will have a strong background in 3D modeling, animation, and visual effects, with a keen eye for detail and creativity. Proficiency in Houdini and Cinema 4D. Strong portfolio showcasing 3D animation work. Experience with modeling, texturin...create captivating animations for our website. The ideal candidate will have a strong background in 3D modeling, animation, and visual effects, with a keen eye for detail and creativity. Proficiency in Houdini and Cinema 4D. Strong portfolio showcasing 3D animation work. Experience with modeling, texturing, lighting, and rendering. Ability to work collaboratively in a team environment. Please reference previous work samples. ...

I'm looking for a seasoned Python developer who can assist in two main areas: - Creation of PowerPoint presentation using a CSV data file - Automate the process via a public URL to upload the CSM file Creation of Powerpoint Presentation The CSV file will feature data-points in columns. A powerpoint presentation template will be provided for reference. The graphs and tables should be present as per the data-points present in CSV file. Automating the Process This is the secondary part of the job. Once we have are successfully able to convert a CSV data in PPT format, we should create a public secured link to upload the file. It should be auto-converted and file should be ready for download. The ideal candidate should be a proficient Python Developer with a solid understandi...