Conditional copying of entire row across worksheets

  • Thread starter Thread starter Marish
  • Start date Start date
M

Marish

Hi there,

I am wondering if there is a way to do the following in Excel:

IF value in rows B onwards of column E in worksheets Sheet2-Sheet8 = "Critical" THEN

Copy the contents of that row into Sheet1?

Many thanks!

M
 
To provide you with a solution, much more detail of each of your worksheets
is required, eg:
row B - rows are normally numbered !
What is the cell(s) reference where "Critical" appears ?
Are all the worksheets 2 - 8 laid out the same way ? ie column headings are
the same on each sheet.
Is "Critical" liable to appear in the same row on different worksheets ?
Can you give some sample data ?
Answering these questions may give somebody a lead to providing a solution
 
Back
Top