There are instructions here for manually or programmatically filling the
blank cells:
http://www.contextures.com/xlDataEntry02.html
John1950 wrote:
My Spreadsheet looks like below.
A B C
207 MDIM3030 3 TRUE
208 MDIM3030 FALSE
209 MDIM3034 1 TRUE
210 MDIM3034 FALSE
211 MDIM3038 6 FALSE
211 MDIM3039 4 FALSE
I have sorted by Column "A" and done an EXACT on them.
Now I need to know how to, for example on cell, B:207 (3) and move it
to the blank cell below and so on through the Column. There are
hundreds of lines on the column, so I am looking for a quick way of
doing this. Can anyone please help?
Thank you.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html