Closed Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    04-06-2011
    Location
    Sea, Wa.
    MS-Off Ver
    Excel 2007
    Posts
    2

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

    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!

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,327

    Re: is it possible for macro to read varying data tables and copy , paste into templa

    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.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1