Hello to all you experts, i want to be able to filter a large amount of data to a single row that i can then use in other areas.
data consists of about 85 columns and 15000 rows of data, much of which is very similar. 1st filter would have about 15 unique names, each of which then limits the rows to several hundred 2nd filter will then limit the range to about 100 rows 3rd filter approx 20 rows 4th filter 2 rows 5th filter exact range required. Autofilter is the perfect option but, it does not allow me to define the row and then select the data, i.e. any of the 15000 rows could be the selection so how can i define the relevant cells into other formulas? Also even if it did i would have to include this large amount of data in every file created, up to 20/day. i was hoping to assemble 5 or 6 drop down boxes on 1 sheet, refer to a central data file populating the selection criteria for the 2nd with the results from the 1st etc. i have rcently posted on this subject and did have a response which would most likely have given me exactly what i need but at a cost, unfortunately i need top look for easier and cheaper alternatives. here's hoping, -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
