CODEWITHSUNDEEP
excelexcel-formulaexcel-2010conditional-formattinglookup-tables
Sean Parrish
Sean Parrish

Reputation: 13

How to extract rows of data from another sheet based lookup of "name", needs to be dynamic.

OWNER | REGION | PROGRAM | TOTALS | FORECAST | JAN | FEB | ETC

How can I lookup a name in the region column, "Europe" and then if it is true copy the entire row of data onto a new tab/sheet.

All of the regional data is contained in a table titled Table13, so I guess is there a way to reference the table and drill down on region and then copy the entire row of data onto a new sheet? I would like it to be dynamic so any time the table is update, the new sheet is also updated.

LOOKUP in table13, region region column = Europe copy entire row and paste into new tab/worksheet

I would prefer to not use a VBA due to company restrictions but if it is literally the only way I will have to use it.

THANKS FOR ANY AND ALL HELP!!! :)

Upvotes: 1

Views: 517

Answers (1)

virtualdvid
virtualdvid

Reputation: 2411

You can use Power Query it is an add-in for Excel 2010+ versions. You can download it and activate easily. There you can connect any data source and in the Query Editor, you can filter the field [Region] by "Europe", even you can unpivot the [Dates] fields for future analysis, and then it will create a table in a new sheet with your selected data.

Upvotes: 1

Related Questions