View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shylu shylu is offline
external usenet poster
 
Posts: 1
Default Deleting rows using key data

I have 2 worksheets, Sheet 1 and Sheet 2.Sheet 1 comprise of n rows an
10 columns including a column name called UserID.Sheet 2 has only on
column called UserID. Now the task is I want to read userid from shee
2 and delete those rows in Sheet 1 which contain the userids read fro
sheet2. Can anyone help me to write a macro for this

--
Message posted from http://www.ExcelForum.com