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, vba e, value, str, p v, excel w, excel vba script, excel form, bis, b v, excel split, easy tab, excel list example, automatic excel, script vba, example list excel, excel vba split, vba form, example excel list, column excel, automatic script, tabs, basic excel

About the Employer:
( 0 reviews ) 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