Hello,
Below is a formula someone helped and resolved the problem in
column B. When I copy and paste into either C6,F6, and G6 it doesn't
go down the 6 cells. Please help.


=INDIRECT(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09"))


Put in B7 and copy down through B37.