Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sort, Copy, Paste..without Autofilter..Anyone???
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 |
#2
|
|||
|
|||
Sort, Copy, Paste..without Autofilter..Anyone???
Hi
Jou can use ODBC query for this. In general: Define the source table (header row included!) as non-dynamic named range (InsertNameDefine), 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 (DataGet External DataNew 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 "jeffg" wrote in message link.net... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and paste only unhidden information | Excel Discussion (Misc queries) | |||
Copy and paste from 1 workbook to another | Excel Worksheet Functions | |||
Issue with copy & paste? | Excel Discussion (Misc queries) | |||
copy and paste | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) |