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?

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?

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?