thank you sir, you saved me tons of time searching for answers and tons of nerves. Greetings from Slovakia :)

Very helpful and detailed video even for the one who knows nothing about VBA. Thank you!

@ExcelDestination

2 жыл бұрын

Welcome

Your tutorial is very impressive as well as simple to understand. It will be very useful to any body. Thanks.

@ExcelDestination

2 жыл бұрын

Welcome

Very good 👍...Very well explained. ..

Is it possible to do the otherwise? Copy and transpose from row based to column based?

Hi , I want to do it reversely which you have done the operation

Thanks

how do I get a copy of the Macros?

Can u show us how can I merge multiple excel files in single file, but I want to merge only specific sheets from multiple excel file. I mean if there are 10 sheets in one file then I want to take one one sheet from multiple files and merge it to single file.

Awesome video. But I wanted to know how to open multiple excel files and transpose A2 to A16 and save all transposed data in New excel file . Is it possible to do it on single button click ?

@ExcelDestination

4 жыл бұрын

let me create a tutorial to open multiple excel files.

@logiclaunchpvt.ltd.officia7207

4 жыл бұрын

@@ExcelDestination thank you sir.please make video for opening multiple files and do transpose cell data and paste that value to main worksheet of all worksheets

@Bws098

3 жыл бұрын

What is code for recovering the data once deleted,please sir. Or, what is the way to transpose back?? A lot of thank you.

Thanks sir, I want to transpose data like this format Heading A B C Heading1 A B C D Heading2 A B C D Heading3 A B C D E Now need to data below format, that is possible sir, if yes could please help Heading A B C Heading1 A B C D Heading2 A B C D Heading3 A B C D E

Sir, what if, we want to copy data after the gap of say after one column or two

@ExcelDestination

3 жыл бұрын

use can use the same code multiple times

@gopinathlone4250

3 жыл бұрын

Thank you sir

Sir what is d meaning of application.cutcopymode=true?

@Bws098

3 жыл бұрын

It should be false . Otherwise, the copy mark/Sign will remain on the selected cell or range.

Sir inhi five subtitles - order no., Date ,qty,product,qty ko use karke order,dispatch,total balance ke stock maintainance ki problem solve kar dijiye sir

@ExcelDestination

3 жыл бұрын

Sorry he is no more

I think my requirement has been misunderstood. For example I have a file where Name, address etc. are there. In the second file, Name, address columns are there but data is not there. But when I select name "Ram" and "New Delhi" in the first file, this particular data will appear and display in the second file. Is is possible? Then kindly show with demonstration.

@ExcelDestination

4 жыл бұрын

sorry, not able to understand. can you please elaborate little bit more.

@satyabanukil779

4 жыл бұрын

@@ExcelDestination In Excel File No.1, I have two columns e.g Name and Contact No. and under the two columns I have data.For example, Ram 6787698765, John 8798768976 and so on. In Excel File 2, I have same two coloums as File No.1, but there is no data. Now what I want is if I select any name in File No.1 the same name with corresponding contact no. will appear in File No.2. Is it possible and if so, kindly demonstrate.