Samuel Yiau 0 Newbie Poster

HI All,

I am new to VBA and I got a very simple question: I have a column of data and some of them are useless, I only need the data of cell 1,3,6,9,12 and so on....and the rest of cell need to be deleted and shifted up so that the outlook will look like: data of cell of 1,3,6,9,12 etc... are in order >>>>1,2,3,4,5 etc....

Can someone please help, Many Many thanks!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.