Dan
What you have given us is not a pattern. You have given us 2 points.
Two points does not make a pattern. Where does the data in B3 and C3 go?
And B4 and C4? Or is the location of "$$un" in Column A the key and each
subsequent row of Columns B & C goes after the next $$un? HTH Otto
"Dan" wrote in message
...
I have data in B1-B1000+ and C1-C1000+ that I need in column A. The problem
is that column B & C are filled with data. Column A has specific cells
that
the data needs to go into. In the example below B1 and C1 represent the
data
from columns B & C that need to be in A2 and A3. And b2 and c2 need to be
in
A7 and A8. This pattern continues for 1000+ rows.
Thank you in advance!

A B C
1 $$un $$tdp $$dac
2 B1 $$tdp $$dac
3 C1 $$tdp $$dac
4 pause $$tdp $$dac
5 $$tdp $$dac
6 $$un $$tdp $$dac
7 B2 $$tdp $$dac
8 C2 $$tdp $$dac
9 pause $$tdp $$dac
10