> the spreadsheet  and value out the whole spreadsheet to save
> time.
Do you mean delete as many cell contents as you can?

> was trying to use a macro  that would look for the "X" mark in
> the end of the column
Do you mean an X in a separate column or an X actually at the end of the
contents of a cell like "2345 X"

> also value out the formulas  after it has updated the changes
> to minimize file  space.
&
> in the end column of the report and value them out in the
> end?
Again... What do you mean by value out please?

For row  3... Is there a blank cell at the end? That is, could that be a
signal to stop... Process from col 1 row 3 to col N row 3 till we get to a
blank cell??

For the vertical process... Does the data start  and end at specific rows  or
again... Can we stop if a cell is blank?

Here is what I *think* you mean...
You have...
A set of formulae in row 3.
Beneath each formula you have a set of "vertical" data.
In a separate column at the end of the sheet you have an "X"

You want to...
Loop around row 3 col 1 to row 3 col N till you get to a blank.
Pick up the formula in row 3.
Go down the end column for row 4 to M with the "X"s in it.
For each row with an X in replace the value of the cell at row M col N with
that formula.
For each column without an "X" delete what's in row M col N.

At the end zap the formulas in row 3.

Is that correct please?