entry

I want to kniw that how can we prevent double data entry in more than one sheet. If i want to know double name or mob8le no. Is entered twice, i aleays visit next sheet to cinfirm. Plz help

TextBoxes 1, 2, 3 are intended for date of birth entry into a ws. The ws is formatted as Date mm/dd/yy ws.Cells(iRow, 4).Value = Me.TextBox1.Value & Me.TextBox2.Value & Me.TextBox3.Value TextBox entries = 05 12 52 Ws formula bar = 04/26/2040 I can’t figure out a workaround for this issue.

New To Mr Excel. I need to add a formula that will auto enter the date and time any entry is made in the adjacent cell and keep it there regardless of how many times that sheet is accessed. I need it to capture the date and time of the entry and not change. When I use a formula like this...

What i want the formula to do is take the calculated cumulative weight loss in kgs from column F and convert it to Stones and pounds in Column G. It correctly does the conversion BUT until there is an entry in column F. (ie. while column f is blank for future weeks) then it shows #value ! in...

I have a column of data with a range named "SortCol". The data is sorted in ascending order. I can use Find to select a cell with a value I enter into a textbox. However, if the range("SortCol") doesn't have the value from the textbox then an error occurs. What code to select the nearest lower...

good evening, i have to time\date stamp every entry placed in a worksheet. Is there a way to use =now() so when a new entry is done , any previous wont update to the new time\date? MTIA Trevor 3007

Hi Guys I need to ensure that if a combobox has a specific entry, a further txtbox also needs an entry The code I have used for single entries is working fine but I can't get the dual entry to work The codes I use are as below: For the single entry If cmbStatus.Value = "" Then MsgBox...

I have a very basic table (two columns) with thousands of rows. Column A has a label, and column B has an entry. There can be multiple entries (rows) per label, but the number of entries per label will vary. (original table) Label A, Entry 1 Label A, Entry 2 Label B, Entry 1 Label C, Entry 1...

Hi, Please can someone help me? I would like a formula that looks for the word "Azera" in the last entry in column C. If it finds "Azera" then it returns the word "Azera" in the cell I put the formula. If it cannot find "Azera" then it returns "No" and any help would be appreciated. I hope...

Hi Folks - - got a mental block going on.... please... using the "Find & Search" - what is the instruction for "finding next" entry, in a single column which may have several k rows with only a very occasional (numeric) entry? Thank you.

Hi all, I have a data set that contains 1000 rows of similar data with various products. The 10 different products are repeated multiple times for different batches, but in some cases there is a manual entry which I need to erase, but before erasing I must take the value of the manual entry and...

Good Morning, I am trying to reorganize some data at work and I have some questions that I hope should be easy for you guys to answer. How can I auto increment a formula every time there's a new entry? I know that I can drag it down to the bottom, but I would like the formula to add itself...

dear Excel Experts, I have a userform which retrieves the data from the excel database UF_Contracting.REV = Format(Sheets("A").Range("Data_Start").Offset(TargetRaw, 64).Value, "Percent") in the REV textbox user can change it and then changed data are uploaded into the same excel database...

I'm able to group by date and then all the rows are, as expected, grouped by date. What I'd like is that for every row on which data is listed, it also shows the date associated with that entry - is that possible? I can't seem to figure out how to accomplish this. So, for example, I have a bunch...

I would like to enter an entry from the last row of a table that ends at A12. Using the code below is only useful if I use the entire range (A:A). Since I have limited my entries (A3:A12), I would like to check for the last empty row in rows A3:A12 and make my entry. How can I adjust the code...

HI I'm trying to clean up a data base that contains a column with a date and time in the same cell, there is over 6,000 rows and I need to filter them from oldest entry to youngest entry. Some of the entry's were made on the same day at different times and I need these in order. This is how they...

Is it possible to search thru a colum, say "E", and for each matching entry cut the entire row for each entry and paste them to a new tab. So if colum "E" had ten entires with the word "Ball" all ten rows would now be moved to a new tab called "Ball", then the same for "BAT", "Glove" etc for...

Hi everyone, I'm working on a big project on Excel where I will have about 20 users sharing the same file where they will be filling out a form in which everything gets compiled into 1 data base. The big issue I am having now is if for example 2 users have the same file opened and one submits...

Hi Everyone, I am stumped by the following problem, which initially struck me as seemingly straightforward, so I am hoping to get some additional perspectives. If you could help me think through the logic, that would be most helpful, although I would also welcome any formula help as well. I...

Hello folks: I have the following spreadsheet: <tbody> Where Who Time CardNum Building 2 Entry A Smith, Brian 6:52:00 2498 Building 2 Entry A Smith, Brian 8:33:00 2498 Building 2 Entry A Smith, Brian 7:38:00 2498 Building 2 Entry A Doe, John 11:59:00 41880 Building 2 Entry A...