Sir i have attached a sample sheet for observation.can it be possible by one click in vba? Pls help me
Sir i have attached a sample sheet for observation.can it be possible by one click in vba? Pls help me
See TRANSPOSE worksheet function …
i want to transform every 5 rows in one column......IN transpose it will make the full column to row..........pls give me any vba code.
Pls observe the sample sheet i need similarly that one just by one click.
Hi, Marc L,
so Transpose will also reverse the cells on the output as it was demonstrated in the sample file?
@anindya.zen:
Please Login or Register to view this content.
Ciao,How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
I didn't open attached file, my answer was just upon the "crystal clear OP explanation" …
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks