I have a excel file and there are around 130 Matl.Group.like-A,B and C
Now ,I want to arrange data as shown in my attachment file.
There are 4 category i.e.Production,DOM Sales,Export Sales and Cap. and mnt from Apr to Mar.
I want to arrange my data 'month wise,Matl Group and Category wise"as shown in yellow colour.
Can it be possible through VBA or excel formula ? How ?
hi there. i have feeling this layout may not be your actual one and you might need changes from this code. so if this happens, please remember to always upload a sample as close to actual as possible.
How to install your new code
Please 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
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Sorry for the mistake.
Please find the actual file and help me to re-coding.The new attachment name is -New Data File.
Thanks in advance,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks