LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 42
Default Grouping data on seperate Worksheets

Hello,

I have an excel spreadsheet that draws monthly data from an Access Database.
This data is grouped based on months of the year and then sub grouped based
on dates during the month. what I would like to do for ease of use is have
the Spreadsheet understand that for each month it is to generate a seperate
worksheet for each month. Is this possible? And how would someone go about
coding the spreadsheet to look at the Months field and determine when to
build the new worksheet?
 
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
matching & combining data from seperate worksheets sshaefer Excel Worksheet Functions 2 May 10th 10 02:47 PM
how to extract duplicated data from two seperate worksheets? simon steel Excel Worksheet Functions 4 January 9th 08 09:36 PM
create chart with data from across seperate worksheets Diz Charts and Charting in Excel 3 December 23rd 07 04:00 PM
How do I seperate data from a pivot into seperate worksheets? Shannon Excel Discussion (Misc queries) 5 August 25th 05 06:07 AM
matching data on seperate worksheets Dale[_9_] Excel Programming 2 January 24th 04 10:33 PM


All times are GMT +1. The time now is 11:12 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"