...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. ...
Hi, I am creating an excel userform based tool and would like to hire someone who is proficient in excel, userforms and VBA. This project is expected to last for around 2 months full time(significantly less for a person who has great VBA skills).l I know exactly what is required to be built and have a Proof-of-concept with the code already ready and
...automate an excel file for reporting purpose. Currently I do it manually and bits and pieces of automation which I have recorded macro, it was working fine till I had to do conditional formatting for duplicates and delete column 1 data based on duplicates. I have attached a dummy data file for your reference, when I receive the raw data, it consists
I need an excel vba expert to write a two phase code for me, with the first phase being to import data from two different workbooks based on a userform where a certain value is entered, and the second phase to import data from another workbook based on certain letters that are entered for the value talked about in the first phase
Have written a code for a user form to automatically add information (delivery details) into a database, however code only currently works if all the boxes in the userform are filled, need this corrected so that form will work regardless of whether all the boxes on the form are filled or not.
Need a userform made to allow data to be entered into worksheet. The worksheet already contains dates so the code needs to be able to match the date entered in the userform to that in the worksheet and put in the userform data which corresponds to that date
Hi, I recently started learning VBA and need some help with some code. I have around 16 columns of data, that needs to be filled in with a help of a User Form. I came so far that I have created the userform and can fill out all rows correctly, so I have coe for that. However for some of the columns I would like to have a combobox instead of a textbox
I currently have a userform (triggered by the "Add New" button on Sheet1) that is supposed to autopopulate the data that is typed into the textboxes and listboxes into the next available row in on my Sheet1. Currently, only the listboxes are populating once I press my Submit button. Please help my debug my textboxes, which are name as txt___. I also
...have a VBA userform that reads data from a sheet of over 200,000 entries with over 200 columns per entry. I need to convert this into a website that can be sorted, filtered and searched like in Excel. Also need the ability to import CSV files to add to or merge with the existing data if it already exists. Ability to export refined search data as CSV f...
This is not excel VBA. This is word. should only take 15 minutes. the file contains bugs need it fixed. Please start your proposal with word "NotExcel"
Create new workbook and make a userform which has button to copy updated data form file [login to view URL] to google sheet shared link
I need someone with Excel VBA skills to enter in a Userform to add new employee and Wherein I Enter a Employee Code, to VIEW / EDIT details Then 20+ Details will appear, including a data validation whether a training1 is completed, training2 is completed etc etc Then Auto generate Monthly report
I have already created the userform of the order system. All I want is to add two command buttons and generate a solver which can help the user decide how to purchase from the 3 vendors(called ABC?). Requirement : Utilize Solver function in the model to decide the amount to purchase from 3 [login to view URL] vendor provide all the products, but seperately
By using Visual Basic, create a simple .exe file which creates a pdf file from the selected data in txt file. We have PLC unit which records some of test values in to a txt file. Every record is saved in to same txt file in order. Every record has unique test ID. We need to show that unique test ID’s and related test results in pdf form. The exe
Excel VBA program that takes Combo Box selection and returns a range of rows from an excel worksheet in a userform. The range of rows contain repeating data, so the program must sum repeated data before returning it in the userform. The user will then make selections within that range and those selections are then copied to another tab in the same
Looking to create a userform that pulls data from a column and then allows user to choose corresponding value for the data pulled in. The user selections would then be passed to a table on the worksheet for later use. The userform should change based on the data in column A, for example if there are only 2 unique values in Column A then only two selections
Hi Milan S., I have an excel VBA userform which I have completed about 90% of. Would you be interested in finishing it off for me? It has a very small amount of work which still needs doing - I am just too busy to finalise it. Thank you.
I have an excel VBA userform which I have completed about 90% of. The only things left are some simple command buttons and other very small functions. I now have no time to finalise the form and need someone to finish it off for me. This is an urgent project and will need to be completed within 24 hours. If this project goes well, there will
I want to hire someone for ms excel based order, inventory, and account management which includes userform and good graphis. Also the data get synced with server so autobackp to be created in SQL server. Also can import data easily from server to analyse data.
...columns of data. The names of the headers of the three are different, but the types of data in each are the same. For example, row 1: cr1 and cr2 calls it case number. Tr1 calls it citation number. For my purposes, it doesn't matter and will be combined. File will be names “Mena Mailing Workbook” Sheets needed: NewData; ToMail; All data; Mailed;
I need an excel spreadsheet (must be an excel spreadsheet) that will be used in RMA testing and tracking. Button #1 will be used to enter new RMA devices. (may need to create a new sheet based on certain criteria). Some information will be free text, some will be selected from a drop down list or radial button. Button #2 will be used to update
I have a Workbook with 60 sheets that need a userform created to manage printing of 53 of these sheets, 40 of the 53 sheets have conditional formatting depending on which of the 3 cells have 'X' in them. This is for First Count, Second Count and Final Recount. For first count, cell text is shown. For 2nd and Final recount, cell test is hidden/White
...director calls the managers of the offices and inputs all the data of the sales reps for the previous day into an Excel spreadsheet, 6 days a week. On the sheet are the details of the sales rep/ i.e. office location, names, rep number, what vehicle he has and vehicle registration. The data the director collects includes; How many boxes sold, boxes pulled
I want Userform for data Entry. Requirement - * Date * Time * Auto Populate Button - Means If I select any text in box then other value auto populate in another box. * Check Box Visible and Hide. - Checkbox value depends on combo Box. * Check Box Value reflect in sheet (Cell) when submit the form. * Enter data in Form reflecting on sheet when
I want Userform for data Entry. Requirement - * Date * Time * Auto Populate Button - Means If I select any text in box then other value auto populate in another box. * Check Box Visible and Hide. - Checkbox value depends on combo Box. * Submit * Clear
... Initial values for each parameter are as follows: Parameter Initial Value Inventory 50 Periods 100 b 5 price 10 Salvage Value $1 Create a nicely designed GUI (userform) where the manager can easily change the above inputs. The GUI should start with the above inputs automatically set, but allow the users to change them. Graphs, figures, tables
the thing is the numbers are the grades of each student, Therefore the userform has 4 fields because when the user selects a student in the combo box, field 1 ( should show id of student), field 2( should show the name of student. The other 2 fields are Field 3(average grade of student) and Field 4 ( Final Grade of student). The Calculate button should
...Peer 2 Peer marketplace -showing list of all available services with rates required. 2) Post a specific service requirement.(Userform with exact details to be provided) 3) Service providers are alerted to bid on work.(Userform with exact details to be provided) 4) Credit card based real transactions. 5) Rate service provider. 6) User feedback surveys
...modified. With the attached file, I have it setup where if you type in cells K14:P179, the code looks at the string, and if its longer than 50 characters, that merged cells data gets replaced with "See Addendum 1-1" or whatever inspection section is (2-1, 2-2, etc) and the replaced text is moved to the addendum section B247:Q350 and parsed to multiple
...close userform with msg saying "Name of user added to database not just the column number". Add 'Delete' Function to delete user - confirmation message and close userform. User to search for name, click, details show and then press delete - confirmation message and then delete. Once user updated, confirmation message and close userform (close
I have an excel sheet built out and am in the process of converting the input tab into a user form - i want it to be more client facing and friendly. I have the user form created but need help coding it back to the original sheet
MS access userform data base insert and update comand
...online software which is to be used globally, however it does not takes care on local requirement, so for that I have few excel files that my team updates, however i need to do those data entry by my team in excel2013 under userform (which is programmed) with reports from system to user about pending activity, completed activity, report automation from
We have attached a strategy documentation library that contains about 40 strategies. I would like to add a series of check boxes in the document that correlates to a series of paragraphs. Each check box would be associated with a strategy. If the box is checked, the paragraphs would appear in the document at the designated location. If the box is not checked, the text would not appear to the...
Dear all, I need a developer to help me build a spreadsheet where there will be information input with a user interface (userform format). Afterwards I need the information to be stored in the sheet and that an email is sent to a specific address with the information that was input.