Apparently you have a reason for not doing the simple copy and paste. What
is it? Knowing this will help someone in answering your question. HTH
Otto
"clk" wrote in message
...
Hello. I have a spreadsheet with data in column A and column H. I
need to "copy and paste" all data from column A (starting in A3) to
Column N (starting at N3). Once that is done, I move over to column H
(starting in H3) and copy all of the data there to Column N under
where the data stopped from column A.

I hope this make sense but here is a little example of what I want to
do:

A H N
1 7 1
2 8 2
3 9 3
7
8
9


I thought an "If" formula would work but I am not getting it to work
right.

Any help would be appreciated.