did you wan tto fill in the blanks or what exactly did you want to do. Show a
before and after so taht we can give the the proper steps.
--
HTH...

Jim Thomlinson


"Jim" wrote:

Hello,

I'm wondering if there is a way to copy and paste information from one cell
to multiple cells when there is intermitant data in a column. For example,
Example:

Column A
In row 1 I have the word "operations"
with rows 2 - 10 blank and then
In row 11 I have the word "Courier"
and rows 12-22 blank
In row 23 I have the word "Sales"
with rows 24 - 32 blank. Etc...

Is there an easier way to command a copy and paste witout having to address
each cell with text?

Thanks
Jim