Auto Date Stamp With Drop Down List?
Feb 18, 2009
I'm producing a new spreadsheet to track issues and thier completion. I've used the code I have on another spreadsheet, that I got off this site, thanks. What I would like to change are the following:
1) The status column (F) uses a drop down list, located in cells Z1 to Z5.
When an option is selected, the date updates in column G automatically.
What I would like is for the date to only update in column G if the drop
down list is changed to Completed.
2) If the status is changed to completed by mistake, and then changed back
I would like the date to disappear.
Finally, can I make the date columns jump automatically so the person entering the data goes from column F to column H.
View 3 Replies
ADVERTISEMENT
Feb 16, 2008
I am having a very difficult time making this work, if there is anyone who can assist me, I would greatly appreciate the assistance. You can see below what I am trying to do. The entries between the last cells H,3 & K,3 just contain data that is not affected by the rest of the sheet functions.
Cell one (A,3) has a drop down menu for vehicle status.
(B,3) vehicle number
(C,3) Drop down vehicle type.
(D,3) is for dept.
(E,3) Date/Time stamp auto generated from (A,3) entry. (Vehicle Status)
(F,3) is POC.
(G,3) Phone/email.
(H,3) Date & Time stamp out of shop. (This cell will recieve the date & Time Stamp from entry of work done in (K,3)
View 10 Replies
View Related
Oct 30, 2008
I have a task list that requires my staff to initial after said task is complete. I want them to initial column "C" Rows 12 thru 94 with the date auto stamping on column "D", same row numbers. Additionally, initials are also required in column "F" same rows as above and auto date in column "G". Am I wanting the imposible here??? I specifically want this only for rows 12 thru 94 because I do not want the time and date stamp in the "daily back up section."
View 12 Replies
View Related
Jun 28, 2007
How can I add a date stamp that will populate a field when text is entered into another cell but will not change every time I re-open the sheet. I have been using =if(B4="",NOW()) which changes each time though and as soon as text is entered it disappears. I want to capture the actual date that someone enters text into a cell and save that date in another cell???
View 5 Replies
View Related
Nov 3, 2008
I have Excel 2003 installed on the companies computers. Many people use an Excel file and I am trying to make their work easier. There is on command which has a dropdown list made by me. What I would like to find out is that is there any possibility to make Excel help the user to choose from the drop-down list (the list is quite big). Is it possible to select a cell in this column and type in the cell and then Excel help the user. I mean (this list contains country names in abc order) if the user types S and W then Excel auto-corrects it to SWEDEN. Can this be done with Excel 2003?
View 2 Replies
View Related
May 6, 2014
I have a list (C5:C16) and I want people to be able to add more names to the bottom and it add to a dropdown list on another page.
View 6 Replies
View Related
Jun 14, 2009
Is it possible to autosort a drop-down list based on the number of times an item is selected? A drop-down might have 500 lines so it is user-friendly if the top lines are those selected by users the most often.
View 4 Replies
View Related
Nov 8, 2009
is there a way to take a drop down list and pick 1 then have excel fill in the info i seven cell example if list box is 3 then cell 1-7 = 1 and is list box is 1 cell 1=1 cell 2-0 cell 3 = 0 cell 4-7 = 1
View 9 Replies
View Related
Feb 21, 2008
I have developed a spreadsheet that allows a user to "Autocomplete" a name by doubleclicking on a cell and typing in a few letters of the person's name.
I named the range that I want to appear in my list and I created the combobox in sheet 1, not in a userform. My problem is that when I doubleclick on a blue cell in Sheet 1 and type in a few letters of the person's name, the name doesn't fill into the cell. I have already specified a ListFillRange, so the Combobox knows what I am looking for. For some reason, the drop-down list is hard coded and won't populate the name that the combobox has already found. I don't receive any errors from the code that is already in place. If you could help me figure you how to get the names to populate in the blue cells, I would greatly appreciate it.
Attached is an example. If you try doubleclicking and typing in, say "Doe, John" in one of the blue cells in Sheet 1, you will see his name, but when you hit enter it won't populate. The cell stays blank!
View 3 Replies
View Related
Dec 12, 2009
i had a list based on dynamic formula.When ever i update(Add or Delete) New items to my List the drop down list should also be updated and sorted in Alphabetical order(Ascending :Words Starting with A - Z). How do i remove the blanks in the drop down list whenever i delete the data in the Source Data.
View 3 Replies
View Related
Jan 3, 2013
I have A dropdown list (form control combo box) ...in that the values are jan,feb,mar,apr... property of cell link is given as C4..... now my doubt is suppose if i select mar from drop down, in sheet the cell C4 should Show Mar only.....
View 6 Replies
View Related
Aug 12, 2009
I have a large list of data records, 600+, and would like to use List Validation but find EXCEL's default Validation not appropriate for such long lists. What would be perfect is similar to what you get in Access, when you type in part of the record string required, a drop-down list appears and shows you the record entries that have that string within them and not necessarily in character order, quickly wittling down to the few records that apply and then use your arrow keys to move and select the correct record, etc. Example, I own a salon, and many shampoo ranges have many similar products:
Superstar
Superstar Blow Dry Lotion
Superstar Leave In Conditioner
Superstar Shampoo
Superstar Conditioner...........
View 5 Replies
View Related
Sep 22, 2008
I am trying to make a calendar spreadsheet to enable me to track allowance payments i am due from my company.
This payment is worked out by three conditions - where i am working (7 regions), how many days of the week (4,5,6 or7) and how many hours (<7,8-9 or 10-12)
I have made drop down lists to select each of the values for the three conditions and want to show the total for them
i can total the entire spreadheet for the month up using fairly large "COUNTIF" statements, but i want to be able to show what the exact amount is in each cell not just a complete total.
i.e. i am away for 6 days i get £15 extra, if i am in Europe i get another £50 and if i work 12 hours i get £30.
I want to be able to calculate this total in each cell for that day.
I can send a copy of the spreadsheet i have got at the moment if that will make things clearer than what i have tried to explain.
View 12 Replies
View Related
Mar 19, 2009
I'm trying to create a drop down list which returns values based on what has been selected in the previous drop down list in the adjacent cell, e.g. if 'Apples' is selected in the previous cell then you should only be able to select from 'Gala, Granny Smith', or if 'Oranges' is selected you should only be able to select 'Seville, Blood Orange'. Is there a formula which would do this, or can I use a pivot table somehow? I'm totally stumped.
View 2 Replies
View Related
Oct 26, 2009
I need to have a drop down list which displays a different set of values depending upon the value selected by a previous drop down list. ie. (drop down box 1)= x, y, z. (drop down box 2)= either x1, x2, x3, or y1, y2, y3, or z1, z2, z3. I can produce a single drop down box thats not a problem but linking several drop down boxes is beyond me .
View 4 Replies
View Related
Dec 10, 2006
Is there a way to create a drop down list using Data/Validation that will create a list of dates that look ten days back and that look ten days ahead?
View 4 Replies
View Related
Feb 7, 2013
If a1,a21,a41 have a value greater than 0, I wish to stamp cell b1,b21,b41 and so on with todays date, but without the stamped value changing/advancing tomorrow. At the moment cells b1,b21,b41 are copied down as follows. =if(a1>0,TODAY(),"") This works fine, but the date stamp of course changes tomorrow. I can not apply code to the whole b column as cells b2:b20, b22:40 etc have other non-date format data to which the code does not need to apply - the todays date value cell occurs every 20 cells.
View 6 Replies
View Related
Dec 9, 2009
I have a drop down box in column N, however I would like the options in that drop down box to change depending on what appears in column M.
If column M Says "Lapse" then I want one drop down box to appear in column N, If coumn M says "NTU" then I would like column N to show different drop down options.
View 12 Replies
View Related
Aug 7, 2009
I have a spreadsheet (obviously), I want to click a check box and have it date stamp with text, in the next available cell... if you know what i mean! I have attached a screenshot of what i have (the check boxes) and what i need (the writing in blue).
View 7 Replies
View Related
Jan 11, 2007
I would like to take this VBA a step further. What I want to achieve is to date & time stamp a worksheet in cell A1 if any other cell within the sheet is altered. Below is the VBA I used today to enter the info if cell A1 is changed. Can anyone please help with my new target.
Just one more question: When a shared file is used is it possible to also enter the username of the person who's made the alteration.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
' Only look at single cell changes
If Target.Count > 1 Then Exit Sub
' Set Target Range
Set rng = Range("A1")
' Only look at that range
If Intersect(Target, rng) Is Nothing Then Exit Sub
' Action if Condition(s) are met
Target.Offset(, 1) = Format(Date, "d mmm yyyy") & " " & Format(Time, "h:mm") & " Hrs"
End Sub
View 9 Replies
View Related
Jan 12, 2007
I can't figure out how to get a date/time stamp to show when the spreadsheet was last updated.
View 9 Replies
View Related
Jul 11, 2008
I am struggeling to adapt this code to what I need. As is, it simply puts a date stamp into cell AJ2 when anything is changed in A2-AJ2. While this code works great I have been attempting to apply it to the rest of the columns in the work book with out having to list each of the rows and cells in the code.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, [A2:AI2]) Is Nothing Then
[AJ2] = Date
End If
End Sub
(this is obviously the code that runs correctly)
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, [A2:AI2-A10000:AI10000]) Is Nothing Then
[AJ2-AJ10000] = Date
End If
End Sub
(this is one of many unsuccesfull attempts to alter it)
View 9 Replies
View Related
Oct 9, 2008
I found the code below in a previous tread, it works great, but i need some help altering it. I have it set-up when someone puts their initials in column B the time and date inputs in column S. But it also inputs if I hit delete or clear contents when I need to clear the form. Is there a way to make it input the time and date ONLY when letters are entered in column B?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
Application.EnableEvents = False
Target.Offset(0, 17).Value = Now
Application.EnableEvents = True
End If
End Sub
View 9 Replies
View Related
Nov 6, 2008
I've got a sheet with lots of columns. Each time someone makes a change in any row of any one of those columns, I want it to date stamp it in an extra column on the end so we always know who made the last change to each row and when. The actual entering of the data isn't a problem, the problem I'm having is getting it to always put the data stamp in the right column or row.
View 2 Replies
View Related
Feb 16, 2010
I am trying to automatically capture and record the date of a cell's last change in value (date stamp). I have an item price list and if a particular cell gets updated I want to automatically record the date of change of that cell. I realize that after I change cell A1 I could tab to cell B1 and enter Ctrl+; but if I have a hundred new prices to enter I don't want to do that (plus me or the data entry person might forget).....
View 14 Replies
View Related
Mar 19, 2010
I copied the code that was used to inserting the date when the cell next to it was updated, the original post can be found here: [URL]
The Code below will check a range of cells between c3 and c20 and if I make a change to the value in any of them, then the cell to the right of them will have the date inserted. I've had to modify the original code from the other post a little bit to stop an error appearing when I insert a new Row:
[Code] ....
On the first example that was posted it all ran ok until until I attempted to insert a new Row, then it would put the date into about 5 of the cells to the right of where it should do and I received an error message with the usual Debug stuff on it. It would also delete my column descriptions that I had on Row 2.
Would it be possible for it to not auto insert the date on any new blank row that I insert?
What would be the correct range for me to get the code to work on c3:infinity....
Is it also only possible to enable macro's and code like this in the current document instead of every document that you load through excel.
View 8 Replies
View Related
Mar 31, 2014
I want to create a command button on one worksheet so that when I click it a pop up box asks the user for the date and this date is input automatically into a specified cell on another worksheet.
I have got this far - which makes my data input box pop up but now I need adding in code to put that data in a certain cell - for example Cell B1 in worksheet Daily Tasks.
Private Sub CommandButton12_Click()
Dim ans As String
ans = InputBox("Enter date dd/mm/yy", "Data Entry")
End Sub
View 4 Replies
View Related
Oct 27, 2008
Hi All, I want to set up a macro that will input a date stamp for the working day before this one. I have to input the status of dozens of meeting rooms everyday and the checksheets that I work from are from the previous working day (So on a Monday, I want the Macro to enter Friday's date). I wanted to create a quick macro to save myself the hassle of entering the date for every entry and obviously, if I incorporate the TODAY() function it will update every time I open the workbook and give me the wrong date.
I've been checking related threads and can't seem to find either a VB code or a function that'll enable me to do this (I haven't looked particularly hard as I'm at work ).
View 3 Replies
View Related
Oct 27, 2008
Found this macro in a differant thread for a date stamp in A1. I changed it to C38. Also I have it in the workbook module. It is supposed to update the date stamp on save. I think if the data has been changed or not.
View 2 Replies
View Related
Apr 23, 2009
I have the following little piece of code that adds the date to C3 whenever the workbook is saved:
View 2 Replies
View Related
