1. I

    Upon open worksheet select entry in drop down list

    I thought I had enquired about this but after going through my posts & not finding it I assume that I then didn’t. As per title. My drop down list has a blank entry at the the top of the available names to select from. I would like to know how this blank entry can be selected when the...
  2. I

    Macro etc to select entry in drop down list

    Hi, Is it possible for a simple code for which when the worksheet is open the first entry in the drop down list is selected. have a nice day.
  3. S

    Counta inside Vlookup

    I am trying to remember how to do something i had done before. Two separate tabs, lets call them A and B. On Tab A is my summary of everything happening on Tab B. Tab B has columns made up of dates and amounts What I am trying to do is have a certain cell on Tab A that does not move show the...
  4. R

    Using VBA To Open A New Worksheet Containing Existing Data

    Is anybody able to help with the following:- Trying to set up a new customer database using Excel and VBA. Each customer has a database entry (1no excel file per customer)with their details. On each customer entry, I want to have a couple of macro buttons. One to open a job card template and...
  5. T

    List issue move all entries to the top

    I'm not sure where to start with this one in VBA to be honest, If possible I would like to avoid an formula array list and VBA copy/paste which is how I would normaly do it but I'm finding my workbook is getting a bit slow! If I have range A2:A8 Cell A2 entry AA Cell A3 entry BB Cell A4 entry...
  6. A

    Clear history from macro VBA Worksheet

    Hi, I have a worksheet I use that lets me add records by clicking an add button. Worksheet uses macros/VBA. Each new entry id is auto incremented by 1. GG1, GG2 etc I want to start from scratch so the first entry I add will start from GG1. Is there a way of resetting the sheet? I have...
  7. E

    Return Column Header of first entry in range meeting a criteria

    I have been working on this for about a day now, searched everywhere and cannot seem to find a solution I need to return the column header of the earliest entry which meets a particular Phase in column A, i.e. for Phase 3 I would expect formula to return May-19. <b>Excel 2013/2016</b><table...
  8. L

    Excel VBA Macro to Autofill multiple columns to last row

    Hello, I am new to macros and struggling to get a desired range, two adjacent columns (A7,B7), to autofill to the last row of C. Another problem is that I have some data throughout columns A and B and I do not want to overwrite those. So I think I need a loop to get around that? <tbody> Title 1...
  9. H

    Excel Countifs Formula

    Hello Friends, I am using the below formula in my sheet. The problem is that it does not work on a closed workbook. The source workbook needs to be open in order for the formula to work. =COUNTIFS('DATA ENTRY - INLINE.xlsm'!gsm_pc_weight_ref_no,B6,'DATA ENTRY -...
  10. T

    DMin function on an Access 2016 form to find lowest value in multiple controls

    I am very new to Access and I am trying to figure out of I can use the DMin function to return the lowest value found in several text boxes at once. I am building a simple database for tracking stock and option trades. The tracker form will be filled out manually for scalable entries into...
  11. M

    Index/Match question?

    With the following example; APRIL 500 MAY 550 JUNE 700 JULY 800 The above months are text rather than a date entry. In cell E1 I would enter a text month name. I need a formula that sums the data above for all rows starting April, up to the row matching the entry in...
  12. L

    Static time upon data entry

    So, currently I'm using the now() function to pull current time based upon a data entry in another cell. Ex:=IF (a1>1, now()). I need the time to be static instead of volatile however and not update upon new data entry in the sheet. How would I go about writing that in vba to automatically put...
  13. C

    Data Entry Form : VBA Run-time Error '91': Object Variable not set with ws.cells.find function

    Hi All, I'm relatively new to VBA, and by no means a coder, so apologies in advance for any VBA/coding illiteracy in the following. Using an amalgamation of online code and trial and error, I have created (almost) a data entry form that allows me to add entries to a worksheet. The form...
  14. K

    VBA script for capturing all names of objects on a userform for the purpose having the capability to rename them

    WHAT I AM WANTING TO DO: I have a userform that I use for entry purposes. I have a second form that I use for editing the previous entries. The second form (editing form) largely mirrors the entry form, save for a few additional fields that are not present on the entry form. I recently...
  15. K

    Drop down list fills out table for data entry guidelines

    Hello! I hope I have come to the right place. I have been searching for the past several days for a solution to my conundrum and I haven't been able to find anything. The company that I work for is...significantly behind the times in regards to data entry and computer use. I have recently been...
  16. A

    Lable caption base on last entry in column

    Me.Label15.Caption = Format(Sheets("list").Range("H1").Value, "###,##0") Hello I have a userform and Label15 caption shows the H1 cells data at worksheet"list" Is there any way to change that code will look column H and last entry will populate at Label15 always? Thanks
  17. B

    Linked Workbook/Data Connection Issues

    What I have is one Workbook serving as a Data Entry form. That form populates another Workbook that serves as a Database. From that database, I have a third Workbook that I have data connections in back to the database to analyze the data in different ways (Pivot Charts, etc.) The problem I...
  18. A

    VBA Login Form not Working

    Hi, Expert I am new in a Excel. I went to get you expert solution for Excel VBA. I create a Excel Data entry UserForm & Excel LogIn From Option. But I face some Problems, When I open the Excel file then First show log in option But when I cancel the loginform then it show my Data Entry...
  19. A

    Convert multiple XML files in CSV automatically,headers problem with 1 entry xml file

    Hello everybody! Like the title i need to do this task. I found this code on web that fits perfectly with my goal: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family...
  20. C

    Counting number of occurrences of cell with alphanumeric characters in a range

    In F1 I have an alphanumeric entry - ABC123. In range O6:O1005 I have results of a VLOOKUP from another worksheet. Hopefully all those match entry in F1. To verify that using variations of =COUNTIF(O6:O1005,"="&F1) formula, however even when at least one in range O6:O1005 is a match to F1 -...

Some videos you may like

This Week's Hot Topics