Replies

Thanks for respond guys. I will use Rory’s one, because difficult for me to control array stay in formula.

Once more, people around me will think I am genius! while I keep tell everybodies about this lounge, but seems no one follows, : )

Rory, hope I can get back to this thread sometime if my brain to slow to understand the logic

regards

Indra

Many, many thanks. : )

best regards

Indra

So why don’t you use the second pivot table? You can change the grouping easily:

Ya, you are right but I need to change source of data, like in summary no.2.

I can not do that in summary no 1

please find attached file, hope could make this clear.

I can not group data in Pivot table no 1, but this is format I prepared to be used by someone else which bit difficult to explain how to re-pivot it.

Once I utilized one of ur formula to indicate name of month in next column, but this case expecting more, having grouping like quarter, or year.

thanks

Hi all,

this one is excellent, give me an idea for case of mine.

and thinking would be good if there is option for someone to indicate how useful a thread?

thanks

thanks for the reply, Hans

regards

Indra

Thanks for advise Stuart,

regards,

Indra

Hi Stuart,

I think I can modify some of the macro steps, simply copy to certain name of new worksheet. will get back to this forum, if can not

Thanks for giving hint

Indra

: )

Ya, and perhaps my question should be how to modify this macro (I knew only how to record,) so every time user create new sheet, range of data has been selected will be copied to the new sheet

regards

Indra

We may need to see a copy of your workbook to fully understand this, but if you can provide the following information then someone may have an idea for you.

[*]Exactly what error message do you get?

[*]If you click the “debug” button on the error message, which line of code is highlighted?

Please find as attached for the file,

(just realize, that allowed file uploaded has been increased..)

regards

Indra

Hans,

this is exactly what I need. intermediate formula is brilliant approach to teach guy like me!

many thanks,

indra

Thanks Prasad,

actually I was expecting some formula in next column, because this data will be received from various report to be consolidated in one working sheet.

using text to column is considered as second option.

regards

Indra

It works perfectly for all cases of mine,

Thanks a bunch Bosco,

Indra

Dear Bosco,

Hope this is not too much, but actually this can’t work for text like this

SEC MCH, 062 36900 71 2695 0522

without ” : ” at the end

regards

It’s very great!
Thanks very much Bosco,

I hope sometime I can understand the logic, because with previous one I can’t, eventhough have spent hours

Indra