Suoritettu

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

Taidot: tietojenkäsittely, Excel, tietojärjestelmäarkkitehtuuri, Visual Basic, Visual Basic for Apps

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Dominican Republic

Projektin tunnus: #18915234

Myönnetty käyttäjälle:

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

$20 USD 0 päivässä
(477 Arvostelua)
6.9

13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

$40 USD 1 päivässä
(120 arvostelua)
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 Lisää

$20 USD 1 päivässä
(271 arvostelua)
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 Lisää

$25 USD 0 päivässä
(36 arvostelua)
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 0 päivässä
(21 arvostelua)
4.1
$20 USD 1 päivässä
(22 arvostelua)
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.

$25 USD 1 päivässä
(5 arvostelua)
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.

$30 USD 1 päivässä
(5 arvostelua)
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 Lisää

$30 USD 1 päivässä
(1 arvostelu)
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 Lisää

$25 USD 1 päivässä
(0 arvostelua)
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 Lisää

$10 USD 1 päivässä
(0 arvostelua)
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.

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

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

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