Inserting a space and Suming Macro

**lobodade** · 06-20-2011, 02:55 PM

Hello everyone,

I have searched around on the forum and on google for the macro but have not found anything that could be modified ( at least by me, as I dont know VB) to fit my task.

I have attached a file which shows my data at the top, and then the result that I need at the bottom.
It is basically inserting a space in between ticket numbers and then summing up the amount of units under that ticket.

Any assistance will greatly be appreciated.
- Thank you for the help,
Denis

**JBeaucaire** · 06-20-2011, 04:43 PM

A programming-less solution, if you don't mind... Just put this formula in F2 and copy down:

=IF(OR(A3<>"",B3=""), "Total: " & SUM(INDEX($E$1:$E2, MATCH(99^99, $A$1:$A2, 1)):E2), "")

**watersev** · 06-20-2011, 04:52 PM

check attachment, run code "test"

**lobodade** · 06-21-2011, 09:00 AM

JBeaucaire,

Thank you for that code. it works well but i still need that space in between ticket numbers.
- Denis

Originally Posted by JBeaucaire

A programming-less solution, if you don't mind... Just put this formula in F2 and copy down:

=IF(OR(A3<>"",B3=""), "Total: " & SUM(INDEX($E$1:$E2, MATCH(99^99, $A$1:$A2, 1)):E2), "")

**lobodade** · 06-21-2011, 09:03 AM

Hi watersev,

When i ran the macro the first toal came out to be 15, when in reality it should be 47. The macro looks very confusing to me so I cant really play around with it. Could you please double check that total?
Also Instead of the ticket number and Count, is it possible for it to just say Total?

- Thank you,
Denis

Originally Posted by watersev

check attachment, run code "test"

**lobodade** · 06-21-2011, 09:31 AM

Hello again guys.

So i found a way to make it work and all I need is a macro that will insert rows. I found many different ones on this site but cant get any of them to work.
I just need a way to add a space before every ticket number

- Thank You,
Denis