how to search for a particular word in a column and past it in a different
worksheet under a particular header
My datas are like
name-james class-4 section-a roll no-12 interest-reading novel cycling
name-john class-5 section-b roll no-3 interest-football swimming watching tv
all this datas are in one single column..
what i need is a macro to copy my data to different worksheet in a manner
like below
name class section roll no interest john 5 b 3 football swimming watching tv
james 4 a 12 reading novel cycling
can anyone please help???
No comments:
Post a Comment