Thread
:
Copy info into empty cells below info, until finds cell with new d
View Single Post
#
4
Posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
Posts: 22,906
Copy info into empty cells below info, until finds cell with new d
Select A and B then F5SpecialBlanksOK
Type an = sign in active blank cell then point or arrow up to cell above.
CTRL + ENTER to fill all blanks with the value from each cell above.
In place.............CopyPaste SpecialValuesOKEsc.
Gord Dibben MS Excel MVP
On Sun, 16 Nov 2008 05:34:05 -0800, Fat Jack Utah <Fat Jack
wrote:
In Excel 2000 - I need a formula that will start at the top of a colum. WHen
it finds data in that column - copy that data to the cells below it which are
Empty or null cells, until it finds a cell with new data.. then begin to copy
that data in the empty or null cells below it until it finds a cell with
different data and so on
Sample (I Have thousands of this spaces of activity , so just copy would
take days)
08-01-08 Fred Jones Station 1
Station 2
Stations 3
John Smith Station 1
08-02-08 Sally Smith Station 4
Station 216
Station 1
Thanks for any help.. AS I said SOme times there is 50-200 spaces before the
new data and sometimes 1-2
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben