Workbook.worksheets vbadela

We are looking for a freelancer to create an IFRS16 Excel Workbook for lease calculation. The workbook should have the following features: - Ability to handle multiple lease scenarios - Generate an amortization schedule - Ability to handle variable interest rates We only require assistance with the calculation features, so no data input or validation is needed. Ideal skills and experience for this job include: - Advanced Excel skills - Knowledge of IFRS16 - Experience in lease accounting and calculations The freelancer should be able to deliver a user-friendly and error-free workbook within the given timeline.

I am looking for a talented designer to create an eye-catching book cover for an upcoming workbook/journal for Amazon KDP, based on a famous self-help book by James Clear. Ideally, the artwork should be a vector illustration, to ensure the design holds up under any circumstances. It should also be something that accurately communicates the themes of the book and captures the attention of potential readers. What is the Book Title? Here is the text id like you to include on the cover. 1 Title: Workbook Atomic Habits. ( The word "Workbook" must either be in the LARGEST font on the page, or in a font that is at least as large as the rest of the original book’s title.) 2. An Implementation Workbook for James Clear's Book - Atomic Habits 3. T...

I am looking for a freelancer who can help me with an Excel Automation project. The ideal candidate will have experience with automating basic tasks in Excel. Tasks: - Automating data input from different sources - Automating formatting and sorting of data - Automating basic calculations and formulas Skills: - Advanced knowledge of Excel - Proficiency in VBA and macros - Experience with data manipulation and analysis If you are interested in this project, please provide examples of previous Excel Automation work you have done.

I am seeking a freelancer with expertise in VBA to create an automated report generator for data analysis purposes using Microsoft Excel. The ideal candidate should have experience in statistical analysis and be able to integrate custom formulas as needed. The report generator should be compatible with Microsoft Excel and must be user-friendly for non-technical individuals.

Hi there! Do you have experince good sheet scripts. Thanks

I am looking for an expert in Visual Basic for Applications (VBA) scripting to help me with a project. I already have the data set to work with and it is relatively small with less than 500 rows. I need Help designing macros and performing data analysis with macros utilizing VBA scripting. The ideal freelancer would be someone with experience in creating macros and working with spreadsheet applications like Excel and Google Sheets, who can apply their knowledge to help execute sophisticated functions with the data set I am working with. This should be a relatively straightforward and fast-paced project, so please get in touch if you think you are up to the task!

As a personal project, I'm looking for a talented individual to create a basketball simulator using VBA in excel. The primary purpose of this project is to be able to calculate performance analytics. This requires that the simulator be able to accurately track player stats and generate visuals such as graphs and data tables to aid in analysis. The project must be completed and delivered by April 13, 11 PM.

I am looking for someone to develop materials to teach others about investing in Bitcoin. Specifically, I need videos created that would provide a comprehensive overview of the subject, targeting those with beginner-level knowledge. I do not require any other presentation materials, such as worksheets or a webinar. The videos should be engaging and provide clear instructions on the topic, so that viewers can understand the fundamentals of Bitcoin investment.

extract , paste, verify, copy data from one file to another basing on various conditions. Needs to accept user sceen input for choice of cell action, cell and file location.

I am looking for a Freelancer to help me with an IFRS16 Excel workbook. The workbook needs to have the ability to calculate lease Liability, ROUA, Interest and depreciation based on the lease date inputted by user, and also account for various scenarios such as modifications of lease and terminations. This will include the Accounting Journal entries required based on the input date entered by user.

Need to create a VBA that does the below. Excel macro knowledge must As per the dimension in the Excel packing list, it automatically creates boxes in the AutoCAD LT application. Also adds descriptions inside the boxes from the Excel cell.

There are two sheets in which the names and codes are similar but not 100% Match. Example in sheet 1 the Item Code is "LG Monitor UG4992X4Y" and in second sheet the Item Code is "UG4992X4Y". We want a new sheet with column a containing the SHEET 1 Item Code and Column B containing SHEET 2 Item Code. There are totally 9000+ Item code. You need to be familiar with VBA coding, fuzzy lookup and Xmatch. The budget is 2000 To 3000 INR. We are not look for 100% accuracy but atleast 80-90%

I am looking for a Freelancer who is experienced in using Microsoft Excel. Specifically, I need someone who can work with all Excel versions. The goal of the project is to combine/extract certain sheets or data from two different files, used the common data sets to make the final outputs using formu...common data sets to make the final outputs using formulas and scripts. Background: I have raw data that I paste into one of the sheets. This is typically done weekly to the script needs to be resusable. There will be data in 2-3 existing sheets in the workbooks. With the raw data, and data from the existing sheets I need script to produce a Final Output Sheet. Existing scripts are present in the workbook to view and build off of. Will need advance proficiency with formulas, script...

