Display only filtered values from sheet 1 to sheet 2 (text and numbers)

Hi

is there any formula to display only filtered units from one place to another place in the same workbook:

screenshot.77.jpg

workbook in attachment

Sheet 1 is list with filter, when filter applied I want to display filtered rows to sheet 2

crossposted link: https://www.mrexcel.com/board/thread...mbers.1179681/

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Apply this formula in any blank cell in your Sheet2, drag and fill it to the range.

Formula:

Please Login or Register  to view this content.

If you have Office 365, simply use FILTER function as below:

Formula:

Please Login or Register  to view this content.

Attach a workbook, not an image - we cannot troubleshoot a picture.

\Which version of Excel are you using?

If you allow me to use helper column.

In sheet1
O1 [ copy down ]

Please Login or Register  to view this content.

In sheet2
B1 [ copy to right/down to M10 ]

Please Login or Register  to view this content.

Regards.

This last works almost ok. It displays all data but when filtering at sheet1 it's not showing very well.


Office 2016


attached file

The formula in column O are refer wrong row.

Please confirm that
O1
=SUBTOTAL(103,B1)

and so on.

Regards.