Hi,

I've got a stack of data related to sales copied from an external source and
pasted into Excel.


The data is structured so that row 1 contains the name of a branch merged
acoss the columns, then rows 2 to X have sales data across various columns.
Then follows another row with a branch name. Each branch has a different
number of rows beneath it.

I've created a new column at Column A. I want this to be the branch name so
that I can filter and perform calculations. Luckily all the data in column B
starts with the word "sales", except those rows with a branch name. I'm
trying to figure a way to look at column B, and copy down Column A all the
way to the next occurrance of a branch name in B.

I hope this makes sense, any help appreciated.

--
Rich
http://www.richdavies.com/fantasy-football.htm

** Posted from http://www.teranews.com **