Hello,
I would like to create a code that copys the non blank values from column A while meeting a value in column b and then adding it to a table
So for example if
A1 has text and b1 value = 1 then add a1 to table1
a2 is blank and b2 value =1 then skip
if a3 has text and b3 value=2 then add a3 to table2
And so on.
something like range("a:a") >="" and range("b:b") = 1 then add the values that meet the criteria to table1
If range("a:a") >="" and range("b:b") = 2 then add the values that meet the criteria to table2
If range("a:a") >="" and range("b:b") = 3 then add the values that meet the criteria to table3
If range("a:a") >="" and range("b:b") = 4 then add the values that meet the criteria to table4
Roboco
I would like to create a code that copys the non blank values from column A while meeting a value in column b and then adding it to a table
So for example if
A1 has text and b1 value = 1 then add a1 to table1
a2 is blank and b2 value =1 then skip
if a3 has text and b3 value=2 then add a3 to table2
And so on.
something like range("a:a") >="" and range("b:b") = 1 then add the values that meet the criteria to table1
If range("a:a") >="" and range("b:b") = 2 then add the values that meet the criteria to table2
If range("a:a") >="" and range("b:b") = 3 then add the values that meet the criteria to table3
If range("a:a") >="" and range("b:b") = 4 then add the values that meet the criteria to table4
Roboco