VBA for copy paste content from above Row if conditions met

[sumesh56]

I have a huge database in excel. specimen is attached. I want excel to _
If found "TOTAL" in column A, then it should copy down the content from above row from B:E.

[Pepe Le Mokko]

Some suggestions you may fund useful:

1. Our answerers are looking to "help" more often than they are looking to "do an entire project for you for free".
2. Jump into this project yourself, when you get stuck on ONE specific hurdle, post that ONE item as a forum question.
3. Show us what you've tried in an attached sample workbook and how it's not working for you. When you're doing the work yourself, just writing out a complete example question in a forum often points you to solution before you even finish posting.
4. If you can't make any headway at all and no help is forthcoming in the free forum(s), we do have a Commercial Services forum where you can pay for assistance directly from our EF gurus."

[Mumps1]

Try:

Please Login or Register  to view this content.

[sumesh56]

Hi Mumps1
it works, thank you for the effort. have a nice day.

[Mumps1]

You are very welcome.