I currently have 2 tables with data, and I'm looking for a macro that can switch the two and remove a specific value.
I currently have the macro:
Dim container As Double container = Range("B3").Value Range("B3").Value = Range("G3").Value Range("G3").Value = container
to switch the two cells, but this has it's problems. I need to make one of these for every cell i switch and when one of the cells is empty, it becomes a 0. On a larger scale, this becomes a lot of work and with it being 0's it doesn't like it in other formulas.
IF anybody knows a easier way to switch them, or even just to make all 0's in to "" that would be great.