"sumesh56" wrote:
4)i want something like this---

a)IF seatingplan!B4:E7,"=601"and "<=650",then copy
and paste the contents from seatingplan!B4=distribution!C4 and
seatingplan!D4:E7=distribution!D4:E4.

b)IF seatingplan!B12:E15,"=601"and "<=650",then copy
and paste the contents from seatingplan!B12=distribution!C5 and
seatingplan!D12:E15=distribution!D5:E5.

c)IF seatingplan!B22:E25,"=601"and "<=650",then copy
and paste the contents from seatingplan!B22=distribution!C6 and
seatingplan!D22:E25=distribution!D6:E6.

d)IF seatingplan!B33:E36,"=601"and "<=650",then copy
and paste the contents from seatingplan!B33=distribution!C7 and
seatingplan!D33:E36=distribution!D7:E7.

Sorry, but I cannot help you with that. I think it is a flawed approach,
lacking in generality.

Hopefully someone else will jump in.