Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Office 2016
Get specific columns from another worksheet if condition is met
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I have an excel workbook which is updated daily (Sheet1) . I need to create another sheet (Sheet2) which will have specific columns from first sheet (Sheet1), if condition is met (Error = YES). Below are pictures of examples how this should look like.
What is the best solution to create report like its showed on sheet 2? Thanks in advance
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
{count} votes
7 answers
Sort by: Most helpful
-
Anonymous
2019-08-07T21:30:04+00:00 -
Anonymous
2019-08-08T02:21:59+00:00 Hi There ...
Try out a simple pivot with Error="Yes" as filter.