U can also use filter option rgd Gaurav
On Wed, Feb 25, 2009 at 11:23 AM, Lavprasad Kori <lavprasa...@gmail.com>wrote: > 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 >> >> >> Lavprasad Kori >> MIS Executive - Water >> Tel. 022 - 39833428 >> >> >> >> -- J.Gaurav Asst. Manager Mahindra logistics General Motor Hallol Baroda Cell - 9327348097 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---