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 |
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) |