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 |
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 |
All times are GMT +1. The time now is 10:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com