Vba|cprogrammingvisualbasicроботи

Project requirements 1) create front-end interface for data entry based upon our specifications 2) drag and drop to add files (and ability to view files within the program) 3) ability to create new folder on desktop, auto rename and save the added files to newly created folder 4) format entered data for user to copy/paste into another excel sheet 5) Generate 3 excel files based upon entered data (data must be appended to template files) 6) Open up outlook, attach the generated 3 excel files in a draft email

I need the excel vba coder for multiple jobs. Details will be discussed

I am looking for someone to help automate a worksheet template that I am using. The attached sheet is an example fo the template I am using. My template uses a simple formula to identify keywords or phrases chosen from a string, and then assign that keyword to the row in which it's found under a column. I then use (replace all) to remove the identified string from a copy of the original string, this is represented in column C or the attached sheet. This string needs to have the identified keywords or phrases removed in the order that they are removed This has to be removed in order since phrases like "for DWV" are not the same as "DWV" and must be identified separately. need the sheet to work as a template where I can paste in new SKU's and descriptions a...

Teach advanced excel skills: Statistical Modeling Forecasting and Prediction Pivot Tables VBA and Macros Vlook up And formulas: Sumif; iferror; conditional formatting;count if ; etc All excel tabs and other functionalities

Hello Barry, Here is the quotation for the Excel Tools in VBA as we discussed. Thanks. Rashed

MS Access project Migration 2010 to MS Access 365/2019 including back end upgrading MS SQL 2014 to 2019 Must be highly skilled in MS Access / VBA / Migrations

Please check the attached file for explaination and better understanding

