sheet generation based on status

[siddiqsh]

I have a big data sheet and I need to generate a separate sheet comprising of few columns of the main data sheet. I have attached sheet for better under standing

[azumi]

If you are not bothered with helper table so try this

[siddiqsh]

If you are not bothered with helper table so try this

thanks for your input, I'll incorporate it and give feedback if I see any other issue.

[siddiqsh]

thanks for your input, I'll incorporate it and give feedback if I see any other issue.

it is working well. in the same sheet i tried to have images using this video https://www.youtube.com/watch?v=wlW2UKml9CY. if anyone has any input how to have images in multiple cells. defining name for each cell with unique formula is tedious.