+ Reply to Thread
Results 1 to 2 of 2

Combine Payments on multiple sheets with same invoice #, multiple rows for each invoice #

  1. #1
    Registered User
    Join Date
    02-29-2012
    Location
    sanford, fl
    MS-Off Ver
    Excel 2007
    Posts
    21

    Combine Payments on multiple sheets with same invoice #, multiple rows for each invoice #

    Good morning. I am hoping that someone out there can help me. I would like to Combine Payments on multiple sheets with same invoice #, I have multiple rows for each invoice #. I have been sending both worksheets to a pivot and then doing a lookup off of one to the other to combine the payments. I'm thinking that I could create a macro to copy the columns that I want onto the same sheet so that it can be run by people that are not techy

    I'd like to copy the following columns from the LI Payment sheet to the IT payment sheet at the end
    1. Column A to Column B
    2. Column E to Column P
    3. Column G to Column H
    4. Column AO to Column D
    5. Column AS to Column AO
    6. Column AV to Column AR

    Any thoughts? A sample of the data is attached. Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Combine Payments on multiple sheets with same invoice #, multiple rows for each invoic

    Use autofilter to select the invoice # you're interested it.

    Put this in a module.

    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

+ 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. Invoice Mail Merge: Multiple Records per Invoice
    By watfordo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2014, 03:37 PM
  2. Print Invoice by pulling info from database by selecting Invoice Number
    By Swapnil Panchal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 11:21 AM
  3. Saving Invoice where next time I open file the Invoice Number increases by 1
    By domgee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2013, 03:03 PM
  4. Replies: 4
    Last Post: 11-04-2012, 12:43 PM
  5. Invoice templet Excel97 to 2003 invoice toolbar missing
    By MarolynInMarion in forum Excel General
    Replies: 0
    Last Post: 08-19-2005, 03:05 PM

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