Sort, Copy, Paste..without Autofilter..Anyone???

[jeffg]

This one should be easy..
I currently have a workbook which imports query's a web page and imports the
table's to one worksheet, and querys a text based database dump onto another
worksheet. Information on the latter is used for a Pivot table report, and
information from the web query is used to cross-reference designations on
the pivot table to generate configuration assignments on some test
equipment.
This all works fine.. However I would like to sort the data from the text
dump and copy specific groups of data into like-named tables. I am current
am using a recorded macro with the Autofilter option going through several
itenerations of 'Sort , Copy , Paste,etc..' This is however relatively
slow and inefficient. I'm not a programmer,- just a pretty lucky hack, I'm
sure there's an IF-Then loop I could utilize to streamline this process but
I'm not nearly that skilled enough to cook one up.

Any help would be appreciated...
-Jeff

 

[Arvi Laanemets]

Hi

Jou can use ODBC query for this. In general:

Define the source table (header row included!) as non-dynamic named range
(Insert>Name>Define), something like
MyTable=Sheet1!$A$1:$G$100
Save the workbook
On sheet, to where you want get data for some group, select cell A1, and
create a new query (Data>Get External Data>New Database Query) from Excel
files with your workbook as data source, and with range MyTable as table.
Determine the where clause in such way, that only records of wanted group
are recorded. In query options, set the query to be refreshed on open.


Arvi Laanemets