Thread: If/Then statements

Hi All,

I have a Quote tracking sheet, please see attached.

I would like to create a 'if/then' statement where if in sheet 1, M5 the cell states "rejected", data from sheet one (range A5 - L5) will appear in sheet 2.

Any suggestions?

Hi,

You'd be better advised to use a Data Filter with a criteria set to 'Yes' on the Rejected field.

I suggest you create a dynamic range name called "data" which will cover your Sheet1 data, and create an output range, say "DataOut" on sheet 2 A3:L3.

This will avoid formulae and has the advantage of only listing records that meet the criteria.

HTH

Thank you Richard... I haven't used data filters before... any suggestions?

Hi,

See the attached.

For reference the filter macro attached to the blue button is:

Code:

Sub FilterData()
Range("Data").AdvancedFilter action:=xlFilterCopy, copytorange:=Range("DataOut"), criteriarange:=Range("crit")
End Sub

Regards