Vba optimizationJobs
Jeg skal have sorteret forskellige studerende på nogle kurser, som de hver især har rangeret. Ikke alle kurser kan have alle de studenter der søger, hvorfor dem med størst præference skal fordeles hertil. Der skal ligeledes udarbejdes en userform, da der er flere dataset at vælge imellem.
I need a programmer. I had an excel file of renters for a residential & commercial building. I prepare this file monthly. It consists from columns with Flat numbers, it’s kind (residential or commercial), renter name and rent And the era paid for rent at its time it is in Hijri calendar from...to... You can get and update all information from last month file to prepare for next month. Af...
as like CRM, complete sales solution from customer entry to dispatch
I have some work, in an Excel spreadsheet. Need a quoting system build in excel, using our data base
I'm looking for someone who can create VBA Word 2016 templates for a law firm, based on our needs as they come about. We have current small access db, that some of our templates pull from, that can be used when needed.
##Advanced VBA skills and high experience automating excel will be needed to understand the code written so far, debug and complete the work according to spec## A VBA programmer has done most of the work according to the attached Statement of Work, however due to personal issues he has not been available in weeks to complete the work. This has been
Customers, Agents, Sales, Inventory, Reports, schedule, time in time out .... and more in excel
Excel Macro VBA - assistance with VLookup in VBA Hello The purpose of the macro is to process each row, and when there is a certain condition, correct the entry in the cell. I am using (attempting to use) VLookup to access the values in the 2nd sheet and correct the values in the first sheet of the workbook. Receiving the following error when running
build a macro which will copy data from one excel workbook to another. for each row in one excel file the macro should create two lines in the other excel workbook. in the column A of the new file CA should be written in the first line and SL in the second one. also in column E should be filled with text "y" as many as rows
I am looking for an Excel VBA programmer. I need to develop a Warehouse Management System in Excel with the help of VBA programming. The task is to setup a Master-Data file (Excel) that should function as a database. I need you to create an excel for every team where they are able to store data in Master-Data and retreive information from the Master-File
Hello, I want to streamline some tasks for my colleagues so I want them to be able to do three things using separate buttons on an Excel sheet. I can do the buttons and attach the macros but writing the macros seems to be beyond me. I need as follows: From one button: Save a template .xlm file as a new file in a specified location with the file name in the format of "some text followe...
I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard format. The format being "Deal Name", "Task & Description", "Key Date", "Organizer", and "Comments"...
I have got a VBA Macro for Ms Excel coded by a VBA Expert. I want some changes in it, need to delete something & add few new contents. It should be a simple project for an expert so lowest bids will win this project.
...need this done soon so please reach out if interested. Thank you-------- -----------------PROJECT DESCRIPTION: I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard
Advanced VBA needed in 24hrs
VBA programming, auto graphing and data sourcing needed
Hello, I have a small Excel VBA project to be completed. Data is not large but needs to just be automated to fill data to a template. Need a good knowledgeable person to help me out. I will send the files later. Need this to be done around this weekend so you need to be available then. Budget -10$. Any bids for excess value will not be considered. Thanks
Hi, if you are an expert with VBA, access and word, this project will be very easy for you. I have a * very small and basic* invoice database with client, invoice and billing tables set up and need some functionality, user interface and reporting added to it: Functionality Each "client" entry has multiple invoices and each invoice has multiple billing
I would like to build a tool that will allow us to better manage our user lists and service Providers. Function: I would like an excel to hold the following data: List of all teams List of all users in those teams List of all service providers contracted with those teams and the budgets Contact details at service providers Email text The above data we need to be manually Changeable and updateab...
We habe a little Rental Management System in Excel. Now we need some VBA funktion to Create a Picking list. what is to do ? 1.) Every device has a button whit his special information in it. So we have to develop a function that will save this information. 2.) we have to put with checkbox selected devices to a picking list on a another sheet
We have a set of tools in excel, that uses VBA, we need to fix and optimize some macros in excel
I have an excel sheet which will keep on adding new worksheets or deleting existing one. The current VBA code, creates a table of content, with the page number for each worksheet. However instead of the page number, I need the first page number of the print preview page for each worksheet. Attached is the excel sheet, and in the cover worksheet, I have
- I need someone to work on my Excel VBA project. - Lots of worksheet referencing, saving as PDF, message box, etc. - The excel spreadsheet attached should list everything that needs to be accomplished. Any other questions can be asked upon confirmation.
1 – Read a file of existing employee IDs 2 – Accept data entry from a user 3 – Write the data to a CSV file Details 1– Read t...including the header row. For the hourly pay, save the data with two decimal places. Deliverables: For each program submit: ➢ Program analysis ➢ Hierarchy chart ➢ A working VBA programs with good internal documentation.
only need to code VBA programming - 2 question on the paper
Helloo, Need to know ablout Excel VBA. Then need to read a TXT file, it is space bettween data, detect when it is an accourt and so forth.
We would like to get a simple macro if you are familiar with VBA in excel. The base is an excel sheet with a few hundred-thousand building addresses. For each address, a link to a pdf exists. In this pdf, on page 1, multiple data need to be read out and put to the corresponding address line. On page two it should be counted how many "apartments" are
...وعملاؤها وحاليا المطلوب تطوير التعامل الشركة به لتحليل المهام الشركة وتحويلها الي الفريق المطلوبلخا منكم: السيفي الخاص بكم باللغة العربية مع احتوائة علي خبراتكم او درجة اتقانكم vba- formula -البحث علي النت -اللغة الانجليزية -هل لديكم اشتراكات مع المنتديات لهذا التخصص الاتعاب المطلوب لكل ساعة عمل h السيرة الذاتية للشركة : ـ أعمالنا : تشمل الخدمات التي
Hi, ignore the budget, i’d like you to give me a quote so I can compare with others. I need you to create a vba programme for me. I import and export products and one of my providers sends me an excel with their pricelist. I need a programme that will remove all the branding (it’s pictures) and will add 10 or 15% to all the prices on the list except
Sample selector is a fraction of another VBA project. Through the sample size table and wizard of this project, the auditor shall set selection criteria and select samples during the compliance test, transaction test, verification of balances and of other disclosures. The auditor selects samples from a set of data (called population) based on the selection
making dashboard, attractive Excel sheet
We would like to get a simple macro if you are familiar with VBA in excel. The base is an excel sheet with a few hundred-thousand building addresses. For each address, a link to a pdf exists. In this pdf, on page 1, multiple data need to be read out and put to the corresponding address line. On page two it should be counted how many "apartments" are
Hi there, Looking to have a freelancer update an Excel document's VBA script to provide better outcome. Attached is file (see 'Master_Contact_List' tab), which combines all sheets into a single page. Hoping to have the below achieved for 'Master_Contact_List' tab: #1 Only use columns A-J from other sheets (not collect entire sheet) #2 Have predefined
I need you to develop a VBA script to convert Excel to JSON files. For every row, it would generate one JSON file.
We pays 100+ individuals for their freelance work every month. Instead of data-entry the 100+ individual bank details, name and amount into the bank portal, we would like to have a script that convert the details from Excel into a CSV format that is ready for bank upload in accordance to attached format.
...will be in Arabic. I created a macro to add a link to Arabic words, but it had to use hex decimal codes. it can be found here: [log ind for at se URL] Please think about the code and test before bidding. I don't want to get stuck with a developer
I need a expert in Solidworks Programming (API) to develop a small application about automate some design operations. more details with freelancer selected...
...file?rq=1 Python Threading: [log ind for at se URL] Python Time functions: [log ind for at se URL] and need some Excel and VBA work i need just simple one hour work for experts, fix rate whole work (2 to 5$ final) sorry for advance milestone or payment , payment after the approval of work by client
Hi Vba A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I need a SQL program to be executed from Microsoft access. I will need to print information on PDF and TIF files on header/footer - left, mid, left side in up to 250 character each. We have a program today (see attached), but only working in TIF and in a only one line.
double check excel files for missing data or errors Hello, i have some excel files i need checked, so i would imagine a skilled vba coder could do this very easily. files to check the following will be highlighted in report 1/. check missing data 2/. check for blanks or duplicates 3/. check for missing dates and missing data 4/. check for out of
Proyecto de desarrollo requiere programador en Access VBA con experiencia comprobada (Prueba online inicial básica requerida, por lo que se establece Micro Proyecto (10-30 USD) para dicha prueba) Los aspirantes recibirán el pago de su prueba y se seleccionarán a los mayores puntuados para un small project (Creación de interfases individuales) que luego
I need some help with API connectivity in Excel VBA to 3 cryptocurrency exchanges The following functionality needs to be created: 1. Get live price data (bid, ask, sizes of bid and ask) for selected crypto currencies - including depth of the market 2. Live price data collection and archivation. 3. Ability to access archived data. 4. Get cash
We buy/sell/repair tank containers. I am automating the records system and need help with form design and reports and general Access/VBA skills from a reasonably local person. Look [log ind for at se URL]
Need to add macros and VBA functions to an existing excel worksheet
I need you to fill in a spreadsheet with data. Need to write a VBA to populate the data from Text file to Access Database
Working on a number of VBA tool projects for my startup business over the past year. Realizing as I go that what I think I need the tools to do changes the more the business develops, and therefore I can't really hand anything off to someone to develop on their own. It would be worth it for me to have someone I can consult with to assist me. Much
I am an expert in VBA Excel automation. I have done many projects including Live Stock market analysis, Data formatting, Outlook Automation and many more. Please check my YouTube link. [log ind for at se URL]
I need someone to add Business Application Header and Business File Header to existing xml file. The code to create XML report is in Access database attachment. I need someone to add code for creating Business Application Header, Business File, and all declarations exactly as shown in samples. Description and samplevs are are provided in word and pdf documents.
