If cell = something, pick other cells along the row and display in another tab.

[badexcelguy]

Hi,

trying to get a workbook going with multiple sheets for viewing stuff. But I only want to enter data on the first sheet. On the other sheets i want to be able to select certain columns from the first sheet based on certain critera.

I am thinking it would be like

IF column D contains "park", place column A,B,C in sheet titled Park

Thanks all!

Image attached Screen Shot 2021-12-01 at 3.09.38 pm.png

[DJunqueira]

Would make more sense to add a Slicer to filter your data without adding new sheets for visualization.

[badexcelguy]

Would make more sense to add a Slicer to filter your data without adding new sheets for visualization.

Thanks mate but that’s not what I’m needing. Just gave it a go

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.