Kubas
06-08-2016, 05:09 PM
Hello,
This is a bit complicated and I am trying my best to explain it.
I am trying to find a VBA code which triggers input box when specific criteria is found in data.
The data has a transaction codes and when criteria from columns A,B,C match it means it is 1 delivery.
Criteria for a delivery is (Part 1,Identify, PERM-CRE-LOC).
Column A
Column B
Column C
Part number
Activity code
Operation code
Part1
Piece pick
PERM-CRE-LOC
Part1
Identify
PERM-CRE-LOC
Part1
General movement
PERM-ADJ-LOC
Part1
Identify
PERM-CRE-LOC
By using this formula it returns a value of 2: COUNTIFS($A:$A,""Part 1"",$B:$B,""Identify"",$C:$C,""PERM-CRE-LOC"") . Which means I had two deliveries.
Is there a way a VBA can do this search and when it finds the matched criteria(delivery) then it triggers the input box?
I would like input box to give two options:
1st type in the quantity and 2nd to type in the quantity. Then the typed quantity placed in a different worksheet in specific range? i.e "Worksheet1" range A2 for 1st input and range B2 for 2nd input.
Can input box also display the number of total found criterias (Deliveries)?. Please help.
Many thanks
This is a bit complicated and I am trying my best to explain it.
I am trying to find a VBA code which triggers input box when specific criteria is found in data.
The data has a transaction codes and when criteria from columns A,B,C match it means it is 1 delivery.
Criteria for a delivery is (Part 1,Identify, PERM-CRE-LOC).
Column A
Column B
Column C
Part number
Activity code
Operation code
Part1
Piece pick
PERM-CRE-LOC
Part1
Identify
PERM-CRE-LOC
Part1
General movement
PERM-ADJ-LOC
Part1
Identify
PERM-CRE-LOC
By using this formula it returns a value of 2: COUNTIFS($A:$A,""Part 1"",$B:$B,""Identify"",$C:$C,""PERM-CRE-LOC"") . Which means I had two deliveries.
Is there a way a VBA can do this search and when it finds the matched criteria(delivery) then it triggers the input box?
I would like input box to give two options:
1st type in the quantity and 2nd to type in the quantity. Then the typed quantity placed in a different worksheet in specific range? i.e "Worksheet1" range A2 for 1st input and range B2 for 2nd input.
Can input box also display the number of total found criterias (Deliveries)?. Please help.
Many thanks