How do I delete one worksheet from a different one?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to take all the entries from one worksheet and delete them from
another sheet if they are listed. The master file is over 56,000 rows and I
want to know if there is a faster way to find these rows in the master and
delete each one. Can anybody help me with this???
 
Mandy: On the sheet with items that you want deleted from the larger sheet,
type a "Y" or "delete" in the first blank cell to right of the item and copy
it down the list. Go to the larger sheet and click on the first blank cell
to the right of its first item. Put in a VLOOKUP formula referring back to
the "items to be deleted" sheet. Copy the formula all the way down to the
last record, the sort the data using the column. This will put all of the
"delete" items together...you can then delete them.
 
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

Combining data from multiple worksheets into one 4
how do i combine excel worksheets 1
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Stop linked cells from changing when insert new row? 1
Transferring text from one worksheet to another 1
How do I combine many worsheets into one worksheet?? 6
Splitting Data from One Worksheet to Many Automatically 3
Import entire row of data to other worksheet based on one lookup v 4

Back
Top