hi all
i have 2 columns in sheet 2 that i transfer column d and g from
i copy and paste them into columns c and d on sheet 5
i then highlight column c and remove all duplicates
i then cut and paste this into column a ( sheet 5 )
i then do the same with column d
i have this code so far ( macro recorder )
what i need is for the macro to put column d into column a (sheet 5 ) but to put it at the next available cell underneath what i had already copy and pasted from column c
how would i go about this