Extract or Puliing Data From Vertical To Be Horizontal

[Jhon Mustofa]

hi all..

i'm looking for macro/vba code to extract/pull data from a sheet.
now, my layout in a vertically and i want data can extract to be horizontal with like database.
my data/target that i want extract in cell that highlighted red color

please, check attachment file..

any help me, greatly appreciated..

john m

[Kaper]

Try such macro:

Please Login or Register  to view this content.

PS. It's a pitty, you have shown only input data, not expected output. But I hope it suits you.

[Jhon Mustofa]

hi Kaper...

thank you so much...working well 100%!!

but if you have time for me, i found new problem..my excel file over 100 and i want to extract all them at once..
rules:
my directory in c with folder name "reval" and my excel file name to extracted like "kkp1,kkp2,kkp3,kkp3,kkp4,kkp5,kkp6,etc....."

how to pull data them at once into one file into one sheet..

thanks again.

[Kaper]

Hi John,
I believe, it's separate problem. So probably it's a good idea to statrt another thread on imoprting data from several files in a folder. Or to use Search on a forum or search engine, as there are many similar cases solved on the web