Help to copy from multiple file and transpose data

**sbv1986** · 10-21-2018, 06:32 PM

Hi all
I have code belove to copy from multiple file to wb MAIN.xlsx sheet(ketqua), soucre range as text and result as number

Now I want this code copy then paste transpose value into sheet(ketqua), the result I want demo in sheet(ketquamongmuon)
I attack some source files to more clear

Please Login or Register  to view this content.

**AlphaFrog** · 10-22-2018, 06:23 AM

Please Login or Register  to view this content.

**sbv1986** · 10-22-2018, 06:37 AM

Thanks @AlphaFrog.
I've just found code can do this problem, my code found is:

Please Login or Register  to view this content.

**jindon** · 10-22-2018, 06:48 AM

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**sbv1986** · 10-22-2018, 06:58 AM

Great @Jindon, code more faster than I have.

many thanks

Help to copy from multiple file and transpose data

LinkBack

Thread Tools

Rate This Thread

Display

Help to copy from multiple file and transpose data

Re: Help to copy from multiple file and transpose data

Re: Help to copy from multiple file and transpose data

Re: Help to copy from multiple file and transpose data

Re: Help to copy from multiple file and transpose data

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] copy multiple selections in a row and transpose

[SOLVED] Copy and Transpose multiple times in a new worksheet

Help! Copy, transpose, consolidate data from multiple worksheets

[SOLVED] copy column data from multiple tabs onto specified tab, transpose, repeat

[SOLVED] How to Extract Data from Multiple Files in Same Folder and Copy Data to One File

[SOLVED] Copy and Transpose Data From Single Row to Multiple Rows

Using OFFSET &/or TRANSPOSE functions to copy multiple rows of data into multiple columns

Bookmarks

Bookmarks

Posting Permissions