VBA copy entire row based on multiple criteria

[GEO81]

Hello!

I'm working on a macro and i need some help.
I need to copy the entire rows from another workbook to my active workbook if a condition is met. The condition is a combination or 3 other conditions conected with OR.

I'm giving an example below.
Lets say i have the below table and my condition is: If Value1 is =<30 OR Value2=<100 or Value3 =<50 THEN copy the entire row to my active workbook/worksheet.
Just to mention that i need the Input Values 30, 100, 50 to have flexibility to amend. So I need an Input Box to prompt the user to enter those 3 conditions.
So should i use a UserForm?

Also i have to ensure that Blank cells will not be considered as cells with Value=0.

Data1	Data2	Data3	Value1	Value2	Value3
Name1	A	1​	20​	150​
Name2	B	2​	10​	200​	10​
Name3	C	3​		100​	15​
Name4	D	4​	100​		50​
Name5	E	5​	80​	0​	60​
Name6	F	6​	35​
Name7	G	7​			40​
Name8	H	8​		120​
Name9	I	8​			80​

The Result should be the following Table:

Data1	Data2	Data3	Value1	Value2	Value3
Name1	A	1​	20​	150​
Name2	B	2​	10​	200​	10​
Name3	C	3​		100​	15​
Name4	D	4​	100​		50​
Name5	E	5​	80​	0​	60​
Name7	G	7​			40​

Any help is more than welcome!
Thanks!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.
Also hope that you are fully recovered!