Select grouped rows

[Guest_imported]

How can I select automaticely grouped rows in VBA from the first rows

 

[DinS]

Please kindly give more detail what you need to do

 

[Guest_imported]

I have grouped informations (Menu Data-Group) in a price list Sheet and I want to transfer this datas in an other sheet. for this I must:
1. Select the grouped datas from the first rows of the grouped rows (Quantity of grouped rows is different for each group)
2.transfer these datas in the other sheet

Exemple if I have a price list for computers standard assembling, each group is constitued with
1. Title row: ex.Computer Promotional Package A (price is total of each rows in point 2
2. Following rows (from 1 to x rows)etail of each element with unit price and quantities

To transfer datas in Invoice Sheet , I want to select only the title row :Computer Promotional package A

 

[DinS]

I think it is better if you could send to me the example of file before process and after process. So I can I undestand more clearly want you need.

Thanks

 

[DinS]

Here is my e-mail address
saharuddin-samian@jhr.global.sharp.co.jp