Copy row from one workbook to another workbook based on conditions in two other workbooks

Hi,
I am looking for a macro that will do the things mentioned below

If coloumn I of 1.xls matches with column Z of ap.xls & column K of ap.xls is equals to column L of ap.xls Then
Look column H of 1.xls & if column H of 1.xls is greater than column D of 1.xls then it has to copy the first row of OrderFormat.xlsx & pate it to BasketOrder.xlsx (in sheet1 & sheet1 name can be anything)

Or

If coloumn I of 1.xls matches with column Z of ap.xls & column K of ap.xls is equals to column L of ap.xls Then
Look column H of 1.xls & if column H of 1.xls is lower than column D of 1.xls then it has to copy the third row of OrderFormat.xlsx & pate it to BasketOrder.xlsx (in sheet1 & sheet1 name can be anything)

The output of the macro will be in BasketOrder.xlsx (I have mentioned the result plz see)

Thnx For the Help

Hi

Quote:

---

Originally Posted by fixer

.... (I have mentioned the result plz see)

---

It is not very clear what you mean.
it is better if you always show a Before,
and an
After

I will assume that your supplied , BasketOrder..xlsx is for After : See here
https://excelfox.com/forum/showthrea...ll=1#post14183

So

Before
_____ Workbook: BasketOrder.xlsx ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1
2

Worksheet: Sheet1 6July


After running macro ( https://excelfox.com/forum/showthrea...ll=1#post14184 )

_____ Workbook: BasketOrder.xlsx ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	NSE	EQ		NA	NA	NA	0		0	BUY	MARKET	NA	CLI	MIS	DAY	WC5758	NA			3	NA
2

Worksheet: Sheet1 6July

Macro here: https://excelfox.com/forum/showthrea...ll=1#post14184


Alan

---

OrderFormat.xlsx : https://app.box.com/s/kuzt08prbeyql5hpvn7bhd0vbgvbu4mo
BasketOrder.xlsx : https://app.box.com/s/y05b4hglggc4iyodf8qqipbrhsjjpovk
1.xls : https://app.box.com/s/38aoip5xi7018y9syt0xe4g04u95l6xk
ap.xls : https://app.box.com/s/pq6nqkfilk2xs5lf19ozcpx081rp47vs
macro.xlsm : https://app.box.com/s/z358r7tbc9hzthi539dlj49jsf4gyg8p

Note: I use BasketOrder.xlsx
You use BasketOrder..xlsx
It is very stupid and dangerous to use an extra .
But its your choice: You do all stupid things if you want to :)

Problem Solved
Thnx Alot Doc Sir for helping me in solving this Problem
Have a Great Day


"You use BasketOrder..xlsx"
I have not choosed it
Its the system
whenever i want to download the file everytime it puts this name to the file
So I cant do Anything in that