Copy Row that Contains Grouped Data

[gplans]

Hi There,

I am trying to copy all the data in my row that includes the grouped dated. If the data is grouped and I past the new row in it messes up my conditional formatting. If the data is ungrouped the conditional formation just expands another row.

Is there a way to include the grouped data?

 

[gplans]

Bumping this. Wounding if anyone has any idea. Cannot find a solution.

 

[gplans]

Bumping this. Wounding if anyone has any idea. Cannot find a solution.

Just to add one more bit of information which I think relevant is that my data is in a table. I have tested with data that is not in a table and it does copy the hidden data.

 

[gplans]

Wow looks like I have stumped the community. I don't think there is a way. At least I cant find it.

 

[gplans]

Wow looks like I have stumped the community. I don't think there is a way. At least I cant find it.

I have attached the file it that can assist you to assist me.

Thanks

https://www.dropbox.com/s/2l92p3my5kpv2da/MASTER SPREADSHEET.xlsm?dl=0

 

[gplans]

I have attached the file it that can assist you to assist me.

Thanks

https://www.dropbox.com/s/2l92p3my5kpv2da/MASTER SPREADSHEET.xlsm?dl=0

Can anyone help?