View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
LiveUser LiveUser is offline
external usenet poster
 
Posts: 90
Default Removing items from worksheet by account number question

1st worksheet (Master) - I want to delete from Master
A BH
Account 1 Data
Account 1 Data
Account 1 Data
Account 2 Data
Account 3 Data
Account 3 Data
Account 3 Data
Account 3 Data

2nd worksheet (Accounts to be deleted)

A
Account 1
Account 3
Account 7
Accoun 25
Account 100



Thank you.

"Bernard Liengme" wrote:

You need to tell us how the data is set out
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"LiveUser" wrote in message
...
I need to remove everything that is related to one account number and so on
for other account numbers is there a way to do this or a way to highlight
them...

Thank you.