Copy data from one workbook into another with named rangs

[AA_20069]

Hi all,

Let me set the sceanrio im trying to cover.

I have 3 workbooks wb1, wb2, wb3

wb1 contains one button to which you are able to select wb2 and wb3 to open.

wb2 is setup as follows
- 13 columns with x rows

wb3 is setup as a templated.xlt which is laided out in a reable manner to mimmic a document

What i am trying to do is copy the wb2 cells into the already defined named ranges in wb3

So for example:

wb2

heading 1
heading 2
heading 3
heading 4
heading 5
heading 6
heading 7
heading 8
heading 9
heading 10
heading 11
heading 12


a
b
c
d
e
f
g
h
i
j
k
l


m
n
o
p
q
r
s
t
u
v
w
x




wb3

named_range_1 = l
named_range_2 = a
named_range_3 = b
named_range_4 = c
named_range_5 = d
named_range_6 = g
named_range_7 = h
named_range_8 = e
named_range_9 = f
named_range_10 = i
named_range_11 = j
named_range_12 = k

fyi: The heading names, dont correlate to the named ranges


After each row, the wb3 would save the file as "file_1", "file_2" etc etc

any help would be greatly appreciated....

Regards

[AA_20069]

okay so cant seem to edit this. So for an update - I've used an arrary to define the named ranges - the problem im having now is getting the copying correct.

Anyone able to help out on this part?

So copy cell A2, past into different spreadsheet, come back to orignal spreadsheet, copy B2 etc etc etc untill L2 then move to A3 and repeat untill L3 etc