Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Filling cells with filtered data to another sheet.
I am using Excel 2007. On sheet one I have a database of text and numerical
data in which I am using filters to narrow down. What I want to be able to do is to transfer only the shown data (that is filtered) on sheet 1 to another sheet automatically. The reason for this is that some of the info of the filtered data needs to be put into a different format on sheet 2. Is there a way to do this? Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-filling cells from another sheet | Excel Discussion (Misc queries) | |||
Updated filtered data on next sheet | Excel Discussion (Misc queries) | |||
Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
Counting Unique Cells When Spread Sheet is Filtered | Excel Worksheet Functions |