Hi Guys,
I want to copy the cells in column B from the first worksheet, to the column B from the second worksheet, but i want them to match the date that is on column A. For example, I want to copy the value on column B from the first worksheet that is in the same row as the date 07-08-2016, to the cell in column B from the second worksheet that is in the same row as the date 07-08-2017. I know i can do it manually but I will have to this more than 1000 times, so I would appreciate your help.Can you help me?
Thanks
http://www.excelguru.ca/forums/showt...n-the-same-row
Bookmarks