AA_20069
02-04-2015, 06:31 AM
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
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