Vba|cprogrammingvisualbasictrabajos
The project is as follows Move some cells from one row in some columns to the same column one and then delete rows of copied cells. Example Lookup column B value ”6949785206893” (Row #2) Result: column A “6949785206893” (Row #3) Copy Cells of columns E, F, H, P, Q, R, S, T, U, V, W, AU, AV (Row #3) Paste in Cells of columns E, F, H, P, Q, R, S, T, U, V, W, AU, AV (Row #2) Delete an entire row of Result: column A “6949785206893” (Row #3) Continue to next till the end of the sheet (could be up to 40,000 rows) Possible that other sheets need to be created to combine the proper data or to have the lookup values. Also, you may need to add sheets to copy-paste data
Hello freelancers... We are looking for a new freelancers who can help us in any work related to excel VBA macro coding!... We want you to work with us! The difficulty of the work will be intermediate!! So bid only if you can do it! Will pay you according to the work you will do! Will give sample files so that we can understand that how much you are good in that!!!? Selected candidates can face interview too! Thanks!
Hi, I am looking for an experienced freelancer who has excellent knowledge of excel, web scraping and understands soccer fixtures. I currently have a web scraper that is able to fetch the next soccer fixtures with the odds for the home draw and away from beteplorer, I now need an addition web scraper that will fetch additional data for some addition betting markets. The additional...additional data for some addition betting markets. The additional betting markets will include the over/under goal market and the both teams to score market. You will basically use the URLs that will be in a table that you will use to navigate to the appropriate web pages to collect the data. I will send over the excel workbook to the chosen freelancer to add the additional data. This project requires VBA...
Hi Indra P., you may recall you id some VBA work for us a couple of years ago. You changed location and could no longer contract to us. I would like to talk to you about a project. We can discuss any details over chat. I look forward to your call.
Por favor, regístrate o inicia sesión para ver los detalles.
Ein Lieferant bietet uns die Möglichkeit, über eine REST-API Artikel-Informationen abzufragen. In unserer Access-Datenbank haben wir Artikel unseres Lieferanten, für die wir regelmäßig die Verfügbarkeit und den Preis abfragen möchten. Wir benötigen daher eine Funktion, die eine einfache REST-API Abfrage durchführt und das Ergebnis in entsprechende Variablen schreibt. Im Anhang sieht man die Beschreibung des Webservices. Es soll lediglich der API-Aufruf unter Angabe einer Artikelnummer durchgeführt werden und die Rückgabe am besten in die gleichnamigen Variablen geschrieben werden.
I need to fix small error in vba As i want my vba paste with leading zero And not it is not pasting leading zero
Please see the attached spreadsheet and the attached Word document for details of the 4 tasks required. These tasks will need to be completed within 2 days.
fix this function for 5 euros I have several tables that I want to display the data in reports and forms, for that I need a function how Display Public Function ( tablname As String, fieldname As String, fieldvalue As String) As String Select data of table 1 and column 5 if ID = id ___________________________________________________ Public Function Grupp(table As String, field As String, awe As String) As String Set db = CurrentDb strwe = awe strtab = table strSQL = "SELECT CS_An FROM " & strtab & " WHERE " & strfield & " = awe Set rs = (strSQL) Grupp = (0) End Function
I need a function that does the following: Input: x, known_ys, known_xs For example: 0 | 0 3 | 10 5 | 14 6 | 15 and a point X (4.2) Y=10+(4.2-3)*[(14-10)/(5-3)]=12.4 Y=y_1+(x-x_1)*[(y_2-y_1)/(x_2-x_1)] y_1=lower band known Y x_1=lower band known X y_2=upper band known Y x_2=upper band known X x = interpolated point --------------- Include all the instructions for adding the funct... known_ys, known_xs For example: 0 | 0 3 | 10 5 | 14 6 | 15 and a point X (4.2) Y=10+(4.2-3)*[(14-10)/(5-3)]=12.4 Y=y_1+(x-x_1)*[(y_2-y_1)/(x_2-x_1)] y_1=lower band known Y x_1=lower band known X y_2=upper band known Y x_2=upper band known X x = interpolated point --------------- Include all the instructions for adding the function to an excel sheet All code need to have comments for none VBA ...
Hi, I am looking for a excel vba coder Plz Show Interest Asap
excel vba project.. get data from 3rd party data vendor and record price,vol, oi change and calculate things
es soll eine einfache tabelle erstellt werden ohne markos und vba code. Inhalte aus einer Textdatei müssen in Excel sortiert werden nach vorgaben, bestimmt einfach für einen profi aber für mich als laie nicht möglich.
Further Details - I have the first part of VBA working so can send you a s/sheet. However I need to make the data pull from the analysis sheet into the report sheet dependent on a variable category, category being selected from a drop down. The logic to define what needs to be pulled into the report is complete, so I just need to interrogate 4 different columns for 4 different categories in the drop down and if "1" is in that column, write the data into the report. Details. If "Open - Late to Baseline" is selected in Report sheet cell N26, then if a "1" is present in Analysis sheet column AA, then the report needs to pull the relevant data from the Analysis sheet row containing the "1" (as per the the current report - you can see the details i...
Hi Utkarsh S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Hi Nuwan S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Hi, I’m looking for someone who can formulate from many, many variables a way to then populate a required hours for a job to be done. Preferably without Macros/VBA, only formulas as I can generally follow along afterwards and make changes when needed.
write a VBA script for excell so i can generate multiple PDF files and save them with their unique file name. Should be easily, if you know what you do < 10 minutes.
For an MS Access aplication. Improve or re-write the function that merges a Word document with an Acess query.
...activity to date. It has another set of known adjusting entries to create a forecast P&L, Balance Sheet, and Cashflow. A more generic data set lays over the top to create a scenario output. There are a large range of formulae and tables within the workbook which I would say are advanced for an average user, but not advanced for an Excel expert. The workbook currently does not include any macros, VBA, or Power BI, though I am sure it would benefit from all of these. As said, this is an early stage business, so I'm not looking for an Investment Bank level workbook, but I am looking for someone that can take the core of what has already been built, make it more efficient, user friendly, and more accurate. I nice dashboard on the front would be a bonus. I work with a num...
Task 1: Create a deck of cards. a class of objects called Card that has two variables. One called rank of type integer and the other called suit of type string. The possible values for suite are “H” for Hearts, “C” for Clubs, “D” for Diamonds and “S” for Spades. Possible values for rank are integers 1 to 13 with Aces represented by the number 1 and jack, queens, and kings by the numbers 11, 12, and 13 respectively. The Queen of Hearts would be written as the string “H12”. a procedure called createCard that has argument of aCard as Card, aRank as integer, aSuit as string that is passed these three values and returns a card set equal the aRank and aSuit. a dummy procedure called dummy that has no arguments. In that proced...
Hi Gaurav, as per discussion, this project is to create the DISTINCT entries for Operator >> Region >> Sub-Region >> Cluster >> Sub-Cluster from the CLIENT SITE LIST
I need VBA code written to step through a URL (20 times with Page Indicator) and capture the data on the page into an excel file. MUST HAVE EXCEL VBA, AND SELENIUM EXPERIENCE USING CHROME Should be quick 10 minute job for right knowledgeable freelancer.
Hi, I’m looking for someone who can formulate from many, many variables a way to then populate a required resource requirement verse current capacity. Preferably without Macros/VBA, only formulas as I can generally follow along afterwards and make changes when needed.
We have 2-3 issues with one of our Excel VBA Macro's. Issue 1: Upon running the macro with the csv file, it is deducting tempvalue twice from column K on the "Stock Management" sheet. Please see the screen recording below which better explains the issue: You will see it updates "on hand" value in BYOPS4, BYOPS5 and BYOXBX correctly, but it removes the quantity twice from the associated part sku on Stock management sheet. Issue 2: If there is more than one row with the same part SKU in sheet 11 (stock management), it is ignoring the second row upon running the macro. For example, in stock management, for PS5 controllers, there are two entries, one with 179 and the second with 100, so the total is 279 for BYOPS5 > Controllers. After running the macr...
Read the document, and all the things are set intrested can reach me to my number to connect over google meet to discuss and let you have a idea of my process requiremnt and start work
Need VBA Developer with 10+ years experience
Looking for c# winforms vba developer
Hi I am running providing VBA work to variety of clients. Need a right hand man/woman to come on board and take workload from me. Typically I will PM task and scope it to you with tech friendly spec (depending on your understanding). Typical task is 1 I have now to automate a window furnishing quotation system (all in xls + vba). Other is to build a staff picker from a custom scheduling form. You will need a mature understanding of basic business concepts to work with us well in these tasks. You will need good experience in events, adodb, api too. Thanks Mike
I have a multi-tab excel workbook with a summary worksheet containing a row for each TAB with a "Y" / "N" column. I need excel Macro / VBA Code written to enable a button on the master sheet to, when clicked, HIDE all the TABS with a corresponding "N" in the associated row cell value. One column contains the "Worksheet Name" another column contains the "Y / N" condition (There are currently 44 unique module rows / TABS. In addition to the Macro / Code, I will need high level instruction on implementing the solution (I already have the multi-tab workbook with VBA Macros enabled).
Apply only if you can start now Minimum experience 6 years
Experienced VBA required 1. Create dynamic customized buttons using specific shapes 2. Work on graphs / charts 3. Analytics Note - Excel, Macros, VB.net programming
We have an issue with one of our Excel VBA Macro's, which is that upon running, it is deducting values from column K on the "Stock Management" sheet twice. Please see the screen recording below which better explains the issue: You will see it updates "on hand" value in BYOPS4, BYOPS5 and BYOXBX correctly, but it removes the quantity twice from the associated sku on Stock management sheet. I am pretty certain the issue is related to the VBA module 3, as shown here: I have attached the macro and a sample csv file (to run the macro) here.
Experienced VBA required 1. Create dynamic customized buttons using specific shapes 2. Work on graphs / charts 3. Analytics Note - Excel, Macros, VB.net programming
I received automatically Four file csv per day in my local network And I need to execute a program ( you must develop the program) in local automatically when the four files are in the local network to transf...: there are the csv files .there are the files that received automatically. In green the raw data. in the right I make little transformation. The yellow sheets : there are table of parameters. Those sheets dont change. Theses sheet are used to obtain the final table The blue sheet : is the final table that I need to obtain in the end of program some columns are obtain whith a little function vba that you must reproduce in python) In the program to recognize the four files CSV. you must use the name of the columns . The names of the columns are in the first row of th...
Experienced VBA required 1. Create dynamic customized buttons using specific shapes 2. Work on graphs / charts 3. Analytics Note - Excel, Macros, VB.net programming
I am a consultant and I sell MS Word templates to clients. As part of my services, I input the clients' logo and business details into the templates where I have put different placeholders such as their logo in the header, business name in the body of the documents, etc. Desired outcome: Build a MS Excel macro VBA application to replace placeholders in a group of MS Word documents - Ask me about "new client" details such as logo, company name etc etc, - Ask me the theme colour for the documents to match their logo - as per the MS Docs themes and colour schemes. - Then, it changes the variables in the files all in one go. The placeholders such as <logo> or <business name> could be anywhere in the documents such as header, footer, cover page, in the table o...
We have about 2000 individual & separate Excel Files we need to edit/correct certain cells with the same exact steps for all. Basically, about 6 action steps are required. 1. Delete Row 1 & Row 2 completely. 2. Delete Column C & Column D. 3. Then Delete Column E & Column F. 4. And Then Delete Column F again. 5. Copy Rows 1 to 9 from another sheet and paste on the same Row 1 to 9 on the editing sheet. 6. Review & save. EXTRA: This automation should be able to run across multiple Files at the same time as we have a huge number of Files to edit in this way and very limited time. Sample Excel File(s) will be provided for the best-looking bids.
1. it should show already pressed, it should not press twice. 2. if i want to cancel the change then there should be tab to cancel, means balance as previous without change. Give tab Name " Cancel Change". 3. also make sure only colum C is colored Yellow and No fill on that bases is calculation done.
Доброго дня, шукаю відповідальну і досвідчену людину у VBA. Срок - 1 день Дано: - Креслення (зображення) що завантажено в ексель-документ - Стрілочки на зображенні (ексель-форми розміщені поверх зображення) - Таблиця з даними (з номерами стрілочок) - Таблица із згрупованих елементів Треба: 1. Виділити потрібні стрілочки - Знайти у таблиці потрібні номери 2х стрілочок - Знайти по номерам потрібні стрілочки - Відправити непотрібні стрілочки на задній план 2. Створити нову стрілку - Між двома знайденими стрілочками додати нову стрілку (приклад пришлю) - Знайти довжину цієї стрілки - Записати довжину у таблицю 3. Створити скріншот - Навколо знайдених елементів додати рамку (квадрат з прозорим фоном) - Виділити клітинки під квадратом - Скопіювати область і вставити як зображення 4....
I need a KPI tracking application created. I want to in the future integrate API's to make it completely automated. However, for the time being information will be inputed manually. This application will contain formulas, search/filters, extraction buttons etc. I have created a Excel form using VBA which is attached as images, It will be created just like that except the UI/UX will be much more appealing. Thanks
Extension project for the new dataset. Change in formats and column locations.
I need help reproducing the reconciliation manager from this video training and adapting it to reconcile a larger range of balance sheet accounts. Expert in VBA with accounting knowledge.
The existing VBA script pulls data from website Currently it has an issue when the web browser (IE 11) is open I have attached the image of the problem The task is to fix the script Budget: $80
I need a macro and VBA specialist for a quick task.
I myself have a fair bit of idea about excel but dont want to spend time on this and hence need a little help. I have my main sheet where Col A to Col H are filled 1st Part of the project - In another excel worksheet has Col B filled, now the VBA script has to find the Col B (Sheet B) , search the entire workBOOK, if it finds the value, it should copy the first 6/7 values in that row and paste it in sheet B on the cell where the search was initiated. 2nd Part - If the search from 1st part returns no value, then it should put a value starting with OAXXXX (XXXX is a unique no. and it has to search the entire workbook, find the highest value in Col A (entire workbook) add +1 and put it in front of the searched value. I will explain all this in a call [Removed by Freelancer.com]...
Hello, I need help with Excel VBA. There is an Excel Addin Application called IBP Excel Addin and I need to write some VBA code in that context. Need someone that can work with me hand in hand and get the project done in a short amount of time. Need solid experience with Excel VBA and good communication skills. This is not a project that I can simply hand it off to you and you come back after 2-3 days. You first need to understand what the task is and then work with me on this. Because I am discovering and trying to figure out some of this also (please go through the links below to get an idea of the task).
Experienced VBA required 1. Create dynamic customized buttons using specific shapes 2. Work on graphs 3. Analytics
Hello, I need help with Excel VBA. There is an Excel Addin Application called IBP Excel Addin and I need to write some VBA code in that context. Need someone that can work with me hand in hand and get the project done in a short amount of time. Need solid experience with Excel VBA and good communication skills. This is not a project that I can simply hand it off to you and you come back after 2-3 days. You first need to understand what the task is and then work with me on this. Because I am discovering and trying to figure out some of this also (please go through the links below to get an idea of the task). Basically, you will be helping me write VBA code like in the link below Sample coding and getting results
Looking for a excel based or VB project. Project should work on network and should be able to record , update, edit and send notification on completion on task. Email templates will be dynamic or standard. Recording : Record courier numbers : on this selection system will open a text field which will accept alpha numeric or only numeric or only alphabets. Characters added into this field will be added in the database with date of entry and login name 2. Acknowledge : this option will open courier # field. Wherein courier # search will retrieve the data of courier number and some manual fields such as name , application type , email address, phone number , product name addition with fee will be available. With save, cancel and incomplete button. If incomplete button is selected then a te...