Hello , I need someone to help me in completing this Modeling and simulation project. I really don't know where to start. The project description is in the pdf data that I included in my description.

Assist in Completing the Developing of the VBA Code for a Mobile Sales App

I am looking for the right person to help create a macro in Excel VBA to automate data processing tasks. The macro will need to be able to work with text data, running calculations on it and presenting the results of those calculations. No interactions with other files are needed, and the macro must be able to perform calculations on the data without any extra input. If you are familiar with Excel VBA and have extensive experience writing macros that can easily work with various types of text data, please get in contact with me. I am looking for someone who is available to begin working on this project immediately and can guarantee the quality of their work.

I am looking for a freelancer with experience in Microsoft Excel to help create an automated Excel sheet. The freelancer will be tasked with creating a sheet with the ability to process and analyze data. The freelancer must be experienced in working with Excel tools such as Standard, Pivottable, or Macro-Enabled workbook. When applying, unsuccessful freelancers should include details such as past work and project proposals to better demonstrate their qualifications. While this project does not include any existing data to be used, freelancers should still demonstrate the ability to use data and analyze it in their application. If you think you have what it takes to complete this project, don't hesitate and apply now! I am excited to hear your ideas and suggestions.

I have a workbook with 50 worksheets. Each worksheet list a competitor number, competitor, vehicle driven, class, dates during the year with their fastest time and the fastest time of the year. All set at 1 track. What i want it to have a combined worksheet showing : Driver, vehicle, class fastest time followed by the year in columns (2023,2022,2021 etc) Because its a small country, drivers sometimes share vehicles.

Change the userform to have 2 file selections. 1) Scanner File 2) SAP download file containing the database. Update the data in the SAP download file and save it.

I'm looking for an experienced VBA programmer to help create an excel macro for a project report of our company. The macro should be written in Visual Basic, and present an intermediate level of complexity for the generated report. We need the project completed within a week. The successful applicant will possess strong VBA experience, as well as understanding of business add-in applications in Excel and related programming languages. If you have proven experience in developing and optimizing efficient business systems and data analysis tools, we invite you to apply!

I need to create separate sheet for selected columns using checkbox

I wrote this or probably filched bits and cobbled them together about 20 years ago and it has served me so well all this time running in various guises or often just on it's own, but I would love to see it in VBA. The file is a cut down version of a worksheet I use to copy product information (usually prices but sometimes text information) from suppliers files to my own files. There are 2 macros, the first in VBA sets up the names used to the top of the sheet to work downwards, the second "Macro 5" is the Excel 4 macro.

I need help creating an Excel Database to store my data and query it as needed. Additionally, I will need the database to be integrated with an existing system. Having expertise in VBA is a must, as it will make setting up the database much easier. I’m looking for someone who’s experienced with creating such databases, and who can integrate the data with my existing system. I need someone who can quickly deliver results, so being able to execute the project diligently and accurately is also essential. If you think you can help me with this, please reach out!

I'm looking to hire someone to help with a data analysis project. I have an existing data set and I would like someone to use it to create a workbook that will generate a visual numeric report with formulas to format the data. The goal is to effectively communicate the meaning of my data sets. The freelancer will need to familiarize themselves with the data set and use various analysis methods to make sure the report is comprehensive, concise, and accurate. I am looking for someone with advanced knowledge of Excel and data visualization who can provide creative solutions and recommendations in order to efficiently represent and interpret my data. I would like a spreadsheet with specific formulas to format the data appropriately so it is easily understandable and visually ap...

VBA to build a macro in Excel that pulls in and stacks rows of raw data from a couple dozen flat files, de-dupes, and does some basic concatenation and formulas. Should be a breeze for someone well-versed in VBA/Excel. More detailed specs will be provided. The Macro should be 100% Functionnal with no issue or bugs and working in with all EM_Files

I am looking for a freelancer to create a pipeline simulation project using Excel VBA. It should be written in Excel VBA, stored in a spreadsheet and the complexity of the model should be simple. The successful developer must have experience in Excel VBA programming and be able to produce a robust model to handle the simulation. I am flexible with the project timeline depending on the complexity and the developer's availability. Please contact me if you are interested in this project.

