Only selecting certain rows when using = to copy data from one sheet to another.

I have an imported file whereby the data is in the incorrect order. I am copying this data into a file whereby sheet one is the raw data and sheet 2 is the order I require. I've done this so by using the very simple =Sheet1!A1 formula.

The only issue I'm having is that I only require the records whose rows contain a certain value (There are only three... 1, 2 & 250 - I only need those rows containing 1.)


I know this is simple enough with a filter but I am creating this for users who are not proficient in excel and I require as few steps as possible.

Is there a way to do this ?

Administrative Note:

https://www.excelforum.com/excel-for...o-another.html

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

Moderator Comment: Thread Closed due to duplication.