+ Reply to Thread
Results 1 to 5 of 5

If number in column A appears more than once then copy all of that to another sheet

  1. #1
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    If number in column A appears more than once then copy all of that to another sheet

    Hi,

    I want to be able to write all rows that have the same number in column A to another sheet and save that sheet as multiple.xls and then return to the first sheet and delete those rows that have been moved and then save that sheet as single.xls

    I have attached the example file which shows the original data in the StartingFile tab and then the required output files in the form of the other 2 tabs.

    Thanks for any help,

    David
    Attached Files Attached Files

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: If number in column A appears more than once then copy all of that to another sheet

    Hi, David,

    slightly different aproach will will collect all singles as well as multis in one sheet and save these as workbooks:
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Re: If number in column A appears more than once then copy all of that to another sheet

    Hi Holger,

    It created the 2 workbooks but they did not contain any information, I'm using excel 2003 should it still work?

    Thanks,

    David

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: If number in column A appears more than once then copy all of that to another sheet

    Hi, David,

    it should work with this little amendment:
    Please Login or Register  to view this content.
    Ciao,
    Holger

  5. #5
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Re: If number in column A appears more than once then copy all of that to another sheet

    Thanks Holger, it works perfectly.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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