Skip to Content
avatar image
Former Member

Excluding Sheets without data in Worksheet Generation

Hello SAP Gurus,

Here is what I am trying to do:

In a report, I use worksheet generation to display worksheets by costcenter. This works fine but here is the problem. Lets say I expand for all costcenters under IT, and there are 9 members under it. It will create worksheets for all 9 costcenter member, even for the ones that have no data. Is there a way to essentially surpress/not create sheets for cost centers that dont have data?

Thanks.

Zalak

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 02, 2017 at 07:01 AM

    Write your own worksheet generation procedure in VBA.

    Add comment
    10|10000 characters needed characters exceeded