If Cell contains certain text of pivot table then Show Details on Adjacent Column

[Barney1981]

Hi Guys

I am new to macro's and VBA so bear with me if my explanation isn't great.

I am trying to write a macro where it searches column D for a particular text eg 'Sales Action' and if found to show the selection from the adjacent cell in Column E. This will open up a new workbook, I have a macro where this was done manually to a cell as an example:

Please Login or Register  to view this content.

Hope that makes sense.

Kind Regards
Ross

[Cutter]

@ Barney1981

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

[Barney1981]

Thanks Cutter

I will do that in future! I'm sure I'll be posting alot on here over the next few years.

[Barney1981]

Anyone have an idea on this one, broken down into stages it is as follows:

Search Column "C" for text "example",
If "example" is in the cell, 'show detail' of cell in column D in same row.

Kind Regards
Ross