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 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 ...
Need existing workbook sheet edited to count more than one column on another sheet. There are two sheets, one called Weld Log, and the other called Cont log. Each welder is assigned a letter to use. Currently the sheet only has one column for "Welder Stencil" and when added to that weld, it will count two types of welds to that stencil, but sometimes
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.
I have an excel workbook with detailed information including depreciation, loans, capital raise, forecasted operating statement and need to have a Cash Flow Worksheet model added to the projection workbook. Project must be completed by Tuesday December 11 midnight Pacific Time.
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: [log ind for at se URL] Please see attachment which contains all the files you'll need to get started Here is a link to access all the files: [log ind for at se URL] 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
...utilizing my company logo. This cover sheet is for a workbook for salespeople. A standard page size of 8.5 x 11". The salespeople are primarily of the RV, Marine (boats) and motorcycle industries. I would like to have a lifestyle image if possible to really give some life to this cover. The name of the workbook training program is (C.O.S.T.) Customer oriented
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'd like a workbook composed of 5 tabs including a price list, sales order form, quote form and completed orders form. I will need "dropdown" options to be included. I've attached the word documents and PDF I am currently using which I have to manually upload every time.
Project Brief – Excel formulas/linking of workbooks Please note: Project to be completed by 13th December Please look over the project brief and attached workbooks prior to bidding. - Circular formula needs to be added to create date/time stamp. When data is entered in C2 cell, C27 needs to be date/time stamped (on case note worksheet) - support coordination
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.
There is a re-writing of one motivational workbook. Which comprises of 30 Chapters. To start with Chapter 1. It is of 2750 Words. This is going to be a first job for testing the language tone. If first chapter looks ok, then can consider for other chapters too.
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 have attached a workbook with data in one worksheet and email address in the other. Here is what I'm trying to automate using VB: 1. Filter column C by supplier (CA National Serice Pty Ltd) 2. Filter column V for "Ordering" 3. Copy Data from Column F and G 4. Email to the supplier address in "Email Address' tab Then repeat this process for the
...ExcelToWord Add-In requires the Word Template document path to be entered into the Configuration Options. The same applies to the filename and path for the document that is saved as a result of the operation of the add-in. I require the Customise the existing ExcelToWord Add-In to be customised to allow an option for the Word Template document path and
##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
I need someone to add either a formula or a vba (that I can edit later) which will take information from sheet 1 and automatically transfer it to various other sheets. I need it to do this based on the zip code in the address. Example would be 60 different zip codes around me - however, only 13 will go to sheet 1, 27 will go to sheet two 10 will go
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
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 have a workbook that I need OpenPyXL to work with. I have had the library running fine previously but I can't remember what steps I had to take to get it running. The error in my code pointed to the first few lines, when I attempted to copy the original workbook. If I run the below code, the new workbook is completely blank. I need someone to explain