Delete Excel Rows within specified outline created by subgroup function

Help
, ,
1

Hello Guys,
I have an excel sheet with groups made by subtotal function as attached in the screenshots.
what I need to do is filter with specific group name then delete it with its embedded rows.
any ideas ??

Screenshot (21)
Screenshot (21)1366×768 130 KB
Screenshot (22)
Screenshot (22)1366×768 159 KB

2

Hi @Dina.abdelhakam,

I hope you’re doing well and welcome back after 5 months! :smiley:. You will probably have to use a macro for this you can call the macro code by using the Invoke VBA activity or execute macro.

1 Like
3

Thank you,
I have used another workaround. but your idea worked I would probably use it in future :slight_smile:

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.