is it possible for macro to read varying data tables and copy , paste into template?

[Alaan]

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!

[pike]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.