create macros to work with a huge amount of data and for Excel reports & automate repetitive tasks responsible for creating these macros and ensuring they work as intended developing new features or improving existing ones Maintains current and newly developed m...work with a huge amount of data and for Excel reports & automate repetitive tasks responsible for creating these macros and ensuring they work as intended developing new features or improving existing ones Maintains current and newly developed macro programs per user requirements. Develop VBA Programs to perform task Optimization of processes using Excel Establishment of cross program work flows Reviewing code to ensure best practices are in place TECHNICAL KNOWLEDGE: Strong working knowledge of: o Macro (VBA...

I am looking for someone to work on my Excel spreadsheet, also as attached. It involves doing the tasks as set out in the instructions document attached. I suspect work will be ongoing due to the nature of the job this spreadsheet will be assisting with.

Hi Mamuka B., I noticed your profile and would like to offer you my project. I need help with excel VBA in template

I already have a Quotation Tool developed by me in Excel + VBA creating Quotations and sending PDF quotations to selected e-mail addresses. It is working based on Databases which are updated manually, as from the corporate rules I'm not allowed to Read/Write directly from/to the ERP system. The tool is then constatly updated within users' laptops and the Company Server thanks to .bat file for syncronization. The tool is properly working, and it have been working for more than 5 years. I need an implementation to add some features to the existing system (i.e. main one is that I need to be able to act on multiple customers at the same time). I'm looking for a VBA Excel developer to put hands on the existing system, develop the required features and identify f...

Need VBA developer for small projects, should be from Pune , Maharashtra only

I need a price list creating in excel from the attached PDF price list. There are quite a lot of different parameters so VBA will probably be required. I would like an "input" page where the options are selected that show the retail price. I would like a read/write password protected page where I can input/update the prices in the future.

I need a macro coded so that I can update 20 powerpoint text fields with data I input into excel and so that it saves a new version of the file and a separate new pdf version. Should be a quick file for someone that knows VBA.

I am new here BUT, If you require any of the following for your SPREADSHEET: databases, pivot tables, charts and graphs, dashboards, complicated formulas, interdependent drop-down menus, straightforward VBA & Macros, or any other professional custom spreadsheets, Then look no further...

If you require any of the following for your SPREADSHEET: databases, pivot tables, charts and graphs, dashboards, complicated formulas, interdependent drop-down menus, straightforward VBA & Macros, or any other professional custom spreadsheets, Then look no further...

Buenas noches soy Ing. en Sistemas, con 4 años de experiencia en : creador de web, diseñador web, programador web, Diseño grafico, marketing digital, creacion de logos, branding, flayers, poster, Manejo de excel avanzado , programacion vba , experto en Canva. Experto en Herramaienta Wordpress, Elementor., posicionamiento SEO. manejo de cuentas. Me gustaria poder ayudarlo en su requerimiento si desea contactarse conmigo al privado.

Add if loop in VBA on an existing file

VB.net / Selenium / Database / Excel VBA / Access / Web Scraping Expert Required to build excel vba selenium scraper 2 websites and 1 form filler connected to access database

Hi, I need a power point macro programmed so it automatically updates a powerpoint presentation from an excel sheet. Should be a quick task and will provide full instructions. Please confirm you are strong in powerpoint vba. Many thanks, Benedict

I have a program based in Excel that mail merges a Word document with a list from Excel and mails it from Outlook I am recently getting an error message suggesting the macros have been blocked. I have attached - the Excel program - a modified excel list - a copy of the Word document - the error messages (2) - and the VBA error message - the location of the excel file on my server: MDSERVERPublicGroupEmail and Letter Generation Modules I have adjusted the "trust center" in Excel and the properties of the specific program. Please look and advise. I need it back by today, if possible

Excel developer to create technical forms that will be used to undertake a variety of calibrations comparing sensors to each other and presenting the data for import into reports

1. Rename a worksheet NAME1 to NAME2 2. in Worksheet NAME2 (former NAME1): - add a button LISTA PRODUSE NAME2 below LISTA PRODUSE NAME1 - rename FORMULAR COMANDA NAME1 to FORMULAR COMANDA - remove 2 sections from worksheet 2 2. Rename worksheet Lista Produse to Lista Produse NAME1 3. At lista produse NAME2 worksheet add the 3 buttons from top row (like in Lista produse NAME1 and add the formulas for discount column (like in Lista produse NAME1) 4. Change the functionality of formular comanda to read products from both Lista produse Tece and Lista produse GROSSMAN 5. Change everywhere the logo NAME1 with NAME2 6. At Worksheet3, we have a section Discount partener. Below add a new section Discount partener NAME2 with 4 items: At this point , the discounts should be corelated to price list...

finding people to write excel vba to check the data, it should be fast and simple and all code with comment use all the conditions to check with the data, and calculate the maximum gain, maximum give back, average mark and total mark with graph output all the selected conditions and results to TEST REPORT with TEST ID NO. change to short form or return to normal of the results my budget is USD60

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

I need someone who is a VBA guru for a small task.

I am looking to replace some of the columns of the current program/ .exe file which utilizes VB.NET. I have the new VBA code to replace the indicated columns, but I don't know how to replace the new/replacement column calculations without messing up the current program. I assume that a programmer who is proficient in VBA and VB.NET should be able to put these together (or slightly revise the VBA code) without interfering with the functionality and accuracy of the current .exe file. Please see the overview of the current program in the attached "Current " file. I am also including files and source code of the current program. Source Code for the current program, can be found in the attached zip. Code for the program can be found within that zip file...

Hello, I have several excel sheets in the same excel doc, each sheet has it's own vba macro and they all has the same code, anyway i need them to automatically run every certain time, i have done my search for that topic but none of the simple code i found is working. Could you please help me with that. Thank you, ----------------------------------------- vba code sample. ----------------------------------------- Private Sub Worksheet_SelectionChange(ByVal CountrySize As Range) If <> "$O$5" Then Exit Sub = False Dim ws As Worksheet: Set ws = (7) Dim r, r2 As Range . . . . . . . Call otherMacro End Sub Private Sub otherMacro() = False Dim ws As Worksheet: Set ws = (7) Dim r

I run a tax compliance business that works with individuals with connections to both the US and Canada. These individuals have to file taxes both in Canada and the US. Over 8 years I've developed a spreadsheet to do foreign exchange conversion and tax calculations for stock investment activity. There are certain problems, however, that I've been unable to solve on my own. I am l... Two key problems are: 1) Avoiding circularity with the use of new formulas like filter, scan, etc. 2) Creating a first in, first out approach to security dispositions for the purpose of capital gain calculations. I'm an advanced Excel user, so you should only consider this assignment if you think you are very advanced and can bring advanced solutions (either in formula, data analysis or ...

Hi. Do you have time for a small PowerPoint VBA-project? I need an addin which installs some menu-buttons which do some simple color-changes in PP. I have the code for the color-change to build on. I am busy today, but want to know if u have time next week.

I have a workbook with 3 sheets Electric, Bank, Master and I want to update entries from Bank and electric Automatically to Master sheet as per condition. I have attached here sample data sheet and instruction text file. Any one who is expert in VBA can do this simple task within 4-5 hours.