Looking for someone who works with both these solutions, you will likely have heard of or used G Accon, those without accounting knowledge need not apply. I am creating worksheets for accounting purposes, they will be fairly basic, I need someone who understands "If" "then" For example, I would give them this document (Wiley textbook classroom example) and say "build me the worksheets"

Work part-time for us! Using your knowledge of Excel you will be helping to push our e-commerce business to the next level! This position is part-time. 2 - 4 hours per day. Between the hours of 9 am EST- 5 pm EST. The Skillset summary would be as follows: MS Excel - Proficiency in writing formulas and macros MS Excel - Programming using VBA that involves Http Webservice connection Postman - Understanding how Http Webservice API works, using the code in a CURL format MS SQL Server - Must be able to write SQL Queries such as Stored Procedures that involve Http Webservice connection - Must be able to create Sitemaps to scrape the correct data Bigcommerce - Understanding how the import file works

I am looking for someone to create a VBA program that can generate Excel to PDF files with password protection. The PDFs will be used for letter archiving, presentation of facts, and filling out online forms. The PDFs will need to have a password added for extra security and I don't need to sign the PDFs.

Hi, I need a VBA and Excel expert to prepare a utility for automation of excel working.

Aim & Expectations: The aim is to have an ongoing optimized batch scheduling tool to schedule rolling 3-week production schedule. I expect to be able to access the macro and being able to edit it whenever needed. I'll provide all details and variables after accepting your gentle offer. Description: I have a process which starts by blending products in six individual blenders with different capacities, each takes specific time. After blending I have the option to either transfer the product to one of eight holding tanks or directly to the filling machines. Each of the holding tanks is assigned to store specific product family/category [please check attached photo], The products in holding tanks should then be transferred to five the filling machines but they can also remain in ho...

...Excel as the spreadsheet program and need help creating a formula to fit my requirements. While I am familiar with formulas, I am not as comfortable using more advanced formulas like indices and array functions. I would really appreciate if someone could lend me a hand understanding how to use them. Please see the sample document. I'm going to have 1 worksheet for each month of the year in the workbook. They will all have a list of medications in column A1, the contents and order will not be the same each month. Columns B1:P1 are just abbreviations for hospitals and will always be in the same order. Columns R & S will be populated by hand and will be used in formulas later. Columns T,U, and V have simple formulas you can see in the sheet. Column W is just a spacer. Now ...

...for an experienced VBA Expert to join my team and work remotely during UK shift hours. This role requires a strong technical background in VBA programming and the ability to work quickly and efficiently. You must have a comprehensive understanding of database programming, Excel macros, and automation techniques, as well as the ability to troubleshoot issues that , this individual should have the ability to take complex tasks and turn them into achievable deliverables while working within tight deadlines. Please go through the below-mentioned points: 1. Candidate should have excellent communication skills 2. Candidate will be working for a UK-based company, so, they should be ready to work on a UK-based shift 3. Candidate should have excelent knowledge of VBA tool to...

This is a construction project but I need a couple of very interactive worksheets to assign work, RAG status, formulas, pivot tables and action log updates that also calculates how long an action has been open for and then some option to either close or close and reassign. Ideally be able to assign tasks on share point etc. I want a smarter version of this dashboard as this already has some issues. Thanks Camille James

Need to fix button links on form for queries, reports and update table with new dates.

I have an original workbook containing 3 sheets (named sheet 1, 2 & 3). Sheet 2 contains data that needs to be cut based on specific words in column AO (ie for all rows relevant to word 'X' or 'Y' a new workbook is created). The new workbook needs to: 1) maintain all formatting of original workbook 2) copy sheet 1 and 3, such that the sequence of sheets of the new workbook remains (sheet 1, 2 & 3) 3) file name of the new workbook should match the word in column AO (ie name of file should be 'X' or 'Y' depending on the data) 4) new workbook should be saved in the same location as original workbook

I am looking for an experienced programmer to help me with a project to overhaul the code for a Weekly Planner. The programming language to be used will be VBA and the program will be desktop-based. I am looking for an expert level of optimization in this project. If you think you are confident and up to the task, please feel free to reach out and let me know. Thank you!

For this project, I am looking for an experienced VBA Expert to join my team and work remotely during UK shift hours. This role requires a strong technical background in VBA programming and the ability to work quickly and efficiently. You must have a comprehensive understanding of database programming, Excel macros, and automation techniques, as well as the ability to troubleshoot issues that , this individual should have the ability to take complex tasks and turn them into achievable deliverables while working within tight deadlines. The candidate will also be responsible for the below-mentioned points: 1. Candidate should have excellent communication skills 2. Candidate will be working for a UK-based company, so, they should be ready to work on a UK-based shift 3. Candidate...

