Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-16-2010, 11:26 PM
Nirik's Avatar
Nirik Nirik is offline creating macro for biffurcation in sheets according to data. Windows XP creating macro for biffurcation in sheets according to data. Office 2007
Smart Novice
creating macro for biffurcation in sheets according to data.
 
Join Date: Dec 2010
Location: Mumbai, India
Posts: 24
Nirik is on a distinguished road
Default creating macro for biffurcation in sheets according to data.


I have data containing column of zone (i.e state). I want that the sheet should diffurcate into sheets according to the states & also mentioning tha name of sheet according to the data (i.e if the data is of andhra pradesh, then the name of sheet should be andhra pradesh). The sample data of raw & result file is attached. the no of rows will be flexible & minimum rows will be 20000. the data of states will also change monthly. Thanks in advance.
Attached Files
File Type: xls sample file (raw data).xls (25.0 KB, 19 views)
File Type: xls sample file (result data).xls (34.0 KB, 17 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a MACRO Nikb3522 Word VBA 0 10-21-2010 05:55 PM
creating macro for biffurcation in sheets according to data. How to syncronize data in two different sheets diegogeid Excel 2 09-30-2010 12:19 AM
creating macro steveb Word VBA 0 08-14-2010 01:29 AM
creating macro for biffurcation in sheets according to data. How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft