copying multiple cells conditionally

[insanity66]

I am a psychologist and I am creating a spread sheet which takes datas from two different sets about 20 cells each. What I want to do is copy those cells that have text entered into them and use the edit - copy function to paste that data into another program but I do not want to include all the blank cells that are between the two sets which is always changing depending on the situation.

example:

mbr was not home
mbr is si
mbr is depressed
mbr is unable to contract for saftey

(Here I will have about 10-15 empty cells then it continues )

oca called police to assist mbr
oca notified officer jones
oca authed IPMH for 3 days



Am I being to ambitious?
Thanks
Jim

[Maistrye]

Probably not that ambitious.

One way to do what you desire is to use the AutoFilter. If you need help with the specifics of the AutoFilter, look at Debra Dalgleish's site: http://www.contextures.com/tiptech.html

Essentially, you want to highlight the entire region you intend to copy, with one blank cell (or title cell) above. Ie. Data in A2:A6, A20:A24, you'd highlight A1:A24. Then put on the AutoFilter. Then on the AutoFilter, choose Non-Blanks. You should see only the cells that have data. Then highlight the ones you want, copy, and paste. (Note: If you paste, undo, and paste again, you'll get the blanks too. If you have to undo, copy again before pasting)

Scott