LinkBack URL
About LinkBacks
Hi Guys
im new to macro. i have a file here contains data from row a to l
in col H i call this data's as code, my problem is how can i segregate each codes in col H, each code to one worksheet.
kindly see attach file,
thanks
Mark
Hi Guys
im new to macro. i have a file here contains data from row a to l
in col H i call this data's as code, my problem is how can i segregate each codes in col H, each code to one worksheet.
kindly see attach file,
thanks
Mark
Put your cursor in cell H2. Find the sort button on the ribbon. Select it. Sort ascending by column H. If you want to automate this, then turn on the macro recorder before you go through the steps manually. When finished turn off the macro recorder.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
This code is my 4th on this topic(Today's only). It does not create workbooks,but creates sheets on the same book. Please delete(Remove) the result sheet before you run this code.
Please Login or Register to view this content.
Last edited by AB33; 02-08-2013 at 02:56 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks