Matching and listing

Peter Harms

New Member
Joined
Jul 5, 2019
Messages
3
Good day
Firstly, I am very grateful for the help I received last time round. Whoever helped me thank you. I had a mail glitch so I cannot do it personally.
I am trying to help my wife with managing a ******* etc
I have managed to construct some stuff but now I am struggling to extract the data so it means something!
Here is my problem
I have a worksheet with numerous columns amongst which


WORKSHEET 1

SUPPLIER INVOICE TOTAL INVOICE NO
ACME 1234

SUPPLER INVOICE NO INFO INFO INFO INFO DESCRIPTION INFO INFO INFO INVOICE TOTAL
ACME 1234 A 100,00
ACME 1234 B 2350,00
ACME 1234 C 562,00
ACME 1234 D 398,00
ACME 1234 E 889,00
ACME 1234 F 745,00
ACME 1234 G 441,00


WORKSHEET 2

SUPPLIER INVOICE NO
ACME 1234

DESCRIPTION AMOUNT
A 100,00
B 2350,00
C 562,00
D 398,00
E 889,00
F 745,00
1. On Worksheet 1 at the top there is a section to enter the supplier name, and invoice no of the invoice being captured
2. As the invoice lines are captured I want to keep a running total of the captured data so that the user can verify that, at the end of the exercise, the captured data agrees with the invoice itself
3. So I am trying to sum the invoice total that refers to the supplier name and the relevant invoice
4. On worksheet 2 I want to enter the supplier name and the invoice number and then have the invoice details listed underneath. This worksheet is used to select supplier names and invoices and list the relevant details.

I have tried all sorts of things parrot fashion:) but I dont seem to be able to use arrays. I am using Excel for Mac.
Any help will be deeply appreciated.
Thank you
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Forum statistics

Threads
1,223,897
Messages
6,175,269
Members
452,628
Latest member
dd2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top