I have got a file with 11000 invoices€¦this is just an example€¦
For bill 582792093 I have got 3 invoices on an excel it can be more too) I
want to run a kind of macro or formulae that will just give me the invoice
(2) as clearance week 4 by cancelling out 1 st invoice with the 3 rd invoice
as + & -

GB14190316-582792093 GB14190316 582792093 50
GB14204648-582792093 GB14204648 582792093 20 c
GB14486877-582792093 GB14486877 582792093 -50

Appreciate if can get this sorted...Please let me know if you need more
clarification...

"Kam" wrote:

I have got a file with 11000 invoices€¦this is just an example€¦
For bill 582792093 I have got 3 invoices on an excel it can be more too) I
want to run a kind of macro or formulae that will just give me the invoice
(2) as clearance week 4 by cancelling out 1 st invoice with the 3 rd invoice
as + & -

GB14190316-582792093 GB14190316 582792093 50
GB14204648-582792093 GB14204648 582792093 20 c
GB14486877-582792093 GB14486877 582792093 -50

I would appreciate if you get me solution to this...

"Kam" wrote:

I have got a file with 11000 invoices€¦this is just an example€¦
For bill 582792093 I have got 3 invoices on an excel it can be more too) I
want to run a kind of macro or formulae that will just give me the invoice
(2) as clearance week 4 by cancelling out 1 st invoice with the 3 rd invoice
as + & -

GB14190316-582792093 GB14190316 582792093 50
GB14204648-582792093 GB14204648 582792093 20 c
GB14486877-582792093 GB14486877 582792093 -50

You can send me an example file (.xls NOT .xlsx) to:

pashurst <at auditel.net

(change the obvious), and I'll take a look at it. Zip it if it is a
large file.

Pete

On Jan 26, 11:08*am, Kam wrote:
I would appreciate if you get me solution to this...



"Kam" wrote:
I have got a file with 11000 invoices…this is just an example…
For bill 582792093 I have got 3 invoices on an excel it can be more too) I
want to run a kind of macro or formulae that will just give me the invoice
(2) as clearance week 4 by cancelling out 1 st invoice with the 3 rd invoice
as + & -

GB14190316-582792093 * * * GB14190316 * * *582792093 * 50 *
GB14204648-582792093 * * * GB14204648 * * *582792093 * * * * *20 * c
GB14486877-582792093 * * * GB14486877 * * *582792093 * * * * -50 * * * * *- Hide quoted text -

- Show quoted text -

Hello Pete,

Thanks for your reply.

I have sent you a Zip excel file on below email.

Appreciate your help.

Best Regards,
Kam.

"Pete_UK" wrote:

You can send me an example file (.xls NOT .xlsx) to:

pashurst <at auditel.net

(change the obvious), and I'll take a look at it. Zip it if it is a
large file.

Pete

On Jan 26, 11:08 am, Kam wrote:
I would appreciate if you get me solution to this...



"Kam" wrote:
I have got a file with 11000 invoices€¦this is just an example€¦
For bill 582792093 I have got 3 invoices on an excel it can be more too) I
want to run a kind of macro or formulae that will just give me the invoice
(2) as clearance week 4 by cancelling out 1 st invoice with the 3 rd invoice
as + & -

GB14190316-582792093 GB14190316 582792093 50
GB14204648-582792093 GB14204648 582792093 20 c
GB14486877-582792093 GB14486877 582792093 -50 - Hide quoted text -

- Show quoted text -

Yes, I've received it - I will take a look this evening.

Pete

On Jan 26, 2:53*pm, Kam wrote:
Hello Pete,

Thanks for your reply.

I have sent you a Zip excel file on below email.

Appreciate your help.

Best Regards,
Kam.

Hi Pete,

Any news?

Kam.

"Pete_UK" wrote:

Yes, I've received it - I will take a look this evening.

Pete

On Jan 26, 2:53 pm, Kam wrote:
Hello Pete,

Thanks for your reply.

I have sent you a Zip excel file on below email.

Appreciate your help.

Best Regards,
Kam.