Macro to format excel sheet jobs

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient da...

I'm looking for a talented event photographer to capture moments at my daughter's upcoming birthday party. The ideal candidate should have experience in event photography and be able to deliver the final photos in digital format. Key Requirements: - Must be proficient in event photography - Able to cover the entire event, including the cake cutting ceremony - Good with capturing candid moments of guests and family It's important for the photographer to have a keen eye for detail and an ability to make everyone feel comfortable in front of the camera. This role would suit a friendly and professional individual who can blend into the event while capturing the most memorable moments.

..."Adelya Expansion - Australia and New Zealand" Step 2: Open the Excel sheet named "Companies in whose name the file is to be saved " Step 3: Note that in the Excel sheet, the second name after Adelya is Tecmark Step 4: SAVE the Powerpoint file as "Tecmark Expansion - Australia and New Zealand" Step 5: Replace in Powerpoint (Keyboard command is Alt-E-E), the name "Adelya" with the name "Tecmark" Step 6: There should be 12 replacements, then you know you have done it right Step 7: Save the file once again as "Tecmark Expansion - Australia and New Zealand" Step 8: Save a second copy of the file in PDF version (Powerpoint will offer you an option called "Save as file type") Step 9: That...

...professional who can help me with the design and typesetting of 30-35 pages of registration and agreement forms. The key specifications of this project are as follows: - The forms I need are mainly Registration Forms and Agreement Forms. - The forms are to be designed for digital use only. I do not require physical copies. - The final deliverables should be in PDF and MS Word format. - The forms need to have fillable form fields. - The design must be appealing, professional, and align with the branding of my organization. - Attention to detail is crucial to ensure no mistakes or inaccuracies. I am looking for someone with a strong background in Desktop Publishing (DTP) and graphic design, who can deliver quality work in a timely manner. Experience an...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...Books system for my invoicing processes. Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). - Enable and Teach me to Use Odd's OCR feature to fetch pdf data from invoice to transfer it to software Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look for...

...and analysis purposes. Key Details: - The meetings are expected to continue for three days each. - All meetings will be conducted in-person. - Clarity and audio quality are of utmost importance. - Quick turnaround time is crucial. Required Skills & Experience: - Proven experience in professional audio recording, particularly in meeting and conference settings. - Strong attention to detail and professionalism. - Fast and efficient, without compromising the quality. - Excellent time management skills. - Ability to handle unforeseen recording challenges that may arise. - Familiar with different audio formats and compression settings, to deliver the final product in the desired format. - Understanding of audio editing, to remove unwa...

I have a file that was completed. However the designer as unable to make sure the background would print in navy blue. I am attaching the file but need to make sure the following directives are met for the background. Cyan and Magenta need to be 30% apart Need someone that can send in CMYK format Suggested Color for navy100, 91, 42, 59 The backdrop will be 8'8 in size

I have a large batch of text data in PDF files that needs to be copied and pasted into a specific format. Key Requirements: - Transfer text data from various PDF files - Ensure accuracy and precision in the copying - The time-sensitive nature of the task - The data must be transferred into a format that is easy to work with Ideal Candidate: - Proficient in using PDF files - Strong attention to detail - Previous experience with data entry/copy-paste tasks - Ability to work under time constraints

I have collected the dataset in CSV format and now require an expert to develop a multi-class logistic regression model for me. Key requirements: - The dataset is ready and available in CSV format which can be used for the model. - You should have expertise in developing logistic regression models for multi-class classification. - Proficiency with Python is a must as I prefer the model to be developed using this language. Technical Requirements: Proficiency in Python and familiarity with libraries such as NumPy, Pandas, Keras, and TensorFlow. Knowledge of statistical learning, logistic regression, and gradient ascent optimization. Ability to write clear and concise documentation and well-commented code.

I'm looking for a skilled professional who can successfully convert 2D images to 3D. The specifics are: - The images I provide will be in JPEG format. - The 3D conversion should be in STL format. - The final 3D result will be used for designing human images. Ideally, you should have proficient knowledge and solid experience in 3D modeling and image processing. A good hand in tools like 3D Studio Max, Blender or similar is needed. Experience in designing human figures in 3D is a massive plus.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I'm in the religious industry, looking to extract a dove and keys symbol in an IPS format for my marketing and signage. I'm not sure if these elements are available in the original files, so you might need to advise on whether they should be recreated from scratch. Ideal Skills and Experience: - Graphic design expertise, especially in using IPS format - Knowledge of religious symbols and their connotations - Experience in marketing material and signage design - Good communication skills to advise on the appropriate approach.

You will take screenshots from various reddit subreddits and make a simple video similar to the format of these videos: @rSlash/videos You must be able to create a quick thumbnail similar to the above with each video. Can use ElevanLabs for voiceovers. -You have an eye for detail - no mistakes. -You are able to create a large quantity of videos, and you do not miss your deadline. Budget: $15 per long form video. They will be in batches, and this has potential to be long-term. If interested, please title your application "Video Editor for Faceless Youtube Channel." Add a link to your past editing samples + confirm that you edit in Adobe Premiere Pro. We will proceed with a short trial assignment.

Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquir...

...tattoo design for me. NOTE: The design is to be based on an existing tattoo (photo is attached, must incorporate this tattoo), but expanded upon with a fresh blackwork twist. The placement is upper arm/shoulder area. The current tattoo is approx. 3 inches but I would like the new design to cover more area. The ideal candidate should be well-versed in tattoo design, particularly blackwork style. It's crucial that you've got a keen eye for incorporating sacred geometry and symbolism into your designs. Key Points: - Proficiency in blackwork tattoo style - Ability to artfully incorporate sacred geometry into the design - Understanding of creating symbolism in tattoos, particularly representing enlightenment and spirituality Your creativity and ability ...

I'm seeking an expert in Google Sheets to help me create a functional document geared towards tracking paint and repair tasks, and cleaning schedules across a busy summer camp campus. This sheet will be regularly updated by our facility maintenance team. The ideal candidate should: - Have substantial experience in creating dynamic and user-friendly Google Sheets. - Understand logistics and scheduling in a maintenance setting. Key features of the Sheet should include: - A system for recording painting/repair locations. - Fields for indicating the type of paint or repair needed. - An integrated cleaning schedule that doesn't disrupt ongoing summer camp activities. - A remark section to note if the cleaning crew has cleaned, dusted and removed furniture...

I need a developer who can assist me in implementing Voice Activity Detection (VAD) for the Mulaw Format at 8000hz (streaming) Key Requirements: - Development of a robust VAD system that can accurately detect voice activity within the Mulaw audio streaming - The VAD system should be optimized for 8000hz audio quality - Prior experience in speech recognition and audio processing is highly preferred

Need exactly the same design with the attachment please provide the design in high quality pdf format. Also need the project files as well. Gonna use this design on wedding invitation card

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in G...

I need a specialized quote template for proposals in Word format. I am having trouble with the header and footer sections encroaching on the body of the document. I also need help embedding our logo in a way that it doesn't show the background when printing (currently the back ground is not transparent). I would also like the header and footer information to remain editable. Ideal candidates for this task should have: - Excellent mastery of Word and its design capabilities - Experience in designing business proposal templates - Ability to create a professional, clean, and easily adjustable template.

I need a skilled Web Scraping specialist to write code in Python (preferably) that scrapes a specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're

...440*280 The main task when drawing this banner is to force users to pay attention to your extension. This banner should be simple, minimalistic, and immediately convey the general essence of the extension. Also, this banner should attract attention. - Use contrast background - Use logo and name: “Time Zone Meeting Planner. - Size: 440*280 - Format: png Big banner (screenshot) 1280*800 A simplified screenshot of the extension conveying the essence of the product, and not necessarily all the functionality of the product. - Use a screenshot, remove all secondary elements (settings, offset, etc) - Draw a mouse and its movement while selecting time - Use text: “Find the best meeting time across time zones.” - Size: 1280x800 - Forma...

I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and accuracy...

I require a straightforward, user-friendly spreadsheet that calculates energy savings based on specific input. My needs are very particular. Here are the key aspects: Input Specifications: - It should only take one input: an initial savings value representing the savings our product offers. Calculation Requirements: - I expect the spreadsheet to perform calculations for both percentage and dollar amount savings. Results Format: - The results should be shown as simple numbers; I don't need them displayed as percentages or any graphical representations. The freelancer fit for the task should be proficient in spreadsheet software and have experience in building similar savings calculators. A good understanding of energy savings would be advantageous.

I need a skilled developer to help me create a high-quality app sheet for the education industry. The main aim of this project is to increase my online visibility and generate more leads. Key Features Required: - Primarily, the app must have quizzes and assessments. Ideal Skills and Experience: - Experience developing app sheets or similar software within the education sector. - Knowledge of incorporating interactive elements like quizzes into an app. - Strong understanding of how to optimize visibility online and generate leads. As an app developer on this project, you'll take on a pivotal role in creating a valuable educational tool. If you’re passionate about development and education, I'm eager to hear from you.

I need a VRBO scraper to extract property details, pricing, and availability. - The scraper should be built with Python and the output should be in CSV format. - The data points I need include property title, description, amenities, pricing, and availability. - The scraper should be able to handle multiple URLs at once. - The code should be well-structured and commented for easy maintenance. Ideal skills: - Proficiency in Python - Experience in web scraping - Understanding of VRBO website structure - Ability to handle and store data in CSV format

Please Sign Up or Login to see details.

I'm seeking an expert ...audio engineer who can produce a high-quality WAV sound format file that records music in gigabyte quality. The resulted file needs to be compatible to play on various platforms including but not limited to YouTube, Spotify etc. Specifics: - The file should offer unlimited recording capability, with no restrictions in terms of length. - Must possess proven experience in music editing and file formation. Skills in working specifically with WAV formats is a plus. - Familiarity with audio quality requirements for various platforms (YouTube, Spotify, etc.) is crucial. The importance of quality, compatibility, and versatility in this project cannot be overstated. Applicants should bid with relevant portfolio samples demonstrating the ...

