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:
Hope that makes sense.
Please Login or Register to view this content.
Kind Regards
Ross
Last edited by Cutter; 08-15-2012 at 11:35 AM. Reason: Added code tags
@ 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.
Thanks Cutter
I will do that in future! I'm sure I'll be posting alot on here over the next few years.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks