Copy only certain data from multiple worksheets

=?Utf-8?B?TWF0dA==?=

Guest

Posts: n/a

10th Feb 2006

I have a workbook with about 25 worksheets (one for every employee) all with
the same information. I have a macro that I can run which takes all the
sheets and creates a 'Master' sheet (merging all information) whenever I want
to run it. What I would LIKE to do is create this master sheet based on a
date range. For example, Column A is 'Date Assigned'. I would like to be able
to create a master based on only the month of January, February, etc...

Is this possible within the Macro or some other way? Also, could this be
automated somehow every month (not THAT important)? Thanks.

« Why doesn't Excel "word wrap" always expand the cell fully? | Excel 2000 can't open Excel 2003 workbook »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy data from 1 sheet to multiple worksheets	Rob P	Microsoft Excel Programming	2	15th Apr 2009 06:14 PM
how to copy data from one worksheet to multiple worksheets at once	zeb	Microsoft Excel Worksheet Functions	2	21st Oct 2008 07:25 PM
Copy data from multiple worksheets to worksheets in a number of other spreadsheets	SteveH	Microsoft Excel Discussion	5	6th Nov 2006 06:59 PM
copy data across worksheets and add multiple lines	madwoman	Microsoft Excel Programming	0	13th Aug 2006 01:35 PM
Copy data in multiple worksheets	=?Utf-8?B?a2ZsZXRjaGI=?=	Microsoft Excel New Users	2	11th Aug 2006 12:18 AM