entry

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...

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.

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...

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...

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...

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...

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. Excel...

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...

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 -...

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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 -...