Hi Dear, Attached herewith the file of solution of your question. In that the solution is in column E. You have to copy Column E & paste special it in Column D.
Regards, Lavprasad Kori MIS Executive Hindustan Unilever Limited Mob : 9867931351 On Tue, Feb 24, 2009 at 11:11 PM, Mehdi_21 <meh.i...@gmail.com> wrote: > > > hey everyone > > i'm using a table like this one : > > A B C D > > 1 Main | value | value | value > 2 Extra | value | value | value > 3 Main | value | value | value > . > . > n Extra | value | value | value > > i want to delete every cell in column "D" only when cell in column "A" > contains "Extra" value. > > help plz > regards > > > > -- Thanks & Regards, Lavprasad Kori MIS Executive - Water Tel. 022 - 39833428 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Solution.xls
Description: MS-Excel spreadsheet
