VBA, copy data into new sheets. Please can someone help a newbie

[MrRail]

Hi im very new to VBA, my boss has asked me to do something I have very little experience in in a short amount of time

I have a large data set exported from a simulation software which looks like this:

5​

5​

0​

-3.34384​

45000.55​

0.109103​

-3.23011​

45000.2​

0.109103​

0.017424​

33.0513077​

0.0146043​

0.0095028​

5​

11436​

0​

-3.23011​

45000.2​

0.109103​

-3.11638​

44999.86​

0.109103​

0.017424​

33.0534286​

0.014604​

0.0095033​

6​

6​

0​

-2.36637​

45000.1​

0.109103​

-2.74138​

44999.98​

0.109103​

0.017426​

33.029213​

0.01461​

0.0094985​

6​

11437​

0​

-2.74138​

44999.98​

0.109103​

-3.11638​

44999.86​

0.109103​

0.017424​

33.0541​

0.0146039​

0.0095035​

7​

7​

0​

-2.54126​

-0.21678​

0.109103​

-2.45382​

-0.05915​

0.109103​

0.716242​

-75.0360794​

0.1849414​

-0.6919532​

7​

11438​

0​

-2.45382​

-0.05915​

0.109103​

-2.36637​

0.098473​

0.109103​

0.716274​

-75.033905​

0.1849758​

-0.6919768​

8​

8​

0​

0.876733​

-0.18433​

0.109103​

0.955176​

-0.04293​

0.109103​

0.715833​

-75.0765915​

0.1843466​

-0.6916881​

8​

11439​

0​

0.955176​

-0.04293​

0.109103​

1.033619​

0.098473​

0.109103​

0.715866​

-75.0744095​

0.1843817​

-0.6917138​

9​

9​

0​

-2.36637​

0.098473​

0.109103​

-2.36637​

2.462263​

0.109103​

0.716279​

-75.0293961​

0.1850315​

-0.691967​

9​

6354​

0​

-2.36637​

2.462263​

0.109103​

-2.36637​

58.01782​

0.109103​

0.708201​

-75.4935532​

0.1773965​

-0.6856233​

9​

6355​

0​

-2.36637​

502.4622​

0.109103​

-2.36637​

564.9623​

0.109103​

0.57189​

-84.3890305​

0.0559157​

-0.5691503​

I need a code that looks at the first column which is conductor id, and then copies all the columns for the rows that for example into a new sheet.

So for conductor 9, id need all 3 rows moving into the new sheet.

Ill need to repeat this for 10 other conductor ids into new sheets too, can i just add it as another sub below?

Im sorry for the newbie question. THis VBA is really interesting and i cant wait to learn more, Im just very pressed for time

 

[Kerryx]

Pressed for time and its only 10 times , filter column with conductors, copy and Paste (values) to new sheets as needed

 

[MrRail]

Pressed for time and its only 10 times , filter column with conductors, copy and Paste (values) to new sheets as needed

I have to do for 10 conductors for 16 different simulation results.

 

[Kerryx]

VBA Help Needed - Need to modify code to Copy Rows to existing Multiple worksheet based on condition and create new worksheet if one does not exist