Dear all
i have the following code
which basically puts the value of Column "AN" into Column "C" of another sheet..Range("C" & Rw).Value = Wks.Range("AN" & i).Value
I would like to also put values of Column "L" of the same sheet in "C" with the pipe | symbol separating those two values.
Can you help ?
Bookmarks