Hi there'

i've tried looking on these posts but i need a macro to find the word
"books" in column E and then every time it finds this word copy it to
the end of the last row.

I'd then like it to subtotal the data with "books" in column E at the
end and also the data before that which I think should be 5 rows
before.

I don't use the total formula because I dont to split all my
categories in column E. Only books......

I hope this makes sense.

Sometimes not so easy to see things on here.......

thanks in advance for you help,

Andrea