Clarify what you want in column BZ. If A2 and A6 are "cost centre" then
BZ2:BZ5 cell formulas would be "=$A$2". Then BZ6: BZwhatever would be
"=$A$6". All cells in BZ would display cost centre, but from the appropriate
cell in column A. Is this what you intend?

Mike F
"Karen McKenzie" wrote in message
...
I'm hoping someone can help me.
I have a file which will have data pasted into it each day. The number of
rows and columns will vary each day. In order to manipulate this data I
need
guidance as to how to do the following:

When "cost centre" is found in column A, put cell reference of this entry
into all rows in column BZ until the next entry of "cost centre" is found.
Continue to do this till end of sheet.

When "posting date" is found in column A, paste cell value of columnn B in
that row into column CA and change the format so it becomes the number
that
date represents. Continue to do this till end of sheet

Can anyone help?