Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there a way to auto copy cells similar to auto sum?
Hi. I set up a worksheet with the first column for dates, and the 5th column
for invoice numbers. I do not always have an invoice number for certain items so I type the date instead. I am wondering if there is a formula to have exel automatically copy the date in the date column to the invoice column for each row I type so it will eliminate the need to retype the date over and over. Thanks much! joy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there a way to auto copy cells similar to auto sum?
If date is in A2,
Try something like this in E2: =IF(A2,TEXT(A2,"mm/dd/yyy"),"") And copy down as needed. This leaves the cell empty if there's no date in Column A, And if you do enter an invoice number, the cell (formula) will be written over, and not confuse the format by converting the invoice display to a date. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "saki4two" wrote in message ... Hi. I set up a worksheet with the first column for dates, and the 5th column for invoice numbers. I do not always have an invoice number for certain items so I type the date instead. I am wondering if there is a formula to have exel automatically copy the date in the date column to the invoice column for each row I type so it will eliminate the need to retype the date over and over. Thanks much! joy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy a block of cells | Excel Discussion (Misc queries) | |||
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
How to copy block of cells and keep grouping? | Excel Discussion (Misc queries) | |||
reminder notifications in a column | Excel Discussion (Misc queries) |