I know that in a properly balanced equation that no same species should appear on both sides of the reaction so I cancelled out NO3- on both sides
That's not correct. That is, you are right that no species should end on both sides, but NO
3- gets reduced to NO
2, so you can't remove before balancing.
Cu(s) + 2H + (aq) --> NO2(g) + H2O(l) + Cu2+(aq)
I'm not sure if this is correct, can someone please provide guidance?
Simple check - balanced reaction has the same number of atoms and the same total charge on both sides. Do you have the same number of atoms of oxygen and nitrogen on both sides?