Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Automatic Date Insert

I have a "customer info column" column (b) and a "date column" column (a) is there a way that when i put a new customer into column B, that column A would automatically put the days date in which i put the new customer in column B. so b3 would have the new customers name and A3 would automatically have todays date (the day i input new customer) inserted.

so b4=new customer a4=todays date, tomorrow i input another new customer and then b5=new customer a4=tomorrows date and so on down the line.

there is no "right clickinsert date" or anything like that.

View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Automatic The Date To Today's Date When You Open The File
how can you automatic the date to today's date when you open the excel file?


Price Report For 02/25/09

View Replies!   View Related
Prevent Automatic Date Format When Referencing Date Cell
I have been struggling with my Excel 07 Date format. Nearly every time I perform a calculation, enter in a value etc in a spreadsheet my answer is returned as a date. So for example if I enter in a cell: = 5 - 4. I get the answer "1-Jan-1900" instead of 1. I have to manually set the formats to general or number if I want the correct format. The setting seems to be the default one and occurs for all workbooks I open. What can I do to change this.

View Replies!   View Related
Automatic Date In Following Sheets
I have a week in sheet1. For eg.

01/07/07 in A1, 02/07/07 in B1 ....... 07/07/07 in G1.

Now in sheet2 I want to continue 08/07/07 in A1 ..... 14/07/07 in G1 and so on and so forth in following worksheets.

How can I automatically obtain the dates in corresponding columns in the following worksheets?

View Replies!   View Related
Automatic Date Format
When I type a date in, e.g. 01/01/07, the result is 01/01/2007.

01/01/28 => 01/01/2028
01/01/29 => 01/01/2029
01/01/30 => 01/01/1930
01/01/31 => 01/01/1931

Excel resets itself to '1900's' after XX/XX/30. Is there anyway to change this so any year I type will always be '20XX'?

View Replies!   View Related
Automatic Date And Time
I can input the date and time automatically in the worksheet while a enter a number in the 3 column but when ever i enter number in the next cell whole time is changing in all the cell and it showing the same time for every number in the entering and not different time in the columns

View Replies!   View Related
Automatic Date Stamp If A Cell Value Changes
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 Replies!   View Related
Automatic Date Entry In Cell
I have a workbook with several sheets, each of which represents a client. At the bottom of this sheet, I have a call log to record the times that we attempted communication, left a message, etc. Since it's tedious enough as it is, I'd like to save my team 2 seconds and a slight bit of that tedium by having the date an attempt was made automatically recorded in the row where the attempt is entered.

Let's say this all takes place in A47:D47. For example, if I called the client on 7/15/08 and left a message, I would record who was called in B47, the name of the caller (me) in C47, and the result in D47. If possible, I would like to have the date of the attempt (today's date on the given day) entered in A47 upon the entry of information in B47:D47.

View Replies!   View Related
Automatic Week Commence Date
Attached is a sheet I use for my pubs to send me their financial information.

Unfortunately, like most staff - they become lazy and need to be kept in line, but when it comes to money, I need it all to work out exactly.

The sheet seems to almost perfect for what I need now, but for the week commencing date on the bar business sheet.

This is the master date for all the figures inputed so I need the week commencing date to always be correct from a Monday.

At the moment the formula I have in ensures that, but when I open it the following Monday to get the figures the date changes to the following Monday from when the sheet was started. there a Makro that can run that when you open the sheet for the first time it will ask for the week commencing date which will then lock that date or would it be better inserting another sheet called calendar with week numbers and do a lookup function so that a specific week number relates to a specific week commencing?

View Replies!   View Related
Automatic Date: From A Validated List
In Column G I have a Drop down list of dates. In Column H I want to show the month for the dates, as per when they are selected. I tried simple doing in cell H2 "=G2" they changing the format of the cell for just the month. which worked but for the cells in H that haven't had a dates selected yet it brings back January-00 all the way down. I need a way of getting rid of the January-00 but having the cells ready so that wen the date in G is selected the month auto appears in H.

