Importing data from one sheet to another

[loleffe]

Dear All,
I have a problem building my excel sheet

Let's say I have a workbook with 4 sheets:

- Sheet1 called NEW
- Sheet2 called OPEN
- Sheet3 called NO CR#
- Sheet4 called DATA INPUT

My sheet4 contains 4 columns (CR#, Description, Requestor, Status)

The latest column STATUS can have 3 values NEW-OPEN-NO CR# ..

I would like to find a way for Excel to display for instance in sheet1 'NEW" all rows from Sheet4 for which contain the value "NEW" in the Status column. same for sheet2 with OPEN status ....
Of course i can be a piece of VBA ... no issue with that
Thanks a lot in advance for any type of info you might provide.

Regards
Laurent

[Flintstone]

Laurent, try this.

[loleffe]

Hello Flintstone,

Thanks a lot for your help and the awesome response

Let me also share an answer I got from another forum

Please Login or Register  to view this content.

I hope this will help other people

Long Live to the users community

Laurent