Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: repor...
...měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dokumentace, kt...
I would like to hire an Excel Expert to correct a faulty Excel VBA Sub. I want to 1) Transpose a column to a row, 2) Multiply that row times a conforming matrix, and 3)Transpose the result to a column. Attached is an Excel spreadsheet with some data and some defined ranges. It contains a macro triggered by the only button on the spreadsheet. There are
The idea is creating a list of companies and the primary key is the registration number with the ability to amend the list or create a new list. and then to import excel files contain a large list of companies and in case one of the companies were inputted in the before it showed show as red flag. (More like a vlookup table) So, we will have two interfaces
See spreadsheet for more information. the input data could have an indeterminate number of rows. sort by patient, then income category, then date, then item. if a patient does not have a row with 'Initial Visit - Full Time Student' or 'Initial visit - adult' or 'Initial Visit - Pediatric' or 'IV Therapy Initial Consult'associated with their name, delete all ...
We have an excel spreadsheet with invoice information to be emailed to various customers individually or in a batch using the data in the spreadsheet file and formatted as shown in attachment.
Boa tarde, O meu nome é Gil. Estou á procura de alguém que faça um ficheiro excel para controlo de produtos. As funções que gostava que tivesse, são: Tabela de produtos, inserção de produtos na tabela, remoção de produtos na tabela e consulta de produtos através de filtro.
Here is everything you need to understand in the video: [pro zobrazení URL se přihlaste] Please see attachment which contains all the files you'll need to get started Here is a link to access all the files: [pro zobrazení URL se přihlaste] Let me know if you have questions, Thanks, Jai
Excel with 4 different sheets: 1. Summary 2. Timeline 3. Campaign_List 4. Input_data 1. Summary and Timeline should be dynamic selected from the campaign list. See graphs examples and timeline draft. Via buttons the year and month should be chosen and then displayed as graph as well as timeline. 2. The sheet campaign_list is linked via List-function
Need help to convert a xlsm file to an office 365 compatible version. The user may have to copy-paste/ recreate the codes in office 365. Urgent delivery
I need a script that will follow the followers of a list of usernames I provide and not have any duplicates.. also it must shuffle to next instagram account in list and once at the end start over.
All, I am searching for a VBA expert programmer who can build an advanced excel workbook that will track maintenance on a group of equipment. Please only contact me if you have advanced skills and and a critical problem solver. This will be a challenging project and I will be working along with you to complete this project. Thank you
I need an Excel macro that turns two columns into 5-column-wide rows, i.e. columns A and B into columns D to J as in the attached sample. Please send the macro or a video of the solution and I will award you the job and pay you immediately.
Urgent - VBA Mac Not Windows - I need a VBA macro to run on MAC to search a folder and all its subfolders for a combination of files like excel and word files and copy all files found to a new folder. Your code MUST run on MAC.
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
1. Create Input Sheets using the example to be provided 2. Populate the sheets with sample data based on the example to be given 3. Write a macro to import and merge all the input sheets into one 4. Write macro to create other sheets in the master file to analyze the data based on instructions to be provided 5. Create a Gantt Chart based on the data
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
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 Maste...
We have an excel model with macros that converts raw excel product detail data from suppliers to the format we need to upload into our store. We need to fix this model as it appears to have some bugs. For example, in the attached file "Dreamline..." file, the model populates column "A" (parent_sku) with values for SKUs that have no parent SKU (see and
I need to get data from target open sites into a spreadsheet. You need to be able yo use excel vba, python or any of the scraping tools. Contact me so that I send the detail urls. Thanks
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
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 "Commen...
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.
OMO_Import - Potential crash when the time stamp on the import file is not "0:00". Modify the macro to ignore delivery time and only consider delivery date. SENDORDER - Modify the macro to generate an image file whenever the parameter for "Breakdown" is set for Y in the Suppliers worksheet MYOBvsOM - Add a column to sum the totals of price plus gst
...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 format. The format being "Deal Name", "Task & Description", "...
Advanced VBA needed in 24hrs
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