Results 1 to 9 of 9

Need to search for a specific string in Column A and delete values within the same row

Threaded View

hgeo24 Need to search for a specific... 02-27-2014, 03:14 PM
Kaper Re: Need to search for a... 02-27-2014, 03:19 PM
hgeo24 Re: Need to search for a... 02-27-2014, 03:28 PM
AB33 Re: Need to search for a... 02-27-2014, 03:43 PM
Kaper Re: Need to search for a... 02-27-2014, 03:47 PM
hgeo24 Re: Need to search for a... 02-27-2014, 03:57 PM
AB33 Re: Need to search for a... 02-27-2014, 04:04 PM
Kaper Re: Need to search for a... 02-27-2014, 04:41 PM
hgeo24 Re: Need to search for a... 02-27-2014, 04:56 PM
  1. #1
    Registered User
    Join Date
    01-31-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Need to search for a specific string in Column A and delete values within the same row

    Hi all,

    I have a spreadsheet with values in Columns A:AP. Most of these values in Column A are 4 digit numbers but once in a while the value will be "Group key". The number of rows in the spreadsheet varies from week to week, as does the placement of the cells that read "Group key". It will always be in Column A but the row number is impossible to predict. Also, there can be multiple instances of the "Group key" cells in the same spreadsheet. What I need is a code that will find ALL instances of "Group key" in column A, and then clear the values in columns D through AP within the row that the cell with "Group key" is found. I know how to write code to delete the entire row, but I need to keep the row and just clear values in the columns I mentioned.

    Thanks for any help!
    Last edited by hgeo24; 02-27-2014 at 03:18 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Loop to search specific names in column and delete other rows
    By EJ_2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2013, 01:28 PM
  2. Replies: 4
    Last Post: 10-28-2013, 10:57 AM
  3. [SOLVED] Search for multiple string values in the first row of a table and format column values.
    By Excel_junky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-12-2013, 12:48 PM
  4. Replies: 1
    Last Post: 04-23-2012, 10:27 AM
  5. Delete rows with specific column values
    By koklok in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2008, 01:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1