LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
jeffg
 
Posts: n/a
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy and paste only unhidden information heatherB Excel Discussion (Misc queries) 2 September 13th 05 03:34 PM
Copy and paste from 1 workbook to another bigdaddy3 Excel Worksheet Functions 0 September 13th 05 10:05 AM
Issue with copy & paste? Etrnal168 Excel Discussion (Misc queries) 2 July 12th 05 03:35 AM
copy and paste He4Giv Excel Discussion (Misc queries) 3 June 23rd 05 12:27 AM
How do I copy an outline w/ subtotals & paste just the subtotals av Excel Discussion (Misc queries) 1 June 20th 05 11:35 PM


All times are GMT +1. The time now is 11:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"