Organizing and Updating Data

[antsrik]

I am presently working with an excel worksheet with about 30 columns and 7000 rows. One columns (column AC) has one number ranging between 1-7. I would like to find a way to extract all the data for 1-2, 3 and 4-7 on three different worksheets while keeping this data in the structure as the original form i would also like changes are made to the original worksheet this change will feed and update the 3 sheets created. Changes can be made to any of the 30 columns including AC.

Please Help

 

[Datsmart]

I would suggest using Advanced Filtering.
Good example of Advanced Filter steps here:
http://www.contextures.com/xladvfilter01.html

AdvancedFilter Demo
http://www.contextures.com/xlVideos04.html

Another good link with sample VBA code here:
http://www.meadinkent.co.uk/xlfilter.htm

Advanced Filter allows you to preset filter options.
It also allows you to filter by criteria in ways standard autofilter can not do. You can choose an export location in the dialog box or in VBA code.
Once you setup the code and criteria, you can use a macro button to copy specific data from your main sheet to a "Report" sheet. The original data remains unchanged and the data "Filtered" to another page can be used as desired.