Conditional replication of cell data

[Closed]
Report
Posts
1
Registration date
Monday March 2, 2015
Status
Member
Last seen
March 2, 2015
-
I am using Excel 2013
I am using a spreadsheet for a TO DO list.
The column headings are:
"Item" (with rows numbered from 1, 2....)
"Task Description" (row entries are free format text),
"Due date" (row entries are free format text);
"Priority" (row entries are selected from a drop-down menu, with options: high, medium, low, [blank])
"Remarks" (row entries are free format text)

I want to replicate each HIGH priority (only) table entry (complete row) at a different location, eg above the TO DO list.

Can you help? thanks!