...manage incoming document signature submissions from Outlook. I need to be able to view, write and modify these contracts, so access control is partially necessary. I must also have the data tracked in a database for ease of use. The input to the track should be directly from email: my users will be instructed to use a specific word in the subject (i.e. or any other trigger you may build with VBA). The types of documents that need to be signed are contracts. If you have the skills to develop this type of tracker, we would be very interested in hearing from you. Please get in touch if you think you can help us with this project. The tracker should have, aside from the (1) tracking sheet: (2) a sheet where an AOA - Acknowledgement of Receipt can be printed (so details should...

I am looking for someone who is highly experienced with trading data analyzing. I will provide CSV file for process to you after starting work. You can process the data with C# or Excel VBA. If you are expert in C# or Excel VBA for trading data processing, you can do it within 1 hour.

I am looking for an Excel expert to help me design a spreadsheet. I have existing sheets that need modifications. The perfect candidate should have expertise in designing professional-looking spreadsheets and strong technical knowledge of Excel software including its functions and features. The ideal candidate should also understand how...spreadsheets and strong technical knowledge of Excel software including its functions and features. The ideal candidate should also understand how to input data, analyze data, create charts and graphs, and also be comfortable using complex formulas and macros. A successful track record of designing spreadsheets and working with numerical data is a must. If you have experience with pivot tables, VBA code writing, and statistical analysis that would ...

Job Description: We are looking for an experienced freelancer who can automate our monthly order process. Currently, our team manually generates reports. We are looking to streamline this process to save time and increase efficiency. Responsibilities: Analyze o...reports. We are looking to streamline this process to save time and increase efficiency. Responsibilities: Analyze our current order process and identify areas that can be automated Develop an automated system for report generation. Test the automation system and ensure it is error-free. Requirements: Proven experience in process automation and workflow management. Proficiency in Advance Excel & VBA. If you are interested in this job, please provide examples of your past work and a proposed timeline for completin...

Hello, I work as a corporate in-house events specialist/planner and want to streamline my planning templates. I have several worksheets I use while planning but am looking for a very personalized template(s) for each event and the full planning cycle. This would include sheets for an event summary and agenda, the planning stage; venue evaluations, vendor information, deposits, payments, overall budget, invites, RSVP's; dietary requirements, run of show; speaker/audio-visual information; floorplan, rentals, brainstorming and most importantly an action plan or 'To Do' list with deadlines that are easily identifiable. If possible, it would be great to also have a separate document that combines all action items and deadlines for each event into one automated/localized to...

I have two excel files in my SharePoint i need to match the data from another excel sheet in SharePoint which has pivot table . so i need to match 17 worksheets from that excel data .I want some to fix by using formulas/VBA.

...and sizes, styles. 2. Make the current worksheet in browser A4 size where free text can be written and do the things as mentioned in Point 1 above. May be you can use like Trumbowyg editor (i think it has maths option), or alohaeditororg. 3. Mark each worksheet whether to be notified as Private or Public and show Public Worksheets in site homepage and mark worksheets for any particular class/grade like Class I or II etc. 4. After submitting the worksheets, the replies by students are autoscored based on the number set by worksheet maker. Students can also see correct answer. Students can download worksheet if allowed by teachers. 5. Fix a timer for each worksheet by the worksheet maker. I need full source code, co pyr i g ht and installation in my shared linux ser...

-Split Excel File data in tab "Data" into chunks of 9990 rows. -Map info from 'Data' tab to matching headers in 'Output' tab. -Keep headers in rows 1-6 in Tab "Output" for each file, so data will always start at row 7. -Save each file as "", "", "", ect... in whatever folder location. I can edit output location. -'Output' tab columns A-C are blank. Keep them in each file. -Map info from 'Data' tab to matching headers in 'Output' tab. -Grey 'Optional' columns (H & I) in 'Output' tab will be blank, but populate each output file with them.

Hi I have an Excel spreadsheet that i need customising - The spreadsheet is used for reporting on the health promotion activities/events for an organisation and I want to adapt it for another. Some of the worksheets have formulas and links to off site data sources such as Australian Bureau of Statistics.

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

I have an existing excel file that was developed to download data from different websites and carry out company valuations. Due to changes in two of the websites, the existing VBA code does not work, and needs to be corrected.

The file has 3 modules. Two of them are hidden. The process of hiding is: zip .xlsm, get into xl folder, edit with a hexadecimal editor the file .bin and hide the modules. If you know what i am talking about please tell me