Thank you, but what I need is vba code for a macro. to explain better. i am importing data from web query to sheet1. It has up to twenty different data tables. The problem I have is each table can very from 4 to 20 rows. I need a macro to run that will copy and paste each table into fixed template on sheet2 whether there are 4 or 15 rows per table. ex:
sheet1-- sheet2
A B C-- A B C
1 R p p-- 1 R p p
2 H p p-- 2 H p p
3 H p p-- 3 H p p
4 H p p-- 4 H p p
5 H p p-- 5 H p p
6 R o o-- 6
7 H o o-- 7
8 H o o-- 8
9 H o o-- 9
10 H o o-- 10
11 H o o-- 11
12 H o o-- 12
13 H o o-- 13
14 R g g-- 14
15 H g g-- 15
16 H g g-- 16 R o o
17 H g g-- 17 H o o
18 H g g-- 18 H o o
19 H g g-- 19 H o o
20 R t t -- 20 H o o
21 H t t-- 21 H o o
22 H t t-- 22 H o o
23 H t t-- 23 H o o
24 H t t-- 24
25 R j j-- 25
26 H j j-- 26
25
etc. i hope this makes more sense and somebody can help me out. thank you!
Bookmarks