I am very new to the whole concept of VBA and am having trouble figuring how to copy the contents of three cells and having these contents pasted into three cells in a column. I want a macro that copies the same three cells (B5, B10, B16) and pastes them in E1:E3 the first time it runs, F1:F3 the second time, G1:G3 the third time and so on. I suspect the VBA code will have to include something where it specifies that the values of the three cells need to be pasted in the next available column. I do not have any code so far.