Hi guys,
I was wondering if you could help me out with developing a macro code that enables to copy the range of cells (B207:AB207), find the first blank cell in Column B in another workbook, and then, paste values only into the range starting form the identified cell (B..:AB..). Ideally, I would like to copy just the non-blank cells from the initial range but I won't be too fussy if it's not possible at this stage.
Thanks a lot for your help.
Bookmarks