Create a script that loops through all the stocks for one year and outputs the following information: The ticker symbol - Completed Yearly change from the opening price at the beginning of a given year to the closing price at the end of that year. The percentage change from the opening price at the beginning of a given year to the closing price at the end of that year. The total stock volume of the stock. - Completed Add functionality to your script to return the stock with the "Greatest % increase", "Greatest % decrease", and "Greatest total volume".

VBA Projects needs to be completed on an urgent basis. Majority is completed need to transfer over the automation to an updated file. Need to speak to an expert in VBA, projects needs to be completed on an urgent basis.

Add and change some vba commands in a prepared file 1. When I click the edit button. I want the editor to open for me in a new window 2. Adding an edit button only to the Department command. which will open in a new window and it will be possible to change from Department x to Department y . and update the data in the database 3 . When I mark one of the Employee Ids in the table there will be a button to add/delete a picture When I add a picture to the Employee Id, the picture will appear in the DATABASE and will also be displayed in the picture template

Hi, I have an excel VBA that works on windows and i want it to be revised to work on MAC, very simple and should take couple of minutes for a person who knows their way around VBA for MAC. I've attached the excel file along with the issues i'm getting on mac.

I have a mail file in VbA want to fix the bug

Need to find hourly, daily and monthly averages of data.

I have a design which needs to be converted into a VBA script.

Need to find hourly, daily and monthly averages of data.

we have delimited txt file +- 400 rows by 12 columns (of invoice data) that we need VBA to -fetch and drop into temp tab -parse the rows into format tab ensuring alignments formats etc attached is png of before and after we do this allot and are looking to outsource these. you should budget 6-8 hours to do this well (4 hours will get it done but not tidy) you need to be used to parsing txt files with vba

3 freelancer for Multiple VBA projects: I am looking for VBA expert who can work on any kind of projects and can work as long term. So preferably full time freelancer.

Need an inventory management system where in I need a spreadsheet created using Excel that allows for barcodes and is connected to a scanner. The fields shall be product id, particulars, price, qty, barcode. I need to deduct 1 from qty field each time I scan a particular product. So just the inventory out part here to be captured. Another requirement is for a billing system using excel vba, where in the scanner reads the barcode on the product label and auto enters the product details into the invoice. Then discounts, taxes, and shipping are applied to return the total amount due. Also need the ability to capture mode of payment-- cash, debit, credit, gift card, scrap trade-in. Also, since people may pay using multiple methods (partly in cash and remaining using credit), I need ...

We need help with the following: Excel file will have a field (key) input Your VBA code to create connection to MYSQL Query to be run in MySQL based on Key Output from MySQl query to be sent to Excel This project should be easy for someone who knows it. If you do not have experience, you will struggle. Our DB is on Amazon.

Hi, I have a keywords categorisation task which should be simple and straight forward for someone who knows their way around excel. Basically what i need is, based on the rules in the "Keywords Intent" Sheet i want the column category on "Keywords list" to be filled. I've added the guidance needed within the excel file attached and I'm happy to answer any questions that might arise. Many thanks, Lin

This is the first step of a 3 to 4 step project. Utilizing VBA, create script and single button that with retrieve indicated data from csv file and create a csv file of the results. This project will utilize 2 files. 1) attached "Fractal Study " 2) attached "Fractal Study " file which will be a csv file when produced by the VBA script. Included for the purpose of explanation are two additional files: 1) "Fractal Study " 2) "Fractal Study " 3) "Fractal Study " Please begin by opening the "Fractal Study " file.

I have an excel application with multiple pages that I have personally developed, it has parts of code in VBA. I want to create a web app that has the same functions that I have with excel but adding some enhancements. With various users and levels. Connection to other data sources and export to a CRM; ERP. As there is one possibility to convert my app in a module to be added to a CRM like Dolibar or OODO or any other CRM highly recommended by you. I have uploaded a PDF. It is a real example of my quotations I use for sale me soler energy systems. I've aso added my Excel file. The way I proceed usually is that I import data from the customer. Also when I have it I import electric consumption by months. I have my own price list, with my products, which I add to them. details as ...

I want a minor change in the program that does exclude all lines with qty 0 or empty. See word documentation the field that is in green. That's the only change.

I'm looking for a expert who have a experience of VBA in Excel. - Excel VBA experience - basic understanding of POST and json . - Mouse wheel support for listbox , textbox etc. - Custom Ribbon supporting an unicode 1) Attached contains a description for a project . 2) Please check an attached. 3) Office version : over 2016. 4) only one milestone will be allowed. Best Regards.

Require few modification/ debug in VBA program for successful run