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
UPDATE SHEETS.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
