Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Today() function
I have a worksheet with columns D thru I. In Cell M2 I have the Today()
function. What I need is a formula that will transfer info from columns H and I to columns D and E automatically when date changes tomorrow. Can this be done? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Today() function
This will require VBA code
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "chrisnsmith" wrote in message ... I have a worksheet with columns D thru I. In Cell M2 I have the Today() function. What I need is a formula that will transfer info from columns H and I to columns D and E automatically when date changes tomorrow. Can this be done? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Today() function
I'm not sure what the TODAY() function has to do with it? If you want the
value of H1 in D1 and I1 in E1 just use the following formulas in D1 and E1: =H1 =I1 -- If this helps, please click the Yes button Cheers, Shane Devenshire "chrisnsmith" wrote: I have a worksheet with columns D thru I. In Cell M2 I have the Today() function. What I need is a formula that will transfer info from columns H and I to columns D and E automatically when date changes tomorrow. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Today() and IF Function | Excel Worksheet Functions | |||
I'm using the =today() function but I'm getting ##### | Excel Worksheet Functions | |||
Can you do a function like =TODAY() PLUS 1? | Excel Worksheet Functions | |||
Could anyone help me with (Today function), please? | New Users to Excel | |||
TODAY Function | Excel Worksheet Functions |