Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting data from another workbook based on variable | Excel Discussion (Misc queries) | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Filtering data in Excel for mailmerge to Word | Excel Discussion (Misc queries) |