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:
BillingInfo.jpg
Lines 322-333 would copy over as:
Project 1 sheet:
Project1.jpg
(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!
Sande
Bookmarks