Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default macro to copy specific fields to another worksheet

I have a list of data, averages between 4 to 5 thousand lines, differs from
month to month. What I would like to do is sort on three fields, I can do
that. Once the sort is complete i would like to split these out based on the
column AL, the evaluator block, to seperate worksheets, 20 to 30 inspectors.
From there I would like to go back in and complete another macro that i have
already put together. any assistance with this would be greatly appreciated.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default macro to copy specific fields to another worksheet

Perhaps something on this page

http://www.rondebruin.nl/copy5.htm

at Ron de Bruin's site

--
Regards,
Tom Ogilvy


"Bud Hughes" wrote:

I have a list of data, averages between 4 to 5 thousand lines, differs from
month to month. What I would like to do is sort on three fields, I can do
that. Once the sort is complete i would like to split these out based on the
column AL, the evaluator block, to seperate worksheets, 20 to 30 inspectors.
From there I would like to go back in and complete another macro that i have
already put together. any assistance with this would be greatly appreciated.

Reply
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 Worksheet and Exclude Hidden fields Charles Gonzalez Excel Worksheet Functions 3 August 12th 08 12:31 AM
using macro, how can i copy similar fields from other xls files? Shaji Valiath Excel Discussion (Misc queries) 1 May 23rd 06 10:08 AM
using macro, how can i copy similar fields from other xls files? Shaji Valiath Excel Discussion (Misc queries) 0 May 23rd 06 09:56 AM
applying a macro for a specific field to a range of fields Craig[_24_] Excel Programming 3 October 12th 05 05:27 AM
Copy Worksheet to specific row in another workbook GregR Excel Programming 0 June 28th 05 07:08 PM


All times are GMT +1. The time now is 07:59 PM.

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"