Need to create a new smaller table on new worksheet from a large table

[InterstateRentals]

We have a very large table that has a set of data that we want to separate onto a new worksheet. Additionally, we don't want all of this data to be brought over to the new worksheet, we only want certain data within this group to be moved to the new table.

See attached file please.

In the file, you will see COLUMN-A (labeled RE/RO/RL) .... and in this column you will see N/A's and RE's,RO's and RL's.

We want ONLY the RE's,RO's and RL's to be brought to the new tab (RE RO RL CREDIT CARDS) and we want the associated data to come with it.

We would prefer to do this without having to sort the original very large table.

Thank you in advance for any help with this problem!

[Pepe Le Mokko]

You could use a filter to obtain what you need

[InterstateRentals]

OK, thank you for the suggestion. I'll research how to do that.

Maybe a simpler solution to our problem would be to bring the entire table of information over to the new worksheet. We could sort it once it's separated from the large table.

So, in my example, is there a way to get A3:E14 (using a formula) onto the new sheet. Or will we need to write individual formulas (=A3, =A4, etc)?

Thank you.