Hi,
Row 5 can be dynamic, the last column in Row 5 can be different
In Sheet 2, I want to copy A6:B17 then auto fill C6: this is were I am getting into trouble, how can I paste to the last column used, this defined by the last cell used in row 5.
For example, AB5 is the last cell.
I would then want to auto fill C6:AB6
BZ5 is the last cell.
I would then want to auto fill C6:BZ6
Any help appreciated.
Len55
Bookmarks