Replacing Contents of 1 Cell to Another.

[John1950]

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.

[Anne Troy]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Debra Dalgleish]

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

[John1950]

Thank you guys. Workred great. Thanks again.