Hi All
I've searched all day, but I cannot find answer (or I'm too lame to understand). I want to copy values from column from one sheet ('New week'!B) to column 'Week'!XX. Range 'Week'!XX has to be dynamic and should read column name from cell 'New week"!N18 (values in cell DI, AZ - outcome 'Week'!DI, 'Week'!AZ etc.).
I'll appreciate yours help.
Non dynamic code
I've searched all day, but I cannot find answer (or I'm too lame to understand). I want to copy values from column from one sheet ('New week'!B) to column 'Week'!XX. Range 'Week'!XX has to be dynamic and should read column name from cell 'New week"!N18 (values in cell DI, AZ - outcome 'Week'!DI, 'Week'!AZ etc.).
I'll appreciate yours help.
Non dynamic code
VBA Code:
Sub CopyWeek()
Dim j
j = 5
Do Until Range("'New week'!A" & j) = ""
Range("'Week'!DI" & j) = Range("'New week'!B" & j)
j = j + 1
Loop
End Sub