Hi dave,

Yes i understand wher you are coming from. Unfortunately I aerage on having
to go through about 25000 rows of data, so in this instance i think a macro
would be better.

Regards

Chris

"Dave Peterson" wrote:

You can use code or do it manually. (I find doing it manually is quicker!)

Debra Dalgleish has suggestions for both:
http://www.contextures.com/xlDataEntry02.html



ir26121973 wrote:

Hi,

Wonder if someone can help me please.

I have an excel spreadsheet where the may be data missing from some of the
cells within a row.

Could anyone tell me how I would create a macro to find these blank cells
(obviously I would need to be able to determine the columns that are
pertinent) and copy the cells from above row.

Many thanks in advance

Chris

--

Dave Peterson