Deleting rows using key data

  • Thread starter Thread starter shylu
  • Start date Start date
S

shylu

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help Please :) I'm VBA Stumped 2
Run two macros for two different sheets 11
Array with many cells from a row but not in order or together 11
Excel VBA help: Text file formatting 19
Combine three InputBoxes into one? 7
copy a template and fill in data from a single worksheet 1
Code copies twice...? 13
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26

Back
Top