Dear Friends,

Can i also have a macro to group rows and columns.

I am new to excel and have no clue of macros.
I work on huge database with many sheets and many rows / columns

E.g

Firstly, It should ungroup all the rows and columns.
Massage should pop up the "Ungrouping done"

Then massage should pop up " Group Rows or Columns ? ".
I should be able to select either Row of Column from the drop down

For ROWS
If i select "Rows", then it should ask me "from row" and "to row" OR "End" several times since there are any rows and columns to be grouped due to big database.
In "From row" I will select the starting row for grouping
In "To Row", I will select the last row for grouping
If I select End, then macro will end.

Same conditions for COLUMNS.

I spend lot of time in formatting such a huge database since rows and columns keep adding every month.

Please help.