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.


--
John1950
------------------------------------------------------------------------
John1950's Profile: http://www.excelforum.com/member.php...o&userid=18671
View this thread: http://www.excelforum.com/showthread...hreadid=470260

From what I understand, you should be able to use this:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"John1950" wrote in
message ...

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.


--
John1950
------------------------------------------------------------------------
John1950's Profile:
http://www.excelforum.com/member.php...o&userid=18671
View this thread: http://www.excelforum.com/showthread...hreadid=470260

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

Thank you guys. Workred great. Thanks again. :)


--
John1950
------------------------------------------------------------------------
John1950's Profile: http://www.excelforum.com/member.php...o&userid=18671
View this thread: http://www.excelforum.com/showthread...hreadid=470260