Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy info into empty cells below info, until finds cell with new d
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move cell info and info in neighboring cell on new entry | Excel Discussion (Misc queries) | |||
Copy Info from cell to another sheet | Excel Discussion (Misc queries) | |||
comparing a column of cell and then copy info to other cells | Excel Discussion (Misc queries) | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
how do i get excel to see info in one cell, look at info in anoth. | Excel Discussion (Misc queries) |