Excel vba copy cell jobs
...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 like this,...
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 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 Don't respond to AUTO BIDS and COPY PASTE BIDS NOTE: i want a screenshare tutorial only. i don't give you any files. I want someone who teach me blender or other 3d software for the following. 1. i am having trouble with importing .fbx and .glb files 2. no need to create 3d models or textures. 3. everything was created and animated. 4. your task is to import , check the files and fix if any issues are there. 5. i will pay per hour only.
...and intangible assets, as well as financial assets. - The Ultimate Goal: The primary objective of this project is to implement robust asset management practices via a comprehensive depreciation forecast. I'm seeking a professional with: Creating a excel spreadsheet that i can download my asset register into and then have the worksheet calculate future annual depreciation say to 10 years. But also allow the ability to have the individual assets to be revalued either an increase or decrease in the original asset cost. This would mean the excel sheet would need to be able to take into account prior accumulative depreciation and adjust in the year we are currently reporting in. The attached file is current assets as at 30th June 2023. No depreciation has ran for FY24 ...
I'm in need of a freelance job, specifically requiring assistance with Excel. This project is tailored for someone with experience in the following areas: - **Excel Expertise**: I'm looking for someone who is proficient with Excel, especially in handling data analysis tasks. The ideal candidate should be comfortable with manipulating large data sets and extracting key insights from them. - **Data Analysis Skills**: A strong background in data analysis is crucial. You should be able to interpret data, identify trends, and provide meaningful conclusions based on your analysis. - **Attention to Detail**: As this job involves working with data, high attention to detail is a must. The ability to spot errors or irregularities in data sets is crucial to the succe...
I'm in need of a skilled accounting professional who can seamlessly handle a variety of accounting...bookkeeping, financial analysis, and tax preparation. Key Responsibilities: - Timely and accurate bookkeeping: Keeping track of all financial transactions. - Perform financial analysis: Analyzing financial data and creating financial models to support decision-making. - Tax preparation: Preparing and filing tax forms in a timely and accurate manner. Ideal Skills and Experience: - Proficient in Excel, Tally Prime, and Zoho Books. - Strong understanding of bookkeeping, financial analysis, and tax preparation. - Prior experience with daily accounting tasks. - Excellent attention to detail and organizational skills. - Strong communication skills and ability to work efficiently an...
...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 ...
I am in need of a freelancer to help with copy typing from online databases. - I need the data to be copied accurately from these online databases to a specific format. - The entries are in text format, so you would need to have good typing skills and attention to detail. Ideal Skills: - Proficient in typing and data entry - Experience with online databases - Detail-oriented and accurate in data entry.
I'm in need of an experienced copywriter for social media content. I aim to boost my brand's online presence and engage my audience more effectively. To do this, I need captivating and compelling copy for my social media platforms. Key Responsibilities: - Crafting engaging and compelling copy for different social media platforms. - Ensuring brand consistency and tone across all posts. - Delivering posts on time and following a set schedule. - Collaborating with the marketing team to align the copy with our brand's goals and strategies. Ideal Candidate: - Previous experience in copywriting, particularly for social media. - Understanding of different social media platforms and their audiences. - Creative thinker with a knack for storytelling. - Abilit...
I'm looking for a skilled fullstack developer, well-versed in Angular 10, to make improvements on an existing website. Your primary role will involve optimizing the website for higher performance. You'll need to handle a timeout although the timeout period is not know at the moment. The ideal candidate should: - Be proficient in Angular 10. - Have a...Analyzing website performance. - Identifying areas for optimization. - Implementing changes to improve performance. A strong grasp of SEO strategies and conventions will be advantageous for this role. Please share any relevant past experiences with website optimization in your bid. The code base is on a virtual machine, so you'll have to work alongside me to fix the issues as I will not be able to copy or paste anyth...
I need a talented artist and copywriter to create two persuasive sales pages. These pages will showcase two of ... Specific responsibilities will be: - Creating a photo-realistic 3D rendering of each product. I will provide the 3D models and product details. - Writing convincing sales 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 valu...
52 sheet for 52 week needs to contain mon-Friday. I will register everydays expense on that.
1. Here is a list of S&P 500 companies 2. Collect and download the shareholder letters for those companies between 2005 ...find those shareholder letters in the firms' annual reports. This website provides many annual reports. 3. If annual reports are unavailable on , you can go to the companies' website and manually locate those files (usually under investor relations). 4. The letters are usually included in the first few pages of the annual reports. 5. Copy and paste those shareholder letters into TXT files. 6. Save the TXT files with the ticker symbol + year. For example, for the shareholder letter of Apple in 2020, the file's name will be APPL2020. 7. I Hope to get this done within one week.
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
I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports. So the person MUST have Ms Project experience to understand how project constructs data. Key tasks include: 1. Utilizing VBA to automate the generation of project summary 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&...
...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...
...need of a skilled DIRECT RESPONSE copywriter to create lead generation copy for Medicare open enrollment. The target audience for this project will be 65+. It is essential that the copywriting style is conversion focused and engaging. Key Project Deliverables: - Direct response mail - Medicare compliant copy for flyers, welcome kits, member communications Ideal Skills and Experience: - Proven experience in direct response copywriting for healthcare (Medicare) or insurance services, ideally with a focus on seniors. - Strong understanding of Medicare services and benefits and compliance. - Ability to write in a direct response conversion copy, while still conveying complex information clearly. - Experience in creating copy that is engaging and lead generat...
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 ...
I need an expert in Microsoft Excel to create a functional, cleanly-designed household income and expenditure sheet from scratch. This task involves: - Data entry: This household finance sheet should allow for comprehensive tracking of earnings and spendings. - Formulas and calculations: The spreadsheet should automatically compute totals thereby providing a real-time, holistic view of my financial landscape. - Formatting and design: The sheet should be intuitively organized and visually appealing for ease of use. I haven't decided on a specific template yet, so there's an opportunity to be creative and propose a clear, easy-to-understand format. The sheet should have a basic level of detail, categorizing different types of income and expenditure, but without the need f...
I have a website, , and the Contact Us form fails to send emails to me when people fill it out. It used to work on Justhost, but it stopped working when I moved the website to Hostinger. The form uses PHP. I made a copy of the website, , so fix the form there too. Once you've done that, change the logo text on the copy website to "Online Class Done For You".
Hi, I am a Civil Engineer with 20 years of experience in Construction Management from Amman-Jordan. I am now seeking a role that will allow me to ...expertise while advancing my career to the next level. I am particularly interested in positions that offer leadership opportunities in innovative projects in the Gulf region (Saudi Arabia, UAE, Qatar, etc....), My background in Civil Engineering combined with a PMP certificate uniquely positions me to excel in roles that demand technical and professional skills. The milestone for this project will be to land a new job position, I'm open to discuss any suggestions on how to work this out. Attached a copy of my CV. Thank you for considering my request. I am eager to embark on this journey with your guidance and support. ...
I am an agent for a solar company and I need an eye catching flyer design to post around town. Please see the company flyer format attached. I want something similar to this but it can't have any company logos on it. I need one single page. No company information or statistics can be present, only solar statistics. We can keep the accreditations at the bottom of page 1 I like the title already displayed - "Take Control of Your Energy" Save up to 80% on your current energy bills 387% average return on investment for our customers Join 15000+ customers who saved £1,652,000 in 2022 [Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions] Things along these lines but feel free to propose something different
I need support in adapting my Excel sheet into a DataFrame, geared towards reporting purposes. While the Excel sheet structure is not concrete, the relevant columns to be extracted and placed in the DataFrame tend to be A, B, and C. However, I'm undecided at the moment on whether this extraction process should be manual or if the system should automatically detect and save the columns. Ideal Skills and Experience: - Expertise in Excel and data analysis tools - Experience in creating data frames for reporting purposes - Ability to advise on manual versus automatic extraction.
I am looking for someone who can help me correct some formulas and formatting errors in my Excel spreadsheet. - The spreadsheet contains Sum and Count formulas that need to be fixed. - There are also formatting errors that need to be addressed. Ideal skills: - Proficiency in Excel - Experience with formula correction - Attention to detail for formatting errors.
Need a excell sheet with a site with the total of all "contractor" that are set to the single projects. All contractors have thei own page, that u can upload a invoice who is saved on the web/sky. The single invoice that is uploaded is set by date, amount, billing nr, and are taget and subtaget with the right tag, that are selected from dropdowns. U can also leave a comment. Hi, Im interested. How long is it for you to finish this? I also wonder, how is your thoughts about the storing of the invoices/files that are uploaded. This should be on the web/sky. Also need a "scan" function, so we can compare a invoice towards a "offer from a supplier", so we can see if the price is corrext. So it needs to be possible to upload an offer/pdf that you get from a sup...
I require a skilled integrator to seamlessly connect our existing Excel spreadsheet-formatted payroll system with a new payroll system. The details set to be transferred are Employee Information, Salary Details, and Attendance Records. This integration should be done in a manner that ensures a monthly data transfer from the Excel spreadsheet to the new payroll system. Ideal Skills and Experience: - Expert-level understanding of Excel and payroll systems - Prior experience in integrating Excel with other systems - Knowledge of data migration and data integrity - Proficient with scheduling automatic data transfers - Understanding payroll related data security protocols
...information as necessary. -Organize inventory lists and products on the website. -Script research and writing for various informational videos. Qualifications: Bachelor's degree in a relevant scientific field - molecular biology, microbiology, chemistry, etc. Prior experience in a similar role, preferably in the scientific or healthcare industry. Proficiency in spreadsheet software (e.g., Microsoft Excel, Google Sheets). Familiarity with e-commerce platforms such as Netsuite and Shopify is a plus. Excellent written and verbal communication skills. Fluency in English - both verbal and written communication. Ability to work independently and manage multiple tasks simultaneously. Attention to detail and accuracy in data management. Strong organizational and time management sk...
I require assistance with Excel for basic arithmetic operations, including the creation of simple macros to automate certain repetitive tasks. Key Requirements: - Proficiency in Excel: I need an expert who is well-versed in Excel and can help me set up basic formulas for tasks like addition, subtraction, multiplication, and division. - Macro Creation: I'm looking for assistance in creating simple macros that will help automate some of the repetitive tasks in my worksheet. Ideal Skills: - Proficient in Excel: The freelancer should be comfortable with Excel's advanced features. - Experienced in Macro Creation: The ideal candidate should have experience in creating simple yet effective macros for automation in Excel. - Excellent attention to deta...
...am seeking an advanced Excel expert to help with tasks such as data analysis, creation of complex formulas, and process automation. While the specific tasks are not defined yet, rest assured that the job involves deep knowledge of Excel and requires excellent analytical skills. Below are the ideal skills and experiences for the job: * Proficiency in Excel data manipulation and analysis * Knowledge and experience in generating complex formulas * Proven track of Excel-based process automation While applying, consider these: * Showcase of previous work involving advanced Excel projects * Detailed account of your Excel experience * Comprehensive proposal describing your approach to the project tasks at hand Lastly, the core purpose of this projec...
...experience in transferring data from Excel to Word. I have an excel file with 210 opponents of my football team, every opponent has it's own worksheet. In this file there is the name, city, maybe a remark about the name, the first season we played against them, the last season we played against them and the aggegare score (number of times played, won, drawn, lost, points, goals scored, goals conceded) both home and away. See the sample file as attached. The goal of this project is to have these 210 opponents in the Word file I attached. As you can see I have down the first two opponents already so you know what this project is about. Key Responsibilities: - Transfer data from one Excel file to Word meticulously Ideal Skills: - Excellent knowledge of Mic...
I'm looking for a freelancer who can create a simple, yet effective, VBA macro to combine a set of between 10 to 50 small CSV files. These files all share the same column headers, and the macro should merge the data in these CSVs while maintaining the column sequence as provided. This task is straightforward and should not take much time for an experienced freelancer. A successful completion of this task will certainly result in a 10-star rating from me. See the uploaded document that details what needs to be done. I will provide the coder that I choose with several sample small csv files to combine.
I'm in need of a skilled freelancer who can quickly extract data from scientific papers and input them into Excel spreadsheets. Key Responsibilities: - Extracting data from multiple scientific papers - Organizing the extracted data into Excel spreadsheets Key Requirements: - Experience with data extraction from scientific papers - Proficiency in working with Excel spreadsheets - Ability to work under tight deadlines The ideal candidate for this project would be someone who is detail-oriented, experienced with scientific data, and capable of working efficiently. The project is time-sensitive, with the need to have it completed as soon as possible.
As an organization focused on understanding our customers better, we are in need of an Excel tool that is designed to handle customer data. Specific functions needed are: - Advanced calculation and formula functionality. You should be adept in creating and troubleshooting complex Excel formulas. - Data Visualization: Ideally, you should be skilled in creating efficient and easily interpretable Bar Graphs. This is how we'd prefer our data to be visualized. Key skills and experience: - High-level proficiency in Excel - Demonstration of designing efficient data visualizations in Excel - Ability to work with customer data effectively. A comprehensive understanding of Excel, including experience with customer data analysis, will position the chosen fr...
I have about 40 parcels of real estate that I need additional data retrieved on. (this parcel numbers are listed below) This is a web data retrieval project. Each parcel will be searched here: Produce an excel file that has one row for each of the parcels. You will retrieve the following data for each of the parcels: 0. County: (Will all be Galveston since search is Galveston CAD) 1. Parcel Number (This is the number you use to search) 2. Account: Property ID 3. Account: Type 4. Location: Situs Address 5. Location: Legal Description 5.5. Property Values: Homestead Cap Loss 6. Owner: Name 7. Owner: Mailing Address 8. Owner: % ownership. 9. Property Land: Acreage 10. Property Land: Sqft 11. Property Roll Value History 2024 Improvements 12. Property
As we discussed, I'd like the website you did to have all the information as the shopify store you set up. I also want you to connect to shopify store to have buying capability. You said you would finish in 6 days.
...in need of a real-time Excel sheet where 135 workers across 9 different squads can sign up for their work days by selecting their 3 top choices for the week to work overtime. Last column should be used to pick one day OUT OF THE MONTH where they would like to NOT be used for overtime. Key features include: - The ability for workers to select their workdays from a calendar interface. - The sheet should be able to automatically update in real time if they all can access the excel sheet. The information for each worker to be captured in the sign-up sheet should include: - Worker's name (We will input that information) 15 slots - Top 3 choices to work overtime for their respective week (calendar is provided to go by) Ideal skills and experience: - Proficiency in E...
I currently use ERP Bling and am looking for a freelancer who can help me create integrations for product registration. Main integration points: - The integration must include field...Main integration points: - The integration must include fields for ‘Name’, ‘Description’, ‘SKU’, ‘Price’, ‘Acquisition cost’, ‘measures’, ‘NCM’ and ‘categories’. - Data must be transferred effectively and accurately from Excel to ERP. Ideal Skills and Experience: - Proven experience in ERP systems, particularly with Bling. - Strong understanding of the product registration process. - Familiarity with e-commerce platforms, accounting software and CRM systems to ensure seamless integration. - Proficiency in ...
I need a skilled WordPress developer to help me create a site that mirrors the homepage of c3.ai. It's crucial that the site is a custom build and not a copy-paste of the source code. The main aim of this site is to showcase my products/services. Therefore, the look, feel and functionality of the site need to be highly professional. Ideal Skills and Experience: - Strong proficiency in WordPress development - Experience in creating custom sites from scratch - Ability to replicate complex design and functionality - Understanding of UX/UI principles - A portfolio that demonstrates similar previous work would be beneficial. add i can do in bid to identify that you read the project and can do it. This project is a great fit for someone who enjoys a challenge and has a keen ey...
I'm looking for a proficient Excel expert to help me set up and automate an inventory in Excel software. Key requirements: - I need to track between 100-500 different types of items. - The inventory should be able to update and transfer data to different worksheets automatically. - I'm also interested in adding automatic calculations, like the total value of the stock. Ideal Skills: - Proficiency in Excel and experience in setting up complex inventories. - Automation skills in Excel to ensure smooth and efficient data updates. - A good understanding of inventory management principles to ensure the system is effective and user-friendly. Please reach out if you have the right skills and are interested in tackling this project.
I'm in need of a freelancer with experience in using Crystal Reports - particularly with Excel, Google Sheets, and Web Services/APIs. Requirements: - Expertise in Crystal Reports: I require a freelancer who is somewhat familiar with Crystal Reports; this is non-negotiable as I need someone who can hit the ground running. - Data Sources: I need the reports to connect to both Spreadsheets (Excel, Google Sheets) and APIs/Web Services. - Report Quantity: The project includes less than 10 reports. Ideal Skills: - Proficiency with Crystal Reports. - Experience in connecting to Excel, Google Sheets, and Web Services.
