Create Multiple table from 1 table

[Shayanan]

I create a table (Table.A) from web source.

I want create table.B not from web source, but from exact data in table.A, so when refreahing table.B, it get content from table.A.


P.s: I tested connection reference, but every sub connections use Internet as source of data and just get structures from data.connection.source.

 

[ranman256]

  'select table A
range("A1").select
ActiveSheet.UsedRange.Select
Selection.Copy

   'paste to table B
range("g1").select
ActiveSheet.Paste
Application.CutCopyMode = False