View Replies!   View Related
Automatic Graph Scaling By Date
Look at the attached spreadsheet. It represents the times that the POG (Purchase Order Generator) program takes to run Could you look at producing a graph (easy enough) for the indicated data But then, could you see if you can have an input field in the graph that allows you to enter date then the graph automatically redisplays for that days information only.? And maybe automatic scaling for the graph? This is something I have been meaning to try but don't know what to do.

For Example: Enter a date: 291106

**Then the information of what the user entered will automatically display but in a bar graph form. **How I can search for the information through excel? That will make the user easier to search than to find it manually?

View Replies!   View Related
Automatic Date And Time Upon Saving Workbook
Is there a way to automate the date and time in one cell upon saving? I have seen some posts elsewhere upon this subject, but here is the twist:
this is a shared workbook with each tab allocated for a different person. Each person needs to update their worksheet and have the date and time update upon saving. The date and time would appear in the same cell for each sheet. I am fairly certain that this cannot be done with an Excel formula, so I would appreciate if anybody had any VBA suggestions. (I am just starting to learn VBA

View Replies!   View Related
Automatic Date & Autofill Text
I am making a movie ticket spreadsheet for the employees to use when selling movie tickets. Below are the feilds that I have. Everything is based on the number of tickets sold. So when someone sells 5 tickets I would like the date entered without changing when I update the sheet the day after.

Begin #End #$ Amount# SoldNamePayment AbbreviationDate

Under payment the payment abbreviation we use words like debit, cash, check, etc when selling a ticket. Can you type c in the payment abbreviation field and have it automatically put cash in the same field without using autocorrect?

View Replies!   View Related
Automatic Updates; Concatenating Name Of Day To Date
I have two problems with my PivotTable: 1. My PivotTable consists of a constant number columns and varying number rows, eg.......

The dates (with data) should continue to update as I add new date records to the source datasheet, but they don't. I try the refresh option for the table, but it only updates for the dates that it was designed for. I also have automatic updates set, but so far nothing is working. I have to rebuild the PivotTable each day after I add new data...

2. Second problem are the date labels on the rows. I need to have them include the literal day of the week such as
Thursday 01/01/09
Friday 01/02/09

Another less urgent problem that I would like to solve is that I have included additional percent calculations for the total column that I am having to rebuild each time. Can that be included in the PivotTable as well?

View Replies!   View Related
How To Save With Automatic Filename Plus Today's Date
Is there a way to save a file and have it automatically put today's date in the file name?

Example: original File name = test.xls
desired file name = test072807.xls, or test.072807.xls, or test.07 28 07.xls

So, I open the file, do whatever, and then click save.
When I click save, it does one of the above, given that today is 7 28 07.

View Replies!   View Related
Check Cell Has Date & Insert Current Static Date
I have a user form that when a command button is clicked it enters the data from the from into coloums a,b,c,etc. I have code to do this but I want to add code to add a static date in coloum B based on if coloum A had data entered from the form. I need the date not to change to current date when the file is reopened. I am trying to elimate a date text box in the form. I have a link to the file

View Replies!   View Related
Automatic Current Date Formula Extracts From Specific Cell
formula that can automatically use the current month date to extract information from other cells on my spreadsheet.

For example: This formula should be located in cell C6. Cells D6, F6, H6, J6, L6, N6, P6, R6, T6, V6, X6, and Z6 (these cells correspond to the months of the year, January to December respectively) contain the values I need. The month names are labeled above in row five.

Let's say the current month is March, I need the formula in C6 to automatically know that it is the month of March and to pull the information from cell H6 (which is the March cell). Then when April comes along, it will know that it is April and to only pull the information from cell J6; and so on until the end of the year.

View Replies!   View Related
Automatic Finish Date & Time With Lunch Break And Bank Holidays
I would like a solution for the automatic calculation of the end date and end time for project tasks. I have already spent hours on the issue, thanks for any help on this.

The parameters are:
A1 = Start time 08:00
B1 = End Time 17:00
A2 = break lunch 12:00
B2 = back from lunch 13:00

Task parameters

A5 = start date 01/03/10 (entered manually)
B5 = start time 10:00 (entered manually)
C5 = duration 02:00 (hrs entered manually)
D5 = "end date" >>> (to be calculated exluding breaks and holidays)
E5 = "end time" >>> (to be calculated exluding breaks and holidays)

the next line should be filled in automaitically according to the hours needed and the previous end date & time

A6 = "start date" >>> (after line 5: to be calculated exluding breaks and holidays)
B6 = "start time" (after line 5: to be calculated exluding breaks and holidays)
C6 = duration 14:00 (entered manually)
D6 = "end date" >>> (to be calculated exluding breaks and holidays)
E6 = "end time" >>> (to be calculated exluding breaks and holidays)

and so on for every new line down.

View Replies!   View Related
Insert Date
I'd like to inset a date automatically when ever a cell within a single
column is selected.

View Replies!   View Related
Auto Date Insert
if I add data into C2 then the current date will appear in A2. I also don't want the date to change every time the project is opened.


If I enter $32,500 into C2 - The current date (4-Dec) would appear in A2.

then if I close excel and I open it tomorrow, A2 would still read as 4-Dec, while if I enter $23.52 into C3, the current date (5-Dec) would appear in A3.

- would need to be able to enter multiple entries on one day as well.

View Replies!   View Related
Macro To Insert Date
I am needing a macro that will ask for a month and If I type May. It will put 5/31/07 in H1 and then the same date but the prior year (5/31/06) in H2. It would be a real time save if the macro could also ask if the quarter needs to be updated and if yes, ask"input quarter", if 2 is typed then it puts 2nd in H3.

View Replies!   View Related
Auto Insert A Date
I want a bit of code so that when I insert data into column 'C', it inserts today's date into column 'H' - in the same row. (So when I insert data into C22, the code inserts the date in H22). I want to do it with VBA code rather than an in cell function.

View Replies!   View Related
String If Text Insert Date
I am trying to setup a variable from a dropdown selection box. Basically, If "Completed" is selected in the box, current date is set in the corresponding field.

The formula I have tried is:

I have a variable string setup opposite of what I am going for that works:

So if anything is showing other than assigned the date is input. But have not been able to reverse this for the desired output.

View Replies!   View Related
Auto-insert Date In A Cell
I would like the current date inserted automatically into a blank cell when I click on it. It will always be in the same column, but a different date on each row for that particular entry. I used to use datepicker.xla--loved it, worked great. But now I get an erroe message when I installed and tried to run it on a new pc. Does excel come with a drop-down calendar you can pick a date?

View Replies!   View Related
Insert Date In Cell Via Calendar
Kind of like what they do in airline booking web sites, where you have the option "show calendar" and you select the date from there, to avoid any possible typing mistakes. When you select the cell, a calendar or a date drop-down list should pop-up.

View Replies!   View Related
Static Date Insert - Change When Modified
I have a spreadsheet that has the date in one cell. I want the date to remain static unless I make a change. ie, when I first create the sheet I want a static date to go into this cell. Then I only want this date to change if any changes are made to the workbook (several sheets), I dont want the date to change everytime I open the spreadsheet. It must however update if I make any changes to particular cells on various sheets.

View Replies!   View Related
Insert Blank Rows Where Date In Column D Changes
I have a spreadsheet containing hours logged against a specific project, all of which have a 'Week Beginning' date.

I would like a macro to insert two rows above a change of date (in the D column). How best should this be done?

It's basically a formatting macro I'm after, to group records by 'Week Beginning' date.

I've spotted a few similar requests, but none of them appeared to include the function to check for a change in date, from the cell above.

View Replies!   View Related
Insert User Name In Adjacent Cell To Date
Is there a really easy code which will insert the current users ID into a cell adacent to the one previously completed automatically? For example if a date was entered in A2, then B2 would automatically be completed with the user identity?

View Replies!   View Related
Insert Date In Cell In Each Visible Row
I have a spreadsheet from which i run monthly reports for aother business area. I have filters in row 2 (which is my header row) and what i want to do is filter column CH to show blanks and filter column CE to show non blanks. Then in every visible cell in column CH below the header row (row 2) i want to enter todays date - this is so a record is kept of when each row was detailed in the report. I have tried the code below (which i tried to amend (unsucessfully) from code i got here to clear some cells when i ran another filter for another report).

Sub FilterSheets_Monthly_OFMDFM()
If ActiveWorkbook.ReadOnly = True Then
MsgBox ("This filter must add the date on each row included in this return." & vbLf & vbLf & "It must be run while the workbook status is not Read Only!" & vbLf & vbLf & "Please close this spreadsheet and re-open using the password. Thank you.")
Exit Sub
End If
Dim i As Integer
Dim rng As Range
Application.EnableEvents = False
Application.ScreenUpdating = False........................

View Replies!   View Related
Auto Insert System Date & Time
I am currently using Excel 2007 and I am looking for an easier way to enter the system date and time into a cell. I am aware of the MS-Excel shortcuts but work in an environment where data capturers still often get it wrong.

Is it possible to use a Excel function/button to auto insert the system date and time by clicking on a cell/button or Alternatively use a calendar to do so.

View Replies!   View Related
I Have A List Containing Customer Data.. Can I Insert A Date Automatically?
I have a spreadsheet which I am trying to use to capture customer data. What I want to happen is whenever I enter a new record, the date appears automatically in a Date column ....

View Replies!   View Related
Userform - Insert File's Last Saved Date
if there is an easy way of showing the active file "Last Saved Date" on a Userform and have it show automatically when the Userform is opened? The Scenario is:

I have a "Main" userform screen and I want to have a text line which says, "File last updated on xx/yy/zzzz ". This must show up automatically when the "main" userform is opened.

View Replies!   View Related
Automatically Insert Static Date In Different Columns Of Same Row
I recently found on this site the macro to auto insert a static date in one column when an entry was made in the previous column.

What I have in my spreadsheet and what I would like to be able to do is if I select a particular Order Status from a drop down list, that it auto inserts the date into the respective columns.

Column F contains the various Order Status indicators ie Order Submitted, PO Raised, Delivered, and Invoice Received.
The date columns that I would like populated and which correspond to those status indicators (in order) are Column G, Column I, Column L, and Column K.
So if I pick Order Submitted, the status date should be auto populated in Column G. If I pick PO Raised, the status date should be auto populated in Column I etc.

View Replies!   View Related
Find Date & Copy Row Insert Formulas Only
I have a macro that searches a column for a date and then selects the appropriate date. The next step is to then copy the row and insert a new one below the copied one and paste only the formulas and none of the data. I have tried several iterations but all of the seem to paste the data too.

View Replies!   View Related
Insert Date & Time At Mouse Insertion In TextBox
I need to insert text at the curson position in a text box on a VBA form. I know how to make the button not take the focus; I just need to know how to pass the cursor a timestamp.

View Replies!   View Related
Date Column (insert In The First Column Dates Starting From 01/01/2000 All The Way Up To Today)
I'm trying to create an excel worksheet as follows:

Column1 Column2 Column3 Column4 Column5
Date Time In Time Out Hours Worked Pay

I want to insert in the first column (Column1) dates starting from 01/01/2000 all the way up to today, 11/11/2008. So I would end up with a unique date on each row.
To accomplish this manually would be a daunting task. I'm a newbie to excel and don't know how to use any in-built functions.

View Replies!   View Related
Macro To Insert Date In Cell When Text Is Inserted In Another Cell
I'm trying to write a macro similar to the one found here: here:

Rather then use a textbox, I would like the cell to display the date when text is inserted in the cell to the left.

ie. I insert text (the letter 'a') in cell E11, and the date appears in cell F11.

I would also like the macro to do this for a range of cells ie. for E11 to F21, then from G11 to H21, then from I11 to J21, all the way to column IV.

View Replies!   View Related
Insert Excel Formula Using VBA......MATCH Function Is What I Want To Insert
I can use the MATCH function when i am in excel but i am having trouble getting it to work when i am trying to insert the formula using VBA.

Here is the code i have but it wont even compile........

View Replies!   View Related
Insert Date From Column D, Into Column A, 2 Rows Up
Following up from Insert Blank Rows Where Date In Column D Changes from the first populated row after the inserted rows, and paste it in the 1st blank row above the populated rows (as a kind of title). How would I build this into the code below?

Private Sub CommandButton1_Click()
For x = Range("D65536").End(xlUp).Row To 7 Step -1
If Range("D" & x) <> Range("D" & x - 1) Then Range("D" & x, "D" & x + 3).EntireRow.insert
End Sub

View Replies!   View Related
Automatic Averages
I am inputing each day the total amount of sales. I am manually doing the averages for past 12 weeks on Monday sheet. I would like when I enter the amount for that week that the cells B84, C84, E84, F84 are automatically updated for the past 12 weeks. I have tried a few different approaches but I keep getting #ref or circular reference

View Replies!   View Related
Automatic Sort - Possible?
Is this possible and if so, how do you do it?

For example, a team scores 10 points and moves up three places. Easy to do manually with sort but what about automatically?

View Replies!   View Related
Automatic Filling
Im not even sure I can do this- but- I want to be able to have a few columns, 3 of them I want to be Item #, Item, Cost.

Is there a way to put the Item # (Number) in, then have the other 2 automatically come up?

View Replies!   View Related
Automatic Concatenate
A1 contains "=2+3+4" which shows 8 as a result. I would like to add a word "Lbs" with it so it would display "8 Lbs" on the same cell. If I entered =1+2+3 on cell A6000, it should give me "6 Lbs".

View Replies!   View Related
Automatic Sorting
I have a table which holds scores as well as other data for players. Is it possible to automatically sort a table based on their points score to see who is top of the league?

View Replies!   View Related
Automatic Backup
Im aware of the AutoRecovery, but Im looking for an Autoback (Auto save) itself. Is there one in Excel? ( I'm using 2003)

View Replies!   View Related
Automatic Update ...
I want to the "No. of times taken out" column to automatically update if the status is "Borrowed".

So, say book had been borrowed 13 times, and the Book is borrowed again, I want the "No of times taken out" to change from 13 to 14.

View Replies!   View Related
Automatic Calibration
I have a column with random figures numbering upto 2000 meaning 2000 cells starting from 1 - 2000 and this varies every time I update my sheet....

What is require is that in C5 i should be able to set a max limit of "reference cells", the purpose of this limit is that it would automatically go like a stop watch from 1 until the limit... So for example if I put in 500 in C5 it would reference going up from 1 until 500, I need the highest random figure within those range of cells referenced.

These max results are referenced in a mathematical alogrithm of which the calculated result must match the base level or get as close to it as possible...

View Replies!   View Related
Automatic Rounding
I work with worksheets in excel that usually have dollar amounts with 2 digit formulas. I would like to automatically round all the columns I specify to the nearest whole number. Presently, what I do is to create a new column, and then put in the following: =round(A2,0). Is there a way, I could highlight the whole column and then use the round function for everything at a time?

View Replies!   View Related
Automatic Sort
I have a coloum of data which is currently updating of 4 digit numbers so something like col 1 would be 3423 col 2 would be 6543 and so on and so on. This list will be constantly growning is there a way to constantally sort these into numerical numbers lowest first? The data would be on coloum B the other sort range would be in coloum a.

View Replies!   View Related
Automatic Documenter
Is there an automatic documenter tool in excel, similar to the one in Access, which would list out things like formulae, external references, conditional formatting and macros contained in the workbook? If not in Excel itself is there an add-in available. I am about to have to document over a hundred different, sometimes very complex, workbooks and so an automated way of doing any of the above will be a huge timesaver.

View Replies!   View Related
Automatic Updation Of Cells
I have a cell with two Options - Applicable and Not Applicable. with the help of experts here in this forum I was able to hide the subsequent cells if the user chooses "Not Applicable".

However Now what I looking to do is - If the user chooses "Not Applicable" I want my subsequent cells to automatically change to NO.

Example : My C56 will have two Options - Applicable and Not Applicable

My C57 to C 70 will have a bunch of questions with two options - YES and NO.

If the user chooses "Not Applicable" in C56, I want the cells C57 to C70 automatically change to NO.

View Replies!   View Related
Copyright 2005-08, All rights reserved