Please read the Attached PowerPoint. I need this today - $60.00 US. I need to automate the process to upload an excel Template. I want this driven by buttons... from a userform or sim to. The users are not Access intelligent. So need to make this easy for them. I want to upload from a Template, verify the data from the template aligns to the fields
Create a userform to automatically save down a template. Must create 2 lines from 1 entry. only difference is Col J one line must have receive or deliver short, second line receiver or deliver long. receiver or deliver is chosen by the option box. The highlighted cells are the entries that will be filled in. the rest is prefilled including the date
Create a VBA application in Excel to help automate the business or organisational process you have decided to address, which must: 1. Have a graphical user interface within Excel such that a person who is familiar with Excel, but has no knowledge of VBA, can successfully operate your VBA application. 2. Demonstrate the key programming skills expected
I'm building an interactive excel tracker for [log masuk untuk melihat URL] is movement based on day count and selection from Listboxes. Most of the code is done on this workbook, but I am self taught and need some assistance with the more advanced code. 1. Initially I set Column A on the Status tab to equal column A of another sheet. Now, I need Column A on
I would need help creating a Com add in for Visio that would work as a userform where u can fill data. The code would need to be accesable since we will do more changes to it later and add other processes to it. Is this something you could do ? this is only the begining alot more things could be added to this later on
I would need help creating a Com add in for Visio that would work as a userform where u can fill in the data in the attached image. The code would need to be accesable since we will do more changes to it later and add other processes to it. Is this something you could do ? this is only the begining alot more things could be added to this later on
Hi, I have a template file that I will be populating for many companies every year (attached), I'd like to create a tool (possibly Excel or whatever you think is best) that uploads the data from the template sheet into Access and checks for duplicates as it updates. If there are duplicates it should ignore them but continue to upload the non-duplicates
The creator of this file does not include your name or your company name. File coding should be good at the time of running this file, there should not be any problem in this file should be just the name of our company. Company: - Computer World Frist [Removed by Freelancer.com Admin - please see Section 13 of our Terms and Conditions]
I have a word template with multiple locations that are required to be updated, for example, client name, project name, proposal number, etc. We have developed a basic userform with bookmarks, however after filling out the form, it doesn’t allow for any changes. The word document is about 10 pages long, and approx 10 fields required. Need a simple
• Capacidade de captar dados através de um formulário (UserForm), contendo os tópicos: o Dados básicos e histórico social; o Farmacologia atual e sua adesão; o Problemas relacionados a farmacoterapia atual; o Avaliação do tratamento. • Capacidade de armazenar os dados em abas com formato de banco de dados, com, no míni...
...I would also like to use a userform to type in the titelblock informations. Also there should be a button for either starting the script or cancel. I already named the textforms in the AI-file so you should easy access them through the script. Step one The informations in the titelblock need to be filled with a userform. Step two The file will be
...the fields in manually is not an option. I need someone who can use Visual Basic in MS Word to create a document that has a userform in that will pre populate the information that I require. To show you what I mean by userform please watch this video of someone doing something similar. [log masuk untuk melihat URL] Please only apply
I have an already built VBA macro using UserForm. I need to do some cosmetic changes. I need the count of records in the Supply section and it needs to be a link, once clilcked, should display the same in an already existing listbox.
Hi Balint K., I noticed your profile and would like to offer you my project. I have a excel workbook. With a VBA userform data is inputed into a master table. Additionally I also wanted it to copy that input to diferente sheets depending on one criteria (like master table all inputs, then if is about car also copies to car sheet but if is motorbike
I have this worksheet with dates in column B, and name in row 1 and sub headings in row 2. I have set up this userform, so the user can select a name, choose a training and date, then upon enter button the type of training will show on that date. However I am now stuck on how to locate the specific cell with the name selected and locate it to the training
I need someone to create an Excel staff training database. I have been following a tutorial ([log masuk untuk melihat URL]) Please see video for the functionality i am looking for [log masuk untuk melihat URL] I have already created a workbook and a User Form in Visual Basic, but i cant program
I am trying to 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
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
...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 and for some a checkbox.
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
I 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
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 [log masuk untuk melihat 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 [log masuk untuk melihat URL] vendor provide all the products, but seperately
...to the user. User will select one of the ID. According to selected ID, the exe file will find related test values from the text file and will show in the text boxes in the userform and will create a PDF file. ...
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.
...purposes, it doesn't matter and will be combined. File will be names “Mena Mailing Workbook” Sheets needed: NewData; ToMail; All data; Mailed; KeyWords; Stats Userform with 3 buttons. "KeyWords" will contain a list of words or phrases in Column A. These will be entered by me, and added to over time. Do not worry about "Stats" yet.
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
...us on a daily basis. We have 5 offices and every day the 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