Peruttu

Excel automatic splitting into tabs best on first value ofTa

Hi,

I need a way (Script, VBA, something easy to use/basic) in Excel where if I have a list as below, in continuous form…

I can get excel to use first column to split the document into tabs using the first column value?

In the below example, I would get a tab for AFT, AKT, AKV, AMT, ASV, BGT, BIS etc…

Regards

Str

D

C

Season

AFT

E

A

33

AFT

E

B

36

AFT

E

B

41

AFT

E

C

32

AFT

E

C

39

AFT

E

C

40

AFT

E

C

41

AFT

E

C

42

AFT

E

C

43

AFT

E

S

42

AFT

E

S

43

AFT

E

V

38

AFT

E

V

39

AFT

M

C

27

AFT

W

A

36

AFT

W

A

37

AFT

W

A

38

AFT

W

A

39

AFT

W

A

41

AFT

W

A

42

AFT

W

A

43

AFT

W

B

40

AFT

W

B

41

AFT

W

B

43

AFT

W

C

37

AFT

W

C

38

AFT

W

C

39

AFT

W

C

40

AFT

W

C

41

AFT

W

C

42

AFT

W

C

43

AFT

W

S

39

AFT

W

S

40

AFT

W

S

41

AFT

W

S

42

AFT

W

S

43

AFT

W

V

41

AKT

D

K

31

AKT

E

C

36

AKT

E

C

42

AKT

G

G

41

AKT

K

A

41

AKT

K

C

39

AKT

K

C

40

AKT

K

C

41

AKT

K

C

43

AKT

K

J

41

AKT

K

J

43

AKT

K

O

42

AKT

K

O

43

AKT

W

C

41

AKT

W

S

37

AKT

W

V

41

AKV

A

29

AKV

A

41

AKV

K

A

41

AKV

K

C

17

AKV

K

C

30

AKV

K

C

32

AKV

K

C

34

AKV

K

C

35

AKV

K

C

36

AKV

K

C

37

AKV

K

C

38

AKV

K

C

39

AKV

K

C

41

AKV

K

C

42

AKV

K

C

43

AKV

K

J

41

AKV

K

J

42

AKV

K

J

43

AKV

K

O

42

AKV

K

O

43

AKV

K

S

41

AKV

K

S

42

AKV

K

S

43

AKV

W

C

25

AKV

W

C

36

AKV

W

C

41

AKV

W

C

43

AMT

E

C

43

AMT

W

C

43

AMT

W

S

43

ASV

A

ASV

A

29

ASV

A

41

ASV

D

K

36

ASV

E

C

32

ASV

E

C

41

ASV

E

C

43

ASV

P

C

39

ASV

W

B

40

ASV

W

C

27

ASV

W

C

35

ASV

W

C

37

ASV

W

C

40

ASV

W

C

41

ASV

W

C

42

ASV

W

C

43

ASV

W

V

42

BGT

A

29

BGT

E

A

38

BGT

E

A

42

BGT

E

B

39

BGT

E

B

43

BGT

E

C

41

BGT

E

C

42

BGT

E

C

43

BGT

W

A

39

BGT

W

A

40

BGT

W

A

41

BGT

W

A

43

BGT

W

B

38

BGT

W

B

39

BGT

W

B

40

BGT

W

B

41

BGT

W

B

42

BGT

W

B

43

BGT

W

C

40

BGT

W

C

41

BGT

W

C

42

BGT

W

C

43

BGT

W

J

43

BGT

W

S

41

BGT

W

S

42

BGT

W

S

43

BGT

W

V

41

BIS

A

29

BIS

B

A

11

BIS

B

A

28

BIS

B

C

11

BIS

B

C

99

BIS

E

A

29

Taidot: Excel

Näytä lisää: w split, would best, e value, b j's, a. m. best, $50 k, vba excel, vba e, Value, str, P&G, p v, excel w, excel vba script, excel to vba, excel form, bis, b v, excel split, easy tab, excel list example, automatic excel, script vba, example list excel, vba document

Tietoa työnantajasta:
( 0 arvostelua ) Berverly Hills, United States

Projektin tunnus: #477719

10 freelanceria on tarjonnut keskimäärin 68 $ tähän työhön

vivekgarg96

Please see PMB for details

50 $ USD 1 päivässä
(20 arvostelua)
5.2
dataperfect

Hi, Pls refer ur PMB.

30 $ USD 0 päivässä
(4 arvostelua)
3.9
uday1980

Hello sir, I have 10 years of experience in Data Entry, Data Processing and MS-Office. Please check my PMB.

250 $ USD 7 päivässä
(0 arvostelua)
0.0
ExcelNinja

I have over 2 years experience working on Excel-VBA. Please let me know if you would like to get more information/have a look at some of my work

100 $ USD 2 päivässä
(0 arvostelua)
0.0
ExcelinBusiness

Please see PM for further details. Thanks

30 $ USD 1 päivässä
(0 arvostelua)
0.0
mkiruba

Hi, I have very good experience in VBA, Macros, VB Scripts and VSTO.

100 $ USD 2 päivässä
(0 arvostelua)
0.0
ZeusPaez

I'm an Industrial Engineer, I working for The Mexmil Aerospace Company on Enginering and Desing Department, I'm development programs of automation for Boeing, Airbus and Lookhead Martin, we are provider of blanket insu Lisää

30 $ USD 1 päivässä
(0 arvostelua)
0.0
aadiityo

HI, Its a very simple task. Can be done using a small macro in excel. I will do it for $30. I have over 5 years of experience in playing with excel and VBA. Hope to hear from you soon. Thanks Amol

30 $ USD 1 päivässä
(0 arvostelua)
0.0
helenalice

we can do this ASAP.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
chaitanya001

please check your pm.

30 $ USD 1 päivässä
(0 arvostelua)
0.0
IvanPetrov

Dear Sir/Madam i can offer you a solution to your satisfaction if you are interested please contact me via PM. Thank You.

30 $ USD 1 päivässä
(0 arvostelua)
0.0