VBA, short for Visual Basic for Applications, is the programming language of Excel, as well as other Microsoft Office applications. It allows users to write functions or commands in a spreadsheet, with the aim of automating certain aspects of Excel. Other uses of Excel VBA is the creation of custom commands, developing add-ons, and making user-defined functions.На основании 73,648 отзывов клиентов, рейтинг Excel VBA Developers составляет 4.9 из 5 звездочек.
Нанять Excel VBA Developers
Preciso melhorar uma planilha para acompanhar minha vendas e entradas de caixa. Meus serviços são customizados, logo minha remuneração varia de fornecedor e negociação com cada cliente. Preciso acompanhar os pagamento de cada fornecedor, a forma de pagamento a receber varia de fornecedor para fornecedor.
Hi, I'd like the attached file to look awesome and very user friendly. With tropical colours and graphics Allow users to add / delete day columns Icons move easily with "click and drag" Have dropdown menus Dropdown menu to look great graphically Dropdown menu to have hyperlinks to each option Be easily editable by admin When "icons" are moved the original stays and is protected Option to link with calendars with reminders ? Option to share planner with family and friends To be mobile friendly Thanks Phil
I want to have a dashboard framework that I can use to supplement the report forms I send to my clients. Each client (a school district in California) uses our online survey forms (built-in ) to collect feedback data from every professional learning session offered (usually 1-hour trainings or a series of training sessions on how to teach). Some clients offer 10 sessions a year, and others can offer nearly 100, depending on what their goals and needs are. Each client has their own survey built to use in each session repeatedly throughout the year. The survey questions consist of 4pt. Likert Scale questions (4=Strongly Agree, 3=Moderately Agree, 2=Slightly Agree, 1=Do Not Agree) or 6pt. balanced scale questions (+3=Strongly Agree, +2=Moderately Agree, +1=Slightly Agree, -1=Slightly Disa...
Hi, I'd like the attached file to look awesome and very user friendly. With tropical colours and graphics Allow users to add columns Icons move easily with "click and drag" Have dropdown menus Be easily editable by admin When "icons" are moved the original stays and is protected Option to link with calendars with reminders ? Option to share planner with family and friends To be mobile friendly Thanks Phil
Need Python based exe development which can handle an excel file to copy trades from one master account to many other accounts. I will help how you can setup whole this project so new people are welcomed Please refer below link for more insight. What I need exactly is how you can connect Angel Broking Smart API to Excel using Python, use these reference links For Creating a single .Exe (application) use these reference links
I would like to create an employee staffing file (excel or open to recommendation) that can tell me where to staff each employee based on the following: Background on job employees are working: - employees work 4 days a week with 3 days off using the following shift schedules. Employee ID and shift schedule will be given but schedule days working or not working should change based on employee shift code below (DA, DL DC, etc) Shift codes 1. DA - Sunday to Wednesday 2. DL - Saturday to Tuesday 3. DN - Thursday to Sunday 4. DC - Monday, Tuesday, Thursday, Friday 5. DB - Wednesday to Saturday Requirement for file or sheet: -badge ID# of employees (up to 100 employees). All employees will be scanned and IDs will auto populate in a sheet. That sheet will be used for employees present th...
based on the share type filter I need the total count of green, red, and yellow for each share type which is in the excel for each day
Trying to put together a sort of expert system that given a list of parameters (deal type, sub-type, location, etc. - about 10 parameters) will produce a set of checks to be completed. For example for a less complex deal the checks are Check #1, Check #2, Check #8 but for a more complex deal the list will be Check #1,2,3,4,5,9,12,25,..... Ideally would like to have the interface in Excel but open to any other solution Ideally looking for a person with experience setting up a rules engine in Excel or connecting with an existing one that can be leveraged for this project. Many thanks
Hello, I have a product list that has many images that are just not useable due to their image size. I have a google sheet setup with all the products that I would like to verify their image size url, and if the image url is less then 800px, I want to highlight the field. Also I want one clean result generated of products but without the additional bad images includes, so I can reupload the list and overwrite the products so we remove any bad images. i see its possible, so just need someone who can help me
We are a recruitment agency in the UK Our sales people earn commission at the end of the month which is based on the value of fees they have had invoiced and paid The amount that is paid depends on if they have covered their "monthly cost" (which is different for each recruiter) and how much they have billed in that quarter. We have both a monthly and quarterly bonus scheme We record all sales in a spreadsheet including when the invoice has been paid (which has macros) - "placements sheet" We are looking for the new "commission sheet" to pull the data from the "placements sheet" when an invoice has been paid to show what each consultant is due to be paid commission each month and at the end of each quarter any quarterly bonuses also due. Minimising...
We are sellers on Amazon Marketplace. We are getting excel sheets from their portal. We want those excel files to be directly entered in our tally software with the help of VBA and TDL.
I am looking to build a closing cost scenario page which will consist of different rows of data. Working with numerous lenders, I would need fees for each lender kept in the background. When we click the lenders name, it would display the associated fees in the spreadsheet. Totals would be calculated. It would also need the ability to click "Add comparison" and bring the info over from the first calc to the next column where different mortgage amounts, rates, closing costs could be displayed to compare. There would need to be the ability to have this comparison row duplicated multiple times. API could be used to bring over info from the application into the worksheet so redendent retyping on info would not need to be done. Examples attached
4 years ago we had a project here, with a question to create an image from values in Excel to draw a dormer. 4 years ago, this project is deliverd and everything worked great. But now, for some reason, the excel file crashes or will not draw the image correctly. What i am looking for is a better solution or a expert to take a look at the code to troubleshoot.