data entry

  1. L

    Transfer of data between two workbooks using name of worksheet?

    Hi all - I'm completely new to using VBA and macros and I amwondering if it can be used to improve a data entry process that is currentlydone manually. Basically, the process is roughly as follows: · Workbook1 o Several Worksheets (A, B, C etc.) o Each Worksheet has data for individual...
  2. S

    number string to time with am/pm

    How do you convert 01241 to 1:24 am - hh:mm 1 for am 2 for pm 01241 (hhmm#) to 1:24 am - hh:mm 1 for am 2 for pm 02452 (hhmm#) to 2:45 pm - hh:mm 1 for am 2 for pm 12142 (hhmm#) to 12:14 pm - hh:mm 1 for am 2 for pm 08451 (hhmm#) to 8:45 am - hh:mm 1 for am 2 for pm I want to have data entry...
  3. V

    Easier way to write this?

    I created an excel template that forces the user to enter data in every other column. What this code is meant to do is "delete" the active row of data and move up the data below it. I have it searching every 40 rows down to see if there is a value in there, if there is not a value then it knows...
  4. V

    "Calculate" in the bottom left

    I have a lot of data in an excel file, and one tab is for data entry only. I want just that sheet to be on calculate manual at all times and have that "Calculate" stay there. Is there any code that will keep that "Calculate" down there? Application.Calculation = xlCaluclationManual does not do it.
  5. D

    List Empty ActiveX Text Boxes

    Hello all, I'm building a worksheet with several ActiveX text boxes for data entry. I'm trying to write code that would prompt the user with a message box listing any text boxes that they have not completed before moving the entries to the spreadsheet. When I run my code, it doesn't return an...
  6. B

    Data Entry - Force Selection

    Hello - I have a user that has a lot of data entry to manually enter. I want the user to be forced to select from roughly 2,000 different answers. I am having a tough time thinking of how to do this so that the user can type a few letters of the data, and have excel show them the various...
  7. W

    HR dashboard with lists of employees

    Hi, I am by no means an expert in MS Excel, but most of the times I can find the solutions myself. Not this time... I want to track all the changes in our headcount:* All the dates employees were hired, which position they were hired for, and which team they belonged to* All the dates...
  8. S

    Year-auto increment number?

    We have an Excel table we use to create work orders. The work order numbers are structured as Fiscal Year - incremental 3 digit number. For example, 2018-001 2018-002 2018-003 etc. Right now the numbers are entered manually in a table column each time a new WO is created. I've had some...
  9. R

    Populating ListBoxes Into Corresponding Excel Sheet Rows

    Hi All, NOTE: Row 1 On UserForm Should Populate In Row 7 In Worksheet "Capital" Row 2 On UserForm Should Populate In Row 8 In Worksheet "Capital" I Have 2 Rows Of ListBoxes & TextBoxes & ComboBoxes. When A User Click On CommandButton1, My Code Populates Data From The UserForm...
  10. A

    VBA Code for Entering Data With Double Clicks

    Hello All: I am trying to build a Survey Form in Excel where I want to simplify the data entry by allowing the user to enter data by double-clicking on cells (or buttons), with some areas for text input. Some questions will have multiple answer options by I want to force only one selection...
  11. H

    how to paste data from horizontal into vertical in excel?

    I copied data from webpage that were presented in horizontal, and I want to paste them in Excel sheet in vertical. I tried (Transpose) but it did not work
  12. C

    How do I add command button to tab order on a worksheet?

    Hi All I'm using cells in a worksheet for data entry (rather than a user form). User enters Name, Make and Price then clicks a command button ("ADD") to add the data to separate worksheet. It would be much quicker if the user could just use Tab key to highlight the command button (then Enter...
  13. X

    Forms

    Hi guys and gals, I want to create a spreadsheet containing cells with fixed characters after every 5 manually entered characters: e.g. xxxxx-xxxxx-xxxxx-xxxxx-xxxxx So basically I want to type all 25 characters but have a "-" after every 5th character. Can anyone possibly assist me in doing this?
  14. M

    Create a master template worksheet that interacts with subsequent data entry sheets

    Hi everyone, Thank you all in advance for your assistance. Background: I work for a construction company and am trying to make a workbook that I can use to track the expenses incurred, deliveries received and revenues produced on a day to day basis. My goals. 1. (1) master work sheet that i...
  15. M

    Data from questionnaire in wrong format to get pivot table

    I issued a questionnaire a few years ago and downloaded responses from the questionnaire provider into an Excel spreadsheet. I did simple analysis, no problem. I have now been asked to provide some pivot tables (crosstabs), eg gender by age. The problem is the data came down in separate columns...
  16. S

    VB Userform Vlookup reference to form data

    Good Morning All, Can anyone provide some help? I have a userform where I want to capture data from drop down. When I submit I want to add the data to spreadsheet with additional information using vlookup based on what is submitted in form. This is what I got so far: erow =...
  17. M

    not sure if it's possible without a macro to move a row from one worksheet to the last row of a table on another worksheet

    As stated I'm trying to move a row from one worksheet to the last row of a table on another worksheet. I'm trying to create a simple data entry sheet. I have an "Input" worksheet that has 4 "entry" rows and "Server" worksheet that has 4 tables in it that correspond with the 4 "entry" rows...
  18. M

    Moving a row from one worksheet to the last row of a table on another worksheet

    As stated I'm trying to move a row from one worksheet to the last row of a table on another worksheet. I'm trying to create a simple data entry sheet. I have an "Input" worksheet that has 4 "entry" rows and "Server" worksheet that has 4 tables in it that correspond with the 4 "entry" rows...
  19. M

    How to make a custom form like the standard Data Entry form but customised?

    I want to make a form which behaves like the standard data entry form but customise the layout. Things I like about the Data Entry form: * the ability to scroll through the data * it displays the data currently in the cells * I can make changes to the data and the change is committed to the...
  20. J

    VBA Workbook Save As TextBox Value

    Good Evening, I'm hoping you can help me with this one. I'm using a userform to aid data entry...I was wondering if it is possible to attach to my button code something that saves the workbook as the value of a textbox, say for example TextBox1 so ... if i wanted to save it as a new file in...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top