+ Reply to Thread
Results 1 to 3 of 3

Clear contents based on cell value in another sheet

  1. #1
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    268

    Clear contents based on cell value in another sheet

    Hi good people,

    please help me with a code to look up a value (Text and numbers, example TA234), in cell G5 of sheet1, and then find the cell in column AA of sheet2, which corresponds to this value, and then clear that cell content in column AA. Thank you for all help, I do appreciate!..

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Clear contents based on cell value in another sheet

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    04-16-2014
    Location
    Witbank, SA
    MS-Off Ver
    Excel 2013
    Posts
    268

    Re: Clear contents based on cell value in another sheet

    Hi Alansidman,

    100%..Thank you very much..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Clear Contents in One Cell based on another value
    By basketball2524 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2014, 06:35 AM
  2. [SOLVED] Clear contents based on contents of another cell
    By Katrina DTE in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-13-2013, 02:44 PM
  3. Clear Cell Contents Based on Criteria
    By AdamsR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2012, 01:52 PM
  4. Clear contents based on value in another cell
    By RochesterColonial in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2010, 12:01 PM
  5. clear cell contents based on conditions
    By darkhorse4321 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-18-2010, 10:59 PM
  6. Clear cell contents based on defined name
    By SMB in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-14-2010, 12:48 PM
  7. hide column and clear contents based on a cell value in another sheet
    By dittotharappel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2009, 12:19 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