+ Reply to Thread
Results 1 to 2 of 2

macro to find copy and paste

  1. #1
    Registered User
    Join Date
    12-14-2007
    Posts
    1

    Question macro to find copy and paste

    I have invoices that are stacked vertically, the only way to determine the point of seperation from one the the next is they all start with the word "Bill" (located in columb A) and end with the word "copyright" (located in columb A). The range is A1:H1609 and I need to automatically copy each invoice from the current sheet to a sheet called "invoices."

    Is this possible using a macro? If so, how?

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Yes, it does sound possible, but your request isn't quite clear. You have a sheet with a bunch of invoices, staring with Bill, and ending with copyright. Next, you want to copy all of them to a new sheet? This is the part I am confused about.

    Jason

+ 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