VBA - copy 2 cells frrom one workbook to another in the row of the matching date´s cell

[fblatter]

Good morning!

this is my first post, i found a few answers to my questions the last weeks as i´m doing an internship, where i experienced vba for the first time, so i am a complete beginner and as i am trying hard to get this Code working and it is not really possible, as my skills are very limited, i was hoping that someone could help me out with this.

basically the Code should open another workbook, check in which cell today´s date is matching and then copy two cells from the other workbook to the same cell but in column "B" and "D".

i am not sure if my way of trying is good, the Problem is, that i only know how to paste in the next blank cell, but don´t know how to tell it should paste in the columns "B" and "D" in the matching cells row.

i hope you understand what i mean, thanks a lot in Advance!

Please Login or Register  to view this content.

[davesexcel]

SUre,
try using offset.

Please Login or Register  to view this content.

[fblatter]

thank you very much, this helps me out a lot!