Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i delete data from a main xl list using another xl list???
i have a main emailing list that i keep in xl and sned out my newsletter to
this list each month . however i have collected my unsubscribe list on another spreadsheet. How do i now remove the unsubscribes from the main list without having to go through it manually. thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i delete data from a main xl list using another xl list???
Assuming that you want to keep your main list in it's current sequence, and that columns X Y and Z are unused in both sheets. If you want to match on more than a single field, in the Unsubs sheet do, in column X, =A1&B1 (formula drag to end) to give a joined field and use this to lookup. In your main sheet, in cell Y1 put =Row() In your main sheet, assuming column A is the primary key, in cell Z1 put either of: =VLookup(A1,UnSubs!A:A,1,False) =VLookup(A1&B1,UnSubs!X:X,1,False) as required, and formula drag Y1 and Z1 to the end of your data. Select columns Y and Z and Copy, then Paste Special = Values back over themselves. Then select All data and sort over column Z, and delete all not = #N/A lines (excluding headers), ie, the matches to your UnSubs list. Re-sort over column Y back to your original sequence, and delete columns X Y & Z Hope this helps -- jennifer Wrote: i have a main emailing list that i keep in xl and sned out my newsletter to this list each month . however i have collected my unsubscribe list on another spreadsheet. How do i now remove the unsubscribes from the main list without having to go through it manually. thank you -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=536550 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create an automatic complete list from existing data in the sheet | Excel Discussion (Misc queries) | |||
Create template that ignors data list rules | New Users to Excel | |||
Applying formulas only to the subtotals of a data list | Excel Discussion (Misc queries) | |||
Macro data selection line delete | Excel Discussion (Misc queries) | |||
subtotaling and manipulating a list of data | Excel Worksheet Functions |