+ Reply to Thread
Results 1 to 3 of 3

Delete duplicates and delete empty cells

  1. #1
    Registered User
    Join Date
    07-06-2010
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    98

    Delete duplicates and delete empty cells

    Hi there,

    I have a set of data in one column of "Sheet 1". I want to remove the duplicates and delete all empty cells. However this set of data with removed duplicates and deleted cells shall then be posted in "Sheet 2". The button to activate the duplicate remover and empty cell deleter shall be on a third tab "Sheet 3".

    Attached is an excel file which shows the task and the desired output.

    I am sure this is pretty basic but please help me as I am an absolute beginner regarding VBA.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Delete duplicates and delete empty cells

    Please Login or Register  to view this content.
    If you are happy with my response please click the * in the lower left of my post.

  3. #3
    Registered User
    Join Date
    07-06-2010
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    98

    Re: Delete duplicates and delete empty cells

    Worked, thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to find duplicates, concatenate cells, then delete old duplicates
    By givemepuppies in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-04-2016, 02:43 AM
  2. delete empty cells in a row, but don't delete the row
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2014, 06:03 AM
  3. [SOLVED] How to delete ALL duplicates cells
    By yannipr in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-21-2014, 04:41 PM
  4. Replies: 1
    Last Post: 05-26-2014, 01:31 PM
  5. [SOLVED] still have empty cell after run Delete empty cells code
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-25-2012, 04:28 PM
  6. Delete cells with duplicates
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2009, 11:28 AM
  7. delete duplicates macro to color instead of delete
    By DKY in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-22-2005, 01:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1