+ Reply to Thread
Results 1 to 1 of 1

Multiple Sheets, copying/summing from one sheet to another

  1. #1
    Registered User
    Join Date
    Salem, Oregon, USA
    MS-Off Ver
    2016 MSO (16.0.4849.1000) 32-bit

    Multiple Sheets, copying/summing from one sheet to another

    Hi everyone! I'm not sure if it should be posted here or in the Formula/Function thread (sorry if it should be in the other one!).

    I know the title is very generic but what I'm trying to do is hard to explain in a short sentence! I'm working with multiple workbooks that I'm trying to combine into one workbook with multiple sheets for 2 reasons: 1-it will eliminate some double entry the client is doing, and 2-I'm trying to get the data streamlined for use in Power BI. Therefore I'm hoping I can find a way to do this, but I'm not sure its possible.

    The first sheet (Billing Info) is a list of vendors and their invoice date, amount, project number, etc. The sheets after that are split up by project number (Project 1, Project 2, etc.) and show the PO's that were generated to match the invoices.

    What I'd like to do is: anytime something is entered on the Billing Info sheet for Project 1 (or Project 2, etc.), copy data from columns B, C, D, and E (See Billing Info Sheet screenshot below) over to the Project 1 sheet (See Project 1 screenshot below - B into B, C into C, D into D, and E into A). BUT (And this is the tricky part) --- When bringing the data over to Project 1, I'd like to sum the amounts in Billing Info-Column D when the date in Billing Info-Column C (Invoice Date) are the same AND the number in Billing Info-Column A (Site) are the same.

    For example:
    Billing Info sheet:

    Lines 322-333 would copy over as:
    Project 1 sheet:

    (I just realized that the Project 1 sheet should show a Project-Phase of 427405-36 for lines 8-10)
    Thank you in advance for any help you can give!
    Last edited by SandeA; 06-03-2019 at 03:49 PM.

+ 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. Replies: 1
    Last Post: 01-11-2018, 12:59 AM
  2. Copying columns from multiple sheets into one sheet
    By priyankalaha18 in forum Excel General
    Replies: 5
    Last Post: 08-01-2017, 09:54 AM
  3. Replies: 3
    Last Post: 06-20-2014, 05:49 AM
  4. Copying a template sheet and putting those multiple sheets data into a summary sheet
    By John Wolfe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2011, 06:29 PM
  5. Copying cells from 1 sheet to multiple sheets
    By stevenwhite1968 in forum Excel General
    Replies: 3
    Last Post: 05-10-2011, 09:49 AM
  6. Copying data from multiple sheets into one sheet
    By Todd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2005, 11:05 PM


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