Another Excel Problem

  • Thread starter Thread starter drinese18
  • Start date Start date
D

drinese18

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Template with Updated Values Each Time 0
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Auto Copy Data from one worksheet to another 1
How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2
Excel Macro to copy a row to another sheet based on date 0
Macro for checking data in a cell against another cell andcopying/pasting data 8
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Excel Monthly Spread sheet. 12

Back
Top