Filtering out Data
Hi
i have a spreadsheet, were i want the user to input all data onto the first worksheet. I then want to be able to transfer, certain rows based on set criteria to other worksheets. Is this possible using any excel functions, or does it require me to use macros and or programming Cheers Jo |
Hi Jo,
Use rhe Advanced Filter feature on the Data menu. Debra Dalgleish has an excellent tutorial on Advanced Filter at: http://www.contextures.com/xladvfilter01.html Note particularly, Debra's instructions for 'Extractng data to another worksheet' --- Regards, Norman "Jo Davis" wrote in message ... Hi i have a spreadsheet, were i want the user to input all data onto the first worksheet. I then want to be able to transfer, certain rows based on set criteria to other worksheets. Is this possible using any excel functions, or does it require me to use macros and or programming Cheers Jo |
All times are GMT +1. The time now is 03:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com