Another Excel Problem
I want to basically update the date fields according to date, I tried putting
the function "=Todaysdate()" within my sheet but when my code tries to copy it, it brings up an error. I want my dates on one sheet to copy from the dates in another sheet on the same workbook, I could record a macro to do so but I know once I do that it is just going to copy the same field over again, I want it to copy the date that comes after the date i previously copied the day before. So basically I would be coming in and then copying a date to that other sheet day by day. Any help would be greatly appreciated, thank you |
Another Excel Problem
Not sure what you are doing, but there is no todaysdate function unless you
have a UDF with that name. Maybe you meant =TODAY() Gord Dibben MS Excel MVP On Fri, 25 Jan 2008 13:35:02 -0800, drinese18 wrote: I want to basically update the date fields according to date, I tried putting the function "=Todaysdate()" within my sheet but when my code tries to copy it, it brings up an error. I want my dates on one sheet to copy from the dates in another sheet on the same workbook, I could record a macro to do so but I know once I do that it is just going to copy the same field over again, I want it to copy the date that comes after the date i previously copied the day before. So basically I would be coming in and then copying a date to that other sheet day by day. Any help would be greatly appreciated, thank you |
All times are GMT +1. The time now is 01:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com