I suggest, instead that you use ONLY one sheet and filter as desired. See attached and filter by region and then by date. to clear filters use data>filter>show all
From: Mr excel
Sent: Monday, October 03, 2011 4:19 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Update sheets on Enter
Hi group,
I had been struggling with a solution for a problem from many days..
Recently i had seen a macro in this group which is very much nearer to my
problem.The sample data is taken from one of the previous examples given by
guillet.
Going by the same sample data :
the main sheet contains the following columns with data underneath it.
Date Region Rep Item Units Cost Total
I want sheets to be added & updated based on each Region and with the date in
the chronological order.
If a sheet exists already with the REGION NAME there is no need to add the
sheet with the same name instead new data should be added from the main sheet
to the respective sheets (REGION wise)
I had attached the worksheet for reference.....Kindly help me....
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
UPDATE SHEETS_SAS.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
