How do I only pull rows if the data matches a named range?

A

Aneske

I have a sheet in my workbook as a named range. Another sheet has rows of
data with about 20 columns of information for each entity. I want another
spreadsheet to pull only those rows if one column matches a value in the
named range.



Sheet 1/B2:T57 - each field is a different number

Sheet 2 - Each row has columns of information about different entities.
Column F might match information in a field on Sheet 1

Sheet 3 - Pull all information (entire row) from Sheet 2 only if value in
column F matches a field value in the range on Sheet 1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Setting a range in a named range 3
Match and delete rows on two different sheets from reference numbers 4
Copy entire row from another sheet onto first sheet if a unique text matches 1
How can I print rows that go outside of the page without shrinking the text? 0
Need Help with a VBA subroutine 0
Converting a number into a cell reference 2
Simple? View named range from sheet1 on sheet2 1

Top