• 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.

Copy/pass values in relation to a date (column) from sheet to another sheet with column of date

Mike259

New Member
I´m new in VBA Excel. I´m trying to make a macro which is not difficult, but I´m so unexperienced. I have sheet1 with column of dates (whole month), for each date there is different value. So column A is full of dates and column B is full of values (in relation with date). Sheet2/column A is also created by dates (whole month). I would like to create a macro, which copy the value from sheet1/column B and pass it to sheet2/column B according to date. In other words, the macro should find certain date (in sheet2/columnA) and pass specific value to sheet2/column B. I would appreciate any input on this. Thanks.
 
Back
Top