LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 709
Default Splitting Data from One Worksheet to Many Automatically

Is it possible to split data from one worksheet to seperate worksheets based
on a criteria in Column A, e.g. day / month / surname / etc.

I have a master list of data which changes frequently and it is split into
seperate worksheets for individuals to review data specific to them. I want
to automate copying the data from the master schedule to the seperate
individual worksheets.

Thanks.
--
Richard
 
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
automatically appending newly added data on worksheet to a master list worksheet tabylee via OfficeKB.com Links and Linking in Excel 0 December 17th 09 04:24 PM
SPLITTING DATA INTO NEW WORKSHEETS FROM ONE WORKSHEET Romeo Excel Discussion (Misc queries) 3 November 21st 08 05:01 PM
Automatically Filling In Corresponding Data from Another Worksheet [email protected] Excel Discussion (Misc queries) 2 September 23rd 06 01:52 AM
Automatically pasting worksheet data to new worksheet with formulas COntactJason Excel Worksheet Functions 0 August 10th 05 08:22 PM
automatically copy data from one worksheet to another LC Excel Worksheet Functions 1 July 23rd 05 03:36 AM


All times are GMT +1. The time now is 07:52 AM.

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

About Us

"It's about Microsoft Excel"