I need a excel macro which will open another spreadsheet which has 21 columns and for each row select the data in Column C, I-N and then paste that information into another spreadsheet in particular columns:
*
Spreadsheet 1********* Spreadsheet 2
C************************** A
I*************************** N
J*************************** O
K************************** P
L************************** Q
M************************** R
N************************** S*******
*
On my second spreadsheet I’d like to default ‘/’ in the other columns if the cells in Column A are empty.