Extract nebmers from rows to column

**ExcelBG** · 05-09-2017, 08:40 AM

Hi all,

I`m looking for help to extract numbers from rows to column.

What I wrote as a macro is:

Please Login or Register  to view this content.

Any help will be appreciated
Here is my example:

**jindon** · 05-09-2017, 08:49 AM

Like this?

Please Login or Register  to view this content.

**ExcelBG** · 05-09-2017, 08:55 AM

Yeap like this,

Thank u jindon!

This macro works perfect.

Is it possible to know what am I doing wrong in my macro?

**jindon** · 05-09-2017, 09:20 AM

You are overwriting each row of value in 3 cells.

Please Login or Register  to view this content.

So, difine another varialbe like "n"

Please Login or Register  to view this content.

**ExcelBG** · 05-09-2017, 09:30 AM

A lot of tnx

Re: Extract nebmers from rows to column