Share via

How to create a macro based on data instead of clicks?

Anonymous
2024-10-02T13:30:43+00:00

I created a macro to filter out data on a pivot table. All I did was record my keystrokes where I go into the filter and unselect the ones I want. I am wanting to be able to add to that where all rows in column H (picture attached) are collapsed with the "-" button if there value is greater than -(500). This data changes daily, so I don't think it can be doe from Excel recording my mouse clicks. Is there a way to add to my current macro or to create a new macro that filters and hides rows based on the value in column H?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-10-03T03:29:03+00:00

    Could you share a test file? Then I can test macro on it.

    Macro can hide rows based on values on another column.

    For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.

    *Please make sure you have removed any sensitive or private information in the sample file before uploading.

    Was this answer helpful?

    0 comments