pls help,
i want to change row value into diagonally(number) in sheet.
ex. 1 2 3 4 5 to
A1=1,B2=2,C3=3,D4=4,E5=5 & so on.......
pls help,
i want to change row value into diagonally(number) in sheet.
ex. 1 2 3 4 5 to
A1=1,B2=2,C3=3,D4=4,E5=5 & so on.......
Here is a VBA solution
How to install your new codePlease Login or Register to view this content.
- 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
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
alansidman
so many thanks sir.works like a charm.you save my life.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks