Tamamlanmış

Excel VBA sort date in one column to multiple

Let's say a have a single column in excel which has headers and number. Example:

*Column A*

John

23

4

Peter

54

34

22

12

8

Mark

11

9

8

I need a code that will organize this data into multiple columns where the name appears on top and the respective numbers below. It'll always be names and numbers so the code should recognize the letters and move this along with the corresponding numbers underneath to a new column. Then repeat and do the same with the other names and numbers each time moving the to a new column.

**Column B*

John

23

4

*Column C*

Peter

54

34

22

12

8

*Column D*

Mark

11

9

8

Beceriler: Veri İşleme, Excel, Yazılım Mimarisi, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: how to create a sort macro in excel, excel vba sort range multiple keys, vba sort column a to z, excel vba sort list object on multiple columns, range.sort vba, excel vba multi level sort, excel vba sort multiple columns, excel vba sort column ascending, devex grid sort date column, can datagrid sort date column date, excel vba paste last column, excel vba form date, excel vba static date, datagridview sort date column, excel vba biggest date, excel vba paste cells column, excel vba search date cut paste, vbnet sort date column datagridview, excel vba cut insert column, excel vba next row column

İşveren Hakkında:
( 0 değerlendirme ) Dominican Republic

Proje NO: #18915234

Seçilen:

MimiFL

Hello, this is definitely possible. If you like please share an actual file with me, just so i can verify that it can be automated. Usually i can code something like this under an hour. Thanks, Milan

%selectedBids___i_period_sub_7% gün içinde 20%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(477 Değerlendirme)
6.9

Bu iş için 13 freelancer ortalamada $23 teklif veriyor

kolosibalint

Hi, I can quickly write you a script that loops through the items of column A. If it finds a non-numeric value, it will put that into the top of the first empty column and if it's numeric it will be paste into the f Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(120 Değerlendirme)
6.9
mrbrave

Hi. Using vba or formulas , I can complete the list within few minutes. I will create a macro for you, which you will use in future for similar data set. That will work with any number of rows Excel can handle Th Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(271 Değerlendirme)
6.8
rumarahman

Hi, I am an excel expert of advanced level of knowledge. I do only excel work with 100% accuracy and quality. Please let me take care of your file so that i can do the best quality work for you. And please PM me so th Daha Fazla

$25 USD in 0 gün içinde
(36 Değerlendirme)
5.1
webanis

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;

$15 USD in 0 gün içinde
(21 Değerlendirme)
4.1
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(22 Değerlendirme)
3.8
ZWXeno

I have 7+ years of experience with VBA and I have worked with Excel Worksheets extensively. I can deliver within 24 hours.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
2.6
musthree

Let me create a VBA/macro script for you in 1-2 hour and deliver. Ready to start right now. I am an expert in Excel and VBA programming.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
2.6
rajamajid1981

I can don this Just copy text and paste special and check Transpose. Data will be pasted as per ur desire. If u give me a chance i will do this for u???? I'm very professional and have valuable experience in Data E Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.4
languagedr

Hi, I am a data entry expert. I read your project and understand it. I am interested to do your project. I will provide you complete work right in that time, you can hire me and trust me. I am waiting for your response Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
Sudippalbwn

Dear Sir, Good Day I would like to bid for this project of "Marketing Search Project". I have been working since the last 2 years and have good knowledge of MS Office/ Word/ Excel/ Mail management and Data Research Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
ssnake007

I use excel everyday and I would be able to help you organize this data file. Tell me exactly what you need so I can complete for you.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
vw7452337vw

I am a dedicated professional who loves to find solutions to the problems.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0