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
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