Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re-formatting
Hi, Have 2 columns with 250 rows. Each value in A has a B value. There are 15 different B values. I need to write a Macro which will create another worksheet, headings for each B value will all the associated A values underneath. Below is a sample, many thanks How do I get from A B 1 a 2 b 3 a 4 a 5 b 6 b 7 a 8 a 9 c 10 c ......... ..... TO: a 1 3 4 7 8 b 2 5 6 c 9 10 -- T De Villiers ------------------------------------------------------------------------ T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479 View this thread: http://www.excelforum.com/showthread...hreadid=530558 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
condionally formatting based on another cells formatting? | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |