data entry

Hi :) I am making a to-do list and I want to, when adding a new task, have the column move one cell down and put the task on top of column. That means I want the new tasks to be on top so i dont have to scroll down all the previous tasks to add a new one. Is that possible? I know it is a bit...

I'm looking for help transferring data from a PDF to Excel (the PDF link will be at the bottom of this post). Specifically, I need to get addresses from this document, so, three lines of text into four different cells. I don't need to include the state, but I do need to separate city and...

Hey all, First thanks in advance for all the help SHORT VERESION: I've created (from contextures "partsdata" http://www.contextures.com/xlForm02.html) my own form which has a data entry sheet which I need to add a quantity to (EXCEL LOCATED THERE...

I have a workbook with 3 sheets. Each keeps track of entries however certain cells contain formulas (Vlookup, IF, etc.) that reference both cells on the current sheet and cells in another sheet. Since I wanted to make sure I could sort and find entries based on data types within each sheet, each...

Hello, Fairly new to Excel/VBA stuff, so forgive me if I've made a stupid mistake somewhere. I have a spreadsheet formatted like a calendar, and have some simple ActiveX buttons on the right. When one of these buttons are clicked, it runs the following macro on the currently selected cell...

I have a table (tblEmployees) with the following fields: Location (Data already entered) Employee (Data already entered) Height (Need to update) Weight (Need to update) Haircolor (Need to update) How do I create a form that will let me select the location in a combobox and then show me only the...

Hi All, I am currently producing a work number tracking spreadsheet for the people I work with and wanted to know if there was a way to generate a pop up window that created fields to enter the data for the job being inputted. I currently have it just a simple macro (below) that enters a new...

I have a custom data entry form defined in one spreadsheet that I would like to have populate another spreadsheet that is in a typical database format. The data in the custom data entry form uses data validation to control what the user can select for some of the fields. So the built-in data...

I have the code below which captures my data onto a the sheet, and works fine when there is already data in the spreadsheet; Private Sub btn_Add_Click() Dim ws As Worksheet Set ws = ActiveSheet ' change for the worksheet you want data to go to Set rngNext = ws.Range("A" &...

Hi guys, I've been looking around for ages but can't seem to find anything similar to what I'm looking for. I have a spreadsheet with a list of peoples names running down column A starting at A15 to A90 (The range will grow and shrink) A14 is labelled name. b14 is option 1, c 14 option 2 etc...

Hi Guys, Hope you can help with this one, have been struggling for weeks. I have a userform, UserForm1, which lives in a spreadsheet called 'Data Entry.xls' There is nothing else on the spreadsheet itself, it's just for the use of a userform. I would like the user to populate textboxs in...

Hi, I have a range B1:B20. These cells are populated by the user and I want to ensure that no two entries are the same. Is there a way of presenting a dialog box that prompts the user to enter a different value if the value they are trying to enter is already entered somewhere in the range...

Hello all, Good morning, I have Sheet1 where I have all expenses/payments, say Fuel, Food,Stores etc. I have other sheets named i.e. Labor, Food, Stores, Domestic, Health etc. The moment I enter some payment to hospital and select option1 (drop-down data validation), it should go to Health...

Hello, Good Afternoon, I have Sheet1 where I have all expenses/payments, say Fuel, Food,Stores etc. I have other sheets named i.e. Labor, Food, Stores, Domestic, Health etc. The moment I enter some payment to hospital and select option1 (drop-down data validation), it should go to Health...

Is the an easy way (ie, No VBA) that can have a form (similar to this one http://www.sfu.ca/biology/forms/trclaimNonEmployeesOnly.xls) and then extract the input data to a regular table look spreadsheet with the column heads at the top that match the form, Name, Hotel costs, Date, etc? Thanks...

Hi everyone... I have created a simple userform that is linked to a button on sheet1. When the data in the userform is submitted, I set it up so it goes into a database under sheet2. The problem is, I don't want anyone modifying the entries in the database. Usually I would protect the sheet...

Hello, My first post, forgive me if I'm not following posting ettique/rule 100%. I have VBA code which allows me to enter data from Sheet1 to Sheet2 on the same Workbook. I need help to change the code which will allow me to enter data from Sheet1 in Workbook1 to Sheet1 in Workbook2...

Hi everyone, I'm making a data entry form for a user, and one of the fields is in a time format (mm:ss). Is there any way that I can validate that field in "cmdOK_Click()" so that when the user clicks "ok" on the data entry form, if they haven't entered a date a msgbox comes up. I tried...

I am attempting to creat a customer complaint log for work. I would like to use a search type function on a different sheet to search for the customers in the log but need to be able to return multiple results in the case that there are partial matches or similar names. Also, with in doing...

Hi, Im Scott and im working on my A2 level ICT coursework, making an excel document. Ive created a User Form to enter data and everything has worked well except the code means the data is entered in the next column with nothing in. However i need the data to be entered in e.g. B6-B60 but data...