Hi,
Theres four columns of data A:D.
If Column A has "Total Spend ", copy header A1:D1 and paste it on the second
row below Total Spend. So for example,

A1 B1 C1 D1
Vendor Category Option Spend
ABC
IBM
MAC
Total Spend
(Blank Row)
Automatically Paste Vendor Category Option Spend
Sample Vendor1
Sample Vendor2
Sample Vendor3
Total Spend

Vendor Category Option Spend



Any help is appreciated. Thank you