Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet that has 2 colums and 5 rows
lets say it looks like this... banana;10 apple;15 grapes;12 grapes;2 banana;7 I woul like to make a macro that creates a single tab for each different fruit so I would start with the original sheet 1 and after runing the macro I would end up with 4 , the original, plus 1 banana tab, 1 grape tab and 1 apple tap the second part would copy and past the rows that has the fruit in side the specific tab. i thanks in advance for the help |