Help With Transplanting Data

Occasional Visitor

Hello, I'm trying to use Excel to display information about some stocks and securities I'm interested in. I have a sheet organized so that each security has its own row, using the columns to record various attributes and details about that security. For the securities I currently own, the 'T' column contains a '1'. I would like to create a function that searches this worksheet, and copies each row that contains a '1' in the 'T' column to another sheet. I'm not sure if this is even possible, but it would certainly make things easier. 

2 Replies


Why not only sorting it? you can change the whole Range from A to T as a Table object:

Klick on A1.

Mark all cells in that range with CTRL - Shift - Arrow to right and CTRL-Shift-Arrow to down.

Then go to "Insert" Tab and click on "Table".

Now you have a table object. This object includes your former column titles AND a sort/filter option (the arrow key right of your first column).

Filter your T column with option "1".


Additionally you can poke around with the advanced filter options to get the filtered result to another table.


if there is an option like advanced filter, you can save time and nerves with a no-code solution.


For this advanced filter in Excel see my screenshot there:


Power Query is an option - query your range, filter T column on 1, remove T column, land result into new sheet. After that only refresh from time to time.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies