help with formula
 

I was wondering if there was a way to copy data from one column to
another without copying the blank cells?

Here's an example:

A B C D E F G H
1 .
2
3 .
4
5 .
6

The dots represent my data (every second cell) and I need to copy that
to H column but one cell after another (ie H1, H2, H3...). Is there a
way to do this? :confused:


--
smanuel
------------------------------------------------------------------------
smanuel's Profile: http://www.excelforum.com/member.php...o&userid=16337
View this thread: http://www.excelforum.com/showthread...hreadid=277237

Hi

if you select the range that you want to copy and then click on H1 and
choose Edit / Paste Special and tick Skip Blanks you should get what you're
after.

Cheers
JulieD

"smanuel" wrote in message
...

I was wondering if there was a way to copy data from one column to
another without copying the blank cells?

Here's an example:

A B C D E F G H
1 .
2
3 .
4
5 .
6

The dots represent my data (every second cell) and I need to copy that
to H column but one cell after another (ie H1, H2, H3...). Is there a
way to do this? :confused:


--
smanuel
------------------------------------------------------------------------
smanuel's Profile:
http://www.excelforum.com/member.php...o&userid=16337
View this thread: http://www.excelforum.com/showthread...hreadid=277237