Macro to Export Data to New Sheet with tabs

[Closed]
Report
Posts
1
Registration date
Tuesday October 22, 2013
Status
Member
Last seen
October 22, 2013
-
Hello,

I am trying to create a way to export select data from a spreadsheet to a new one and send certain bits of data associated with a number to an individual tab. Basically I would have Column A and B where Col A has groups of numbers from 1-10 and Col B has steps filled with text assocaited with each number. I want the associated steps for group 1 to be sent a the first tab of the new workbook and so forth for each other number

Any help would be appreciated.

Thank You