We are in search of a skilled software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Pre...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new

We have print data for packaging but in the wrong format. It's a PDF and all single elements needed to create the new print data are delivered. We need someone who can build this 1:1 If there are questions - just let us know.

I need assistance with editing and formatting a document into MLA style. - The ideal candidate should have strong editing and formatting skills, especially in MLA style. - Proficiency in working with Google Docs is a must. - Experience with academic writing or editing is a plus. The task involves trans...editing and formatting a document into MLA style. - The ideal candidate should have strong editing and formatting skills, especially in MLA style. - Proficiency in working with Google Docs is a must. - Experience with academic writing or editing is a plus. The task involves transforming the existing document into MLA format, ensuring all citations, quotations, and formatting adhere to MLA guidelines. The document is currently in PDF format and needs to...

I require a one-time data scraping project complet...agency UAE Commercial Real estate agency Qatar Commercial Real estate agency Kuwait Commercial Real estate agency Bahrain I have made a start to the spreadsheet with a template for each of the regions which can be continued to be filled in. In the Google searches, just take the first 3 pages with the main agent listings and see what agent names/ email addresses you can find. - DATA REQUIRED: The primary data needed is text content. - TIMELINE: This is a one-time task, with no ongoing scraping requirements. Skills/Experience: - Proficiency in web scraping, especially from multiple websites. - Strong ability to extract data in a structured format, with a focus on text content. - Experience in handling o...

...language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source material, with the primary emphasis on the collation/assembly into the required format. An example of the required spreadsheet format is availabl...

I have a large set of handwritten notes that need to be accurately transcribed into digital format. I need someone who is meticulous and has a keen eye for detail, as the work needs to be done with no errors. Key Requirements: - Type of Job: Data Entry - Data Format: Handwritten notes - Level of Accuracy: Very High (no errors acceptable) Ideal Skills: - Proficient in typing - Detail-oriented - Experience in data entry, particularly with handwritten notes - Ability to follow instructions accurately and efficiently Your task is to convert these notes into a digital format, ensuring every detail is captured accurately. Your attention to detail and commitment to producing error-free work is crucial.

I'm in need of a legal professional with experience in drafting complaints. You'll be assisting me in preparing a formal complaint against certain Workers Compensation judges. This complaint will be ad...for freelancers who have a proven track record in drafting legal complaints or similar documents. Experience with Workers Compensation law or related judicial matters is a huge plus. Your responsibilities will include drafting a formal complaint in a professional and assertive manner. The end product should be in a letter format, with clear, concise, and persuasive language. If you're confident in your legal drafting skills and are an effective communicator, I'd like to hear from you. Your application should focus on your relevant experience and how you...

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

Create a design for a product listing on Amazon. The product is a cover for a towbar. You can find the full description in the assignment in PDF format. Deadline - 7 days

...of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for r...

...BIDS****************************************** ****************NEED TO BE NO MORE THAN 3 HOUR DIFFERENCE IN TIME FROM UK********************* I'm in need of a proficient report designer/builder to create some Sage 50 reports in Business Central. The designer should be able to create and design reports in a visually appealing manner. Key Requirements: - Design and build Sales, Purchase and Inventory reports. - In the Sales report, include Sales revenue, Sales quantity, and Customer names. - Present the Sales report in a table format. Ideal Skills and Experience: - Proficient in Sage 50 and Business Central. - Expertise in report design and building. - Ability to present data in a visually appealing way. - Good communication skills and able ...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

St...with websites, HAVING EMBEDDED YOUTUBE Videos on their sites. Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we have a longterm Partnership. To decide who is our partner and to see your understanding, please provide a sample with at least 50 data entries wi...

...specifications to be created in a standardized PDF format. The level of detail should include everything detailed on the spreadsheet. The data on the spreadsheet is broken down into the following sections, which must be reflected on the product specifications. - Production Information - Packaging - Pallet Configuration - Physical Data - Chemical & Microbiological Tolerances - Storage - Labeling You will be responsible for: - Creating individual product specifications from provided data. - Ensuring all specifications are formatted consistently in PDF format and include our company logo provided. - Include all the information provided in each product specification. Ideal skills and experience for this job include: - Proficiency in working with PDFs and spreadsh...

NERC Holidays Insertion Directions I am creating a excel sheet for electricity pricing research. There are typical days and there are holidays for which the typical load (demand) shape gets distorted. As a preliminary step in this project, I need to identify all of the holidays that occurred from January 1, 2006 until present. The recognized holidays for the US electricity markets are called “NERC holidays,” which is the abbreviation for the North American Electric Reliability Corporation. The six recognized NERC holidays are New Year’s Day Memorial Day (last Monday in May) Independence Day (always July 4) Labor Day (first Monday in September) Thanksgiving Day (the fourth Thursday in November) Christmas Day (always December 25) Please also add th...