Set filtered column in a table as a defined range

[sspatriots]

Trying to see if it is possible to filter a column in a table and defined those visible filtered cells as a named range to copy to another range in another table (different workbook). Right now, I'm just curious to know how to name a filtered column range to use further down in my code. Let's say I'm using "Table1" as my Table name and using "Employee Last Name" as my column heading. I filter this column to find all Last Names that start with "W". How could I define these Employee last names that start with "W" as a named range and then make them equal to another range further down in my code that belongs to another table.

Any help would be much appreciated. Thanks, SS

 

[SanjayGMusafir]

I'm just curious to know how to name a filtered column range to use further down in my code

Not sure that you can filter a table and name it separately

BUT you can use FILTER Function on a table and use the results as a Named Range

Hope it helps you in some way.

 

[sspatriots]

Not sure that you can filter a table and name it separately

BUT you can use FILTER Function on a table and use the results as a Named Range

Hope it helps you in some way.

I've been trying to figure out how to do this, but now luck so far. It want's to recognize the entire range only (before filtered).

 

[SanjayGMusafir]

Check this and revert - Hope it helps you in some way

Book1
	A	B	C	D	E	F	G	H	I	J
1	Code	Department	First	Last		W	Code	Department	First	Last
2	A 0001	Sales	Test	Aaron			A 0002	Sales	Test	Walts
3	A 0002	Sales	Test	Walts			A 0004	Production	Test	Walter
4	A 0003	Sales	Test	Chris
5	A 0004	Production	Test	Walter
6	A 0005	Sales	Test	Finch
7	A 0006	Production	Test	Bruce			A 0002	Sales	Test	Walts
8	A 0007	Sales	Test	Phillips			A 0004	Production	Test	Walter
9	A 0008	Production	Test	Brown
10
Sheet1

Cell Formulas
Range	Formula
G1:J1	G1	=Table1[#Headers]
G2:J3	G2	=FILTER(Table1,LEFT(Table1[Last],1)=$F$1)
G7:J8	G7	=FilteredEmployee
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
FilteredEmployee	=Sheet1!$G$2#	G7

 

[sspatriots]

I marked your response as the solution because I did use it to get most of what I needed. Thank you. I will be posting a follow up question regarding something else I've run into. Thanks so much, Steve

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.