Conditional copying of entire row across worksheets

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
 
R

Ron@Buy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Copy addition formula of non-consecutive horizontal cells 2
Copy data automatically from sheet1 to sheet2 0
Consistent Sheet column header rows 2
Array with many cells from a row but not in order or together 11
Can you display entire rows that match a certain criteria... 1
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Copy and paste from one tab to another with certain rules using VBA 3

Top