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

**Barney1981** · 08-15-2012, 09:41 AM

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:

Sub Tabs()
'
' Tabs Macro
'

'
    Range("E5").Select
    Selection.ShowDetail = True
    Sheets("Sheet2").Select
    Sheets("Sheet2").Name = "LOR"
    
End Sub

Hope that makes sense.

Kind Regards
Ross

**Cutter** · 08-15-2012, 11:35 AM

@ 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** · 08-15-2012, 12:18 PM

Thanks Cutter

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

**Barney1981** · 08-16-2012, 12:39 PM

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

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

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

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

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

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

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

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions