Copying Data to another Sheet

[tomlancaster]

Hello, I am trying to create a spreadsheet which contains a list of Incidents with a status of "Open" or "Closed"

There are two sheets in my workbook. One with all the Incidents and statuses. I would like the other sheet in the workbook to copy data from the other sheet into the cells of that sheet where the status is "Open"

I've attached an example sheet.

I can't think of a formula that can pull in all the data from a different sheet that contains a value. Can anyone help?

Thanks

[windknife]

Try this
A2

Please Login or Register  to view this content.

Committed with Ctrl+Shfit+Enter.
then copied down.
You can also see attached file.
windknife

[romperstomper]

Could you not just use the autofilter function, then copy and paste? (Or better, yet, just use the autofilter so you only have one list to deal with)

[tomlancaster]

Windknife, thanks for that! Pure genius.

I didn't want to use the auto filter or any macros for this task, the formula provided works a treat :D