Posted to microsoft.public.excel.worksheet.functions

Donna[_2_] Donna[_2_] is offline

external usenet poster

Posts: 76

Filling in blank cells with cell above

I have a column and I would like to fill the cells below it with the same
data as above. Sometimes there are more than one blank row below the Policy
number.

Column A
Policy
line 1 20BSBEX3110
line 2
line 3 20BSBEX9371
line 4
line 5 BINDER8083096
line 6
line 7
line 8
line 9 BINDER8083096
Line 10
Line 11

Thanks
Donna

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
problem filling in blank cells with data above -	stumped-in-excel[_2_]	Excel Discussion (Misc queries)	1	July 6th 09 10:10 PM
Filling in blank cells with information from cells above it	tracytracy123	Excel Discussion (Misc queries)	1	June 22nd 09 11:04 PM
Filling Blank Cells	Mary Mayo	Excel Worksheet Functions	2	April 10th 06 05:09 PM
Filling Blank Cells	Pankaj	Excel Discussion (Misc queries)	3	June 2nd 05 08:54 PM
Filling in Blank Cells	Rebecca	New Users to Excel	11	May 16th 05 10:47 PM

All times are GMT +1. The time now is 09:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us