• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to copy a value automatically from one cell to another cell which is next to current date

srihas

New Member
can someone please let me know the code for below requirement

In sheet1 cell A1 I will enter todays date using formula =today() and in B1 a value, A1 and B1 change daily because of day change ; on same sheet on column C are dates(every day of the current month) and column B is empty. I would like a macro to search on column C for today's date C and copy the value from B1 to column D next to the today's date.

Please find attached xlsm file which has the requirement

Please help
 

Attachments

  • copy data.xlsm
    12.9 KB · Views: 4
Hi Bellake... its works flawlesslly....thanks a ton for the solution.. :)
 
Last edited by a moderator:
Back
Top