find value in column and move row to 5 rows after the last one..........

[amorrison2006]

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

 

[Dave Peterson]

Maybe instead of rearranging/duplicating your data, it would be better to use a
different function.

It kind of sounds like you could use something like:

=sumif(e:e,"books",F:f)
or
=sumif(e:e,"*books*",F:f)

If you're summing column F.

*books* (with the asterisks) will find book within the cell.
books (without the asterisks) will sum only based on a match in the entire
cell.

 

[amorrison2006]

Hi Peter

How can I automatically insert a row then in order to split the books
section - place the books section to the end.........???


thanks for this though,

looks like i could use it